DaveV's Q&A profile

• SQL Server Update Query Taking 23 seconds

  I am not sure if I am in the correct location or if I should be in the SQL forum but here is my question: I have an update statement that goes out through SQL 2000 through a local linked server to another SQL 2000 server on my machine. When I run the update in Query Analyzer it takes less than a second. When I run it in my C# code using the SqlCommand object and parameters it takes me ~23 seconds. If I remove one of the parameters it goes down to ~15 milliseconds. Has anyone heard of this happening The parameter that I remove is a simple char(10) column that isn't the primary key and is used in the WHERE statement. There isn't an index on the field. 23 Seconds Update table Set column = @val WHERE field = @field AND other = @other ...Show All

• Visual C# Problems with error CS0118!!!What to do???

  Hello.I wan't to create a animation in DirectX so I went to this site http://www.riemers.net/Tutorials/DirectX/Csharp/tut2.php to learn.But I receive error CS0118!!!Why Here are te content of the files: Program.cs: using System; using System.Collections.Generic; using System.Windows.Forms; namespace The_City { static class Program { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { using (TheCityEngine EngineConnection = TheCityEngine()) { EngineConnection.InitializeDevice(); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new TheC ...Show All

• Visual Studio 2008 (Pre-release) .Net 3.0 / Linq doubts

  Hi, I have lots of doubts regarding .Net 3.0. I have installed .Net 3.0 final version runtime and vs 2005 extensions nov 2006 ctp. I am developing XBAP applications. After knowing about LINQ I installed linq May 2006 CTP. is this the latest version Any final version released In the new project window why i am seeing linq preview and in the right pane I see linq console / linq window app e.t.c is that not possible to use in WPF / XBAP applications I have mentioned my environment above now when i try to open the samples available in linq May 2006 CTP it says "This is unsupported version of Microsoft Visual C# 3.0 / Microsoft Visual Basic 9.0" Please guide me on all the above. Also is it advisable to devel ...Show All

• Visual Studio 2008 (Pre-release) IValueConverter and ValidationRule in Binding

  In Binding, I want to use IValueConverter and ValidationRule. At that time, I want to evaluate the result of conversion with IValueCo nverter with ValidationRule. How should I do There are samples in the sdk ms-help://MS.MSSDK.1033/MS.NETFX30SDK.1033/wpf_samples/html/dba50aaa-a436-47d3-a850-1f3cd58e9141.htm ms-help://MS.MSSDK.1033/MS.NETFX30SDK.1033/wpf_samples/html/9a5f1195-f84e-439e-a752-1564c4ef220c.htm ...Show All

• Windows Forms Other version is already installed

  I get this error message running setup created by VS 2005 Setup and Deployment project. Setup asks to remove old version of the program and install new one after this. What can I change in the setup project to prevent this - I want to update existing application without removing it. I tried to set RemovePreviousVersions to true, change UpgradeCode - this doesn't help. After Phil's helpfull direction, here is what I found in experimentation .... It seems a good idea to keep the setup project version the same as the application version. However, I found they are incompatible with each other! The application version requires a format of 1.0.0.0, and will not let you leave off any of those segmen ...Show All

• Visual C++ calls to unmanaged dll to create a socket result in debug assertion

  I have an unmanaged C++ dll which is an MFC shared DLL that has functions in it to initialize sockets and do other ethernet related things. I have built a managed C++ wrapper project which is also an MFC shared DLL, compiled with /clr that calls functions in the unmanaged dll. Then I have a C# project which instantiates a member of the wrapper class to access the unmanaged functions. One of the functions in the unmanaged dll creates a new CAsyncSocket, checks to see if AfxSocketInit is successful, and if so, calls Create to create a new socket. When I call this function through my wrapper from C#, I get a debug assertion when Create is called. The call stack trace indicates that the problem is in a call to AfxGetInstanceHandle. I've done ...Show All

• SQL Server Access to SQL Server System Logs

  I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this Hi, no this is the most common way to do this. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio 2008 (Pre-release) Change rectangle property from code

  Hi guys, i've got a rectangle i've drawn in a grid, how can i change its propertys from code, i think i need to build once or something, should i be using X:name or something...FindName, i'm a bit lost, thanks guys si in that code sample you are missing the KeyDown event KeyDown = " OnKeyDownHandler " ...Show All

• SQL Server Clustering , how to start ?

  Dear Friends, i'm using windows 2003 server on both computers i wanted to practice clustering with sql 200/2005 [two nodes] but it asks for a quorum disk as a shared disk between the two clustered nodes, i didn't know what a quorum disk it, the internet when i searched for says that a quorum disk should be either a scsi or fiber channel disk, i've never seen a scsi disk, i'll purchase it today, but what i'm confused about is, how will i connect one single scsi disk two two computers/nodes i mean does a scsi disk have a long cable to connect to and if yes, then where does the cable fit in on either of the nodes, or is it not physcially shared then if it's logical then how do i configure it. pls reply soon, regards, and thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Source Control for XNA Projects

  Previously, when we were using MDX 1.1 with C# we were able to use VS2k5 with a SourceSafe server on a machine running Windows Server 2k3. To my understanding, VC# Express does not integrate SourceSafe into the IDE like VS2k5 does. If that is incorrect please let me know. What options for version control do we have using VC# Express Thank you. There are no integrated add-ins for express so if thats what you want you are out of luck. However all version control tools come with their own UI for checking in and out so you just have to do it yourself using that. So any of them will do including VSS ...Show All

• Smart Device Development Back Up SMS online?!

  Hello! I need a software for pocket PC 2003 to transfer arrived SMS from pocket PC to desktop computer as the SMS arrived. Please give me the download link or the name of the software! Thanks This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. Please post to relevant forum or news group: http://support.microsoft.com/newsgroups/default.aspx Closing as off topic. ...Show All

• Visual Studio Tools for Office VSTO processing many files

  Hi All, I'm new in VSTO and I'd like to use it to automate some tasks in .DOC and .XLS files. According VSTO documentation, "a managed code assembly is attached to a Word document or Excel workbook." So, what does it mean Is not possible for example create VSTO app to interact / process many .DOC or .XLS documents My scenario is, I have thousand of .DOC and .XLS files and I'd like to create a solution to open each file and make some changes. How can I do that Thanks, Armand Based off what you're saying you want to do, I would implement this using the standard Word automation interface, via the programming language of your choice ... The VSTO binds a managed solution to a particular template/d ...Show All

• Visual Basic How to using variables stored in VB6 in my .Net forms?

  Hi I have a vb6 application who should have been upgraded to .Net, and finally it seems that this toolkit (Interop Forms Toolkit 1.0) can help do the upgrade in steps. My Question is: Is it possible to call my variables I have used in my VB6 code in my new .Net Forms Jan Hi Bryan Thanks for the information on how to pass data. However, I have tried passing data from vb6 to .Net via a property of type object but in the .Net side, I cant access the items in the collection( The data is actually a collection of staff). Only prinitive types like strings and integer apear to be passing the data. Also if I try to reference my VB6 staff dll in .Net so that I can define a property that is relevant to what I'm passing ...Show All

• Visual Studio Express Editions Green Squiggly Line

  Hello. Can someone please tell me what the green squiggly line means exactly. The routine seems to work with them but is it alright to have them I have a message with them which goes as " Access of shared member - etc. " How can we get rid of them I am pleased tohave your answer. Thankyou. Hello. Thanks for your reply. It helped me into knowing more about VB and in the fact that it is what the Warning is about that I should have given a better subject title to this thread. I am new to the Regex 'thing' and am trying to learn more. I picked up a routine from the internet and it in the coding that I got the warning: "Access of shared member, constant member, enum member or nested type through an instance; quali ...Show All

• Visual Studio Express Editions Formatting output in a textbox/label

  Hi I'm writing a program that basically calculates two numbers entered via text boxes then outputs to a label on the form. Sometimes I get a number with three decimal places. How do I change this to just show 2 decimal places Also, I have six rows of three columns. Is there an easier way of assigning a value to these similar to using an array For example, I currently have to assign a value to an array for (int a = 0; a < 5; a++) { arrayvalue[ a ] = a; } Then output individually to each textbox textbox1.Text = arrayvalue[0]; textbox2.Text = arrayvalue[1]; textbox3.Text = arrayvalue[2]; etc Can this be changed to for (int b=0; b < 5; b++) { textbox[ b ].Text = arrayvalue[ b ]; } Or am I just being super lazy lol! It is fini ...Show All