Julien Erard's Q&A profile

• .NET Development How to add index in DataTable so .Select() command will run faster?

  Is there anyway (not brute force) to add index in DataTable I have a big very table that I need to select some rows fast and those fields that I need to query are not primary key. Thank you!! Do dt.Select( null, "yourcolumn" ); // query with null filter and see if subsequent queries improve their perf. --VV [MS] vascov@microsoft.com ...Show All

• Windows Forms e-Business Project

  Hi I have started a post graduate degree in MSc e-Business Systems Design, and I would have to develop a system of my choice for my final project. It has to be something not simple but not too large, and something that has real world applicability. I want to develop it in .net and I was wondering if anyone had any suggestions for a  ...Show All

• Visual Studio Multiple computer install for single user

  Hi, is is ok to install Visual Studio 2005 on a desktop as well as a laptop provided only one person was using it No, according to the usage terms (end user license agreement), you can only install one licensed copy on one machine. ...Show All

• SQL Server Behind the Scenes SQL commands

  Hello, I am running SQL 2000 SP4 on a Windows 2003 standard edition server. The SQL database gets changed/updated through a web interface. I was wondering if there was any way for me to see which SQL commands were being run on the database when changed like deleting/inserting users are being applied from the Web frontend Any help is appreciated, thanks. Robert Take a look in Books On Line at using Profiler, this is not available in MSDE, so if you are using MSDE then take a look for articles on uing SQL Trace. ...Show All

• Windows Forms How do you use HIDDEN HTML INPUT in WinForms?

  Hi, I want to make a link to a site of mine that takes hidden input parameters. Does anyone know if this can be done Thanks for any help!  :) Oh sure!  Yeah that's what I used, the only problem is I couldn't find out how to put the form, and all it's controls into the request!  See what I mean I'm sure there's a& ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Floating Point arithmetic difference between VB and C#

  I am in a bit of state at the moment, I am really surprised at what I have found, please see the two code samples below. The first is Visual Basic and yields a result of: 100040624.0 the second C# and yields a result of: 100040629.0, which is correct. This error is causing my Line Circle intersection function to fail!! Oh my God have just spent the last two years writing my app in VB and now have to convert to C#. Dim a, b, c As Double a = 10002 b = 25 c = a * a + b * b result: 100040624.0 double a,b,c; a = 10002; b = 25; c = a * a + b * b; ...Show All

• SQL Server active/active clustering

  how does an active/active cluster work with sql server What about both servers trying to write to the same database files Each has their own locks. How does active/active work with such constraints If you were going to do that, there really wouldn't be any point in configuring clustering at all. You would simply drop in Database Mirroring with a Database Snapshot created against the mirror database. Actually gives better fault tolerance than clustering, because you have two copies of the data and it gives better availability, because mirroring reacts more quickly than clustering does. And, you wind up in ex ...Show All

• Visual Studio Express Editions How to get and/or set IP address?

  Hey, I'm using VB Express 2005 and I'm trying to write a small program to configure remote network devices. In order to do the initial configuration, I need to get the IP address of the local hard-wired ethernet adapter, or set it. One way of doing this, I figured I could set the local hard-wired adapter to DHCP and connect it to the device. Windows would assign an automatic IP address, which I could simply obtain. I would much rather be able to assign a specific IP address, do what I need to, and the re-set the adapter to its previous settings. Finding the correct hard-wired adapter could be as simple and promting the user with a list of ...Show All

• Visual Studio Team System Web Test recording unreliable - help!

  I've just installed the release version of VisualStudio Team Suite 2005, to use the web testing tools. (I had previously used beta 2 on a different PC). I go through the standard process of recording a web test. However not all the posts are recorded. In more detail:  - Start recording - OK  - Type in the URL of our logon page (we use our own authentication) - OK  - Enter the logon credentials and press Logon - OK  - We do a Response.Redirect to our 'main page'. Our URL remains fixed after this, including the query string.  ... The web test recording does not spot this, so type in the URL manually - OK  - S ...Show All

• Visual Studio Team System UPGRADE FAILED Unexpected Error: An internal error occurred on the report server.

  When attempting to upgrade from Beta3 Refresh to RTM I encountered an error that I can't find my way around.  The error messge indicates that my account does not have the required reporting services rights. I've tried running the update using the TFSSetup account and a domain admin account with no luck. Any help would be appreciated. John Miller Below is the upgrade log. Beginning upgrade from Beta3 to RTM DB ServerName : fhrvsts Log File      : TFSUpgrade-632811681589456499.txt Connecting to SQL Server fhrvsts Success Verify if core team foundation databases exist Success Fetching Server locat ...Show All

• System Center Connection Speeds

  Is there a way to edit the circit sizes for site-to-site connections. I need a 3MBPS speed and only see T1-1.5 and E1 2 As a workaround you can select a higher communication speed and specify the appropriate percentage of bandwidth to be available for your application. For example, you could specify a J3 (31 Mbps) line and set the available bandwidth to 10%. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rotation matrix: absolute rotation instead of relative?

  Hi, When multiplying rotation matrices for rotating around x, y and z-axes R = Rx * Ry * Rz ( http://en.wikipedia.org/wiki/Rotation_matrix ), I get a relative rotation matrix, meaning that rotation around Y is not the original Y-axis, but the new axis that has "occured" after rotating around X. What I want to do, is to have absolute rotation, so that the Y-rotation is performed around the original Y-axis, and not the new one (absolute rotations instead of relative). If you know the math for this, I would appreciate if you let me in on it :-) Thanks!! > I get a relative rotation matr ...Show All

• Visual Studio Express Editions New project problem

  I have installed, removed and reinstalled Visual Express and keep getting the same error message when trying to start a new project in Visual Express "The file name, Directory name or volume label syntax is incorrect (Exception from HRESULT : 0x8007007b)" My system is an AMD 3200 64bit running Windows XP Professional and is upto date with all service packs - any sugestions or ideas would be greatly appreciated.  Have a look at the following Support article, http://support.microsoft.com/kb/897299/en-us ...Show All

• Visual Studio Team System Sorting by Rank sorts incorrectly

  Rank is an integer field - but when you sort it and you have say 13 items ranked from 1 to 13. When you try and sort it in the UI by Rank it will rank them 1, 10, 11, 12, 13, 2, 3,4,5... Since the UI only allows integers in this field - sorting it like a string isn't right - I am using the RC version. Hello Bryan, You are right- the Rank field is defined as a String field but the form accepts Integer values. In V1, the field is defined as a string to allow new items to be inserted into the order without renumbering the other work items. However, we do not want to accept non-integer values for this field, ...Show All

• Visual Studio Express Editions Memory Leak

  Hello people,         i am a new bie in vc++ programming. My projcet preformance is degraded because of memory leak. It would be a great help if ypu guys help me pur with my school project. th following code give me a memory leak ---------------------------------------------------------------------------------------------------------------------------------- void CMemoryLeakDlg::OnBnClickedOk() { // Memory Leak is occuring in the next statement static unsigned char * test = new unsigned char[ 240*320*3]; for(int j = 0 ; j < 3; j++) { _CrtDumpMemoryLeaks(); int i = 0; for( int r = 0; r < 240; ...Show All