kats's Q&A profile

• Visual C# why my try/catch statement "loops"

  hi! i have three succeeding try-catch-finally statements but it sort of "loops" when i run the program. this is basically the code.. . try { insert1.Connection.Open(); insert1.ExecuteNonQuery(); } catch ( OracleException ex) { MessageBox .Show(ex.ToString()); } finally { MessageBox .Show( "insert1 done!" ); insert1.Connection.Close(); } try { insert2Connection.Open(); insert2.ExecuteNonQuery(); } catch ( OracleException ex) { MessageBox .Show(ex.ToString()); } finally { MessageBox .Show( "insert2 done!" ); insert2.Connection.Close(); } try { insert3.Connection.Open(); insert3.ExecuteNo ...Show All

• SQL Server Need textboxs in a table to show zeros if no record found - not a NoRows message

  I need a way to have the text boxes in a table to show a 0 if there is no record found for the query (not looking for a NoRows message). I've tried setting a default value for the textbox, but it isn't displayed since the query is empty. Is there a way to setup the query to have an if statement that would return a value of zero for the fields as in: If recordcount =0 then set field to 0 stupid question, but is your textbox set to visible ! try the expression ="test" and test if you see it, if this works, the IIF should also work you could also try to change the format of the cell greets ...Show All

• SharePoint Products and Technologies setting the default page

  Hello, I've read a post or two that says under site settings - look and feel - there should be a section for the welcome page. I do not see this. I logged onto two SS2007 sites, one of which i installed myself and made myself the admin so i should have access to everything and i dont see it on there either. I tried renaming default.aspx to default2.aspx and then renaming my page to default.aspx but that had no effect, it just bounces you to default2.aspx now. So how can i make another page the default welcome page thanks When you are logged in as an Administrator, click the "Site Actions" menu bar, select "Site Settings" and then click on "Modify All Site Settings". Under the ...Show All

• Windows Forms Reload the DataGrid

  Hi, I am generating a datagridview with few columns and its loading fine when the form loads. But when I add new entry through another form and reload the previous datagridview I see rows are duplicated twice or more. Why is this happening Thanks. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. BasicEffect, adding a texture and redering it.

  I'm trying to add a texture to a cube using the built-in BasicEffect class. Can't seem to get the BasicEffect technique to render the texture. How does one set the BasicEffect technique to allow rendering the texture Here is the cube set-up: public static VertexPositionNormalTexture[] MakeCube() { VertexPositionNormalTexture[] nonIndexedCube = new VertexPositionNormalTexture[36]; Vector3 topLeftFront = new Vector3(-0.5f, 0.5f, 0.5f); Vector3 bottomLeftFront = new Vector3(-0.5f, -0.5f, 0.5f); Vector3 topRightFront = new Vector3(0.5f, 0.5f, 0.5f); Vector3 bottomRightFront = new Vector3(0.5f, -0.5f, 0.5f); Vector3 topLeftBack = new Vector3(-0.5f, 0.5f, -0.5f); Vector3 topRightBack = new Vect ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I would be right here waitting for you XNA

  It's 22:14 Aug 30,CHINA to be or not to be , My God ! where,where can I download XNA. zzzzzzzzZZZZZZZZZZZZZZZZZZZZZ I will be right here waiting for you ... Les sanglots longs des violons de l'automne ... PS: 5:30 PM here in France ...Show All

• SQL Server Users Folders

  Hi, I am wanting to manage my users folders. Now, I can see them, but I cannot see their "My Reports" folders. Also, if I publish a report to their "user" folder, they cannot see it. What am I missing with permissions Thanks! Users folders is part of the my reports feature: /Users Folders/<user name>/My reports put content in the user's my reports folder and they should be able to see the content. Users do not have access to their folder /Users Folders/<user name> by default. If you login as a local administrator on the reports server computer you can set the permissions. You can grant any of the existing roles or define your own. To navigate to the < ...Show All

• Software Development for Windows Vista WF RC5 (Sept) Causes VS2005 Hang with 50% CPU

  Ok, I have re-created this on two machines. I install the whole WinFX, err, .NET Framework 3 stack from Sept RC on the machine in order (I have done it a million times so I have the order burned into my head) and after I install the WF RC5 with integration with VS2005, when I attempt to bring up VS2005 after, it hangs VS with 50% of the CPU and never comes up. As soon as I uninstall WF, it comes up instantly, as before. Does anyone know whats' going on Also, even on machines that I did get it installed and working I am having trouble opening the WF samples from the SDK, as it says that project type is incompatible Thanks in advance, Sam Gentile INETA Speaker, Blog http://codebetter.com/blogs/sam.gentile/ It's not like ...Show All

• SQL Server SQL Timeout through ADO but not from Query Analyser

  I have a strange problem running a stored proc in SQL 2000. The proc returns XML and I'm using ADO to call the proc and return the data as a stream. When I call the proc through ADO, it times out because it is taking 40 seconds to run and my command timeout is set to 30. I can increase this no problem but the strange thing is that when I run the same proc from within query analyser, it completes in under a second. I put profiler on it tracing the command start and finish events and it's definitely taking 40 seconds between start and finish. The proc is used with various input parameters and the timeout is only occurring for some combinations of inputs, but it always seems to take much longer than it does when run from query analyser. Can ...Show All

• Microsoft ISV Community Center Forums Help with FileSearch

  Hello all! Well, I'm a newbie here, to VB as well. I'm currently learning to write macro for Solidworks, which is a CAD software. In the Solidworks macro, I'm trying to use the FileSearch object. So, I added reference to Microsoft Office 11.0 Object Library. Then, what would be the next step so that I can use FileSearch I have looked at Object Browser, but I don't understand it. Some pointers on Object Browser would be great too. Thanks. cc When I run the code, I get the following: Run-time error '438' Object doesn't support this property or method. Here's my code: Option Explicit Dim fsoFileSearch As Office.FileSearch Sub main() Dim i As Long Set fsoFileSearch = Application.FileSearch With fsoFile ...Show All

• SQL Server How to manipulate string in query and create new field

  I'm very new to SQL server and can use some help. MyTable has ColumnA, which contains strings composed of 1 to 4 numeric characters (0 thru 9) followed by alphabetic characters. For example, "53ASDF". In my query, I need to create ColumnB, which takes the numeric prefix from ColumnA's string and prepends it with zeros, if necessary, to create a string of exactly 4 numeric characters. For example, I could get the following result: ColA ColB "6abc" "0006" "457def" "0457" "7232hij" "7232" I have implemented a temporary solution using a CASE statement: SELECT ColA, ColB = CASE WHEN ISNUMERIC(LEFT(ColA, 4)) = 1 THEN (LEFT(ColA, 4)) W ...Show All

• Visual Studio Multi-projects solution managment

  Hi, I am developing a WinForms application.I manage solution with multiple projects (by adding an existing project to the solution), so part of projects keeps a refference to other part of projects. When one project was changed, for compiling it I need to remove it's refference from other projects that keep it and after finishing compiling I need to set the reference back to all other projects that keep have to keep it. What will happen if 1000 projects keep this refference: 1000 times removing and setting back the refference. Does not sound nice !!! Any suggestions from experienced developers or project managers will be appreciated. Thanks in advance, Caesar Zavaluev In VS you will never need to delete and re-add project ...Show All

• Windows Forms Fix for DGV DataError

  Is there a fix for the the DGV DataError for invalid value in a DGV Combobox.column I had everything working around this and some minor changes - that should have no effect - suddenly started generating the DataError. The last time, I deleted the DGV and created a new one and the error stopped. I guess the question is: Does the SP1 solve the DataError problems associated with the DGV Combobox column. In particular, format and display Still, if there is a way - even in code - of looking at the raw data after it comes into the dataset, but before its gone to conversion and formatting, then it would help to understand what circumstances causes the error. Certainly some errors must be legitimate while others ...Show All

• Visual Studio Express Editions [VB2005] Reading from serial port, pls help!

  Im currently working on serial port RS232 communication, im able to set configurations thru serial port to my device, but having problems reading from the port. Ive been advised that there're two ways of doing it, which include write the program so that the incoming data is stored inside certain file on computer and data can be extracted straight away from it..well another one, is extracting the data from the computer temporary memory.. but i have doubts regarding those methods and totally have no clue of performing the task, can someone please give me some guidelines of reading data from serial port thanks in advance! if I understand correctly you wish to read data from a serial port correct if so, you ...Show All

• Visual Studio 2008 (Pre-release) How can I use an value of some property of control in control template for this control?

  Hi! Please see comment in source code. Thanks. Source: < ResourceDictionary ... <!-- SimpleStyles: ToolTip --> < Style TargetType = " ToolTip " > ... < Setter Property = " Template " > < Setter.Value > < ControlTemplate TargetType = " ToolTip " > < Border x:Name = " Border " CornerRadius = " 1 " BorderThickness = " 1 " Background = " {StaticResource WindowBackgroundColorBrush} " > < ContentPresenter Margin = " 2 " HorizontalAlignment = " Center " VerticalAlignment = " Center " RecognizesAccessKey = " True " > </ ContentPr ...Show All