BobDaBuilder's Q&A profile

• SQL Server Can't debug DataFlow Script task

  I have debugged a Control Flow script task and everything went as expected. I put a breakpoint somewhere in my script code, press F5 and execution will break there. However, when I try the same in a Data Flow script, execution does not break! Moreover, when I reopen the code right after I closed VSA, the breakpoint is not there anymore... Any help would be appreciated. Regards, Henk Henk, There's a simple answer ...Show All

• Windows Forms DataGrid: Where Am I?

  I have added a ContextMenu to a DataGrid in the forms designer of VB Express 2005. Having added items to the menu, the functionality I am trying to achieve is to perform one of the menu actions on the current row of the DataGrid. Firstly, which event of the context menu do I trap Click Mouse Up Secondly, how do I find out which row of the DataGrid I was on The event is owned by the ToolStripMenuItem, which is owned by the ContextMenu whic ...Show All

• Visual Basic Return key on the keyboard

  I want to be able track when the user presses the return key - Can anyone tell me how Thanks Handle the KeyDown event and check the KeyEventArgs.KeyCode if it is Keys.Enter If you want to do it for a form you can set the Form.KeyPreview property to true hand all key events will happen on the form first. ...Show All

• Visual Basic How do you use sound in your project?

  Ok, I'm trying to make a cool project but I can't put sound in. Can sombody tell me what's wrong dim soundengine as new media.soundplayer soundengine.load("explode.wav") And you can use Microsoft.DirectX.AudioVideoPlayback namespace (if you use the managed DirectX SDK) to play WAVs, MP3s and WMAs... ...Show All

• SQL Server Database locking issue

  We have a table with an update trigger that we seem to be having unintended deadlock issues. The trigger, among other things, updates the same row that was updated to spawn the trigger. In our examples where we are encountering the deadlocks we are always doing single row updates on a unique clustered index. Originally, we seemed to be having a lot of unnecessary lock escalation occurring to the page and table level. We added a lock hint to t ...Show All

• Visual Basic GetLastError

  I am a vb.net 2003 programmer. I am working on a web service application which requires me to use C++ routines for autoproxy detection on a client computer. Specifically, I am using WinInet and Autoproxy C++ routines. My problem is that it is hard to debug runtime difficulties within my autoproxy C++ routines. I am familiar with Try/Catch error trapping but "GetLastError" is new to me. My question is therefore, how should a vb programm ...Show All

• SQL Server How to backup a database to a network drive

  It is OK to backup a database to the local drive (C:) on SQL Server 2005. But when I tried to backup a database to a mapped network drive (N:) on the server,  it failed. Here is the message: System.Data.SqlClient.SqlError: Cannot open backup device 'N:\db.bak'. Operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo) The network drive N: is accessible through Windows Explorer.  Currently, we ...Show All

• Windows Forms XML and XSLT in WinForm

  I am just wondering what type of control I can use to display XML data that hase been transform by a XSLT to a winForm.  In ASP.NET it was easy...the XML control. Thanks, Trey I was worried you'd say that because I don't  ...Show All

• Visual C# dropdown item ID

  Hi, I am using this code to populate data into combobox but i was just thinking how can i assign an id to each item in the dropdown list like the primary id for example because i want to save both id and name of the company.. // fill the insurance company; VDBAdapter.SelectCommand = new VistaDBCommand("SELECT account_name AS insurance_account FROM accounts WHERE account_type = 'INSURANCE' ORDER BY account_name", VDBConnection); VDBDatas ...Show All

• Windows Forms Why can't I change a simple name

  If I start a simple Windows application a Window called Form1 is created. I have found out that it's not possible to change this name. I get a lot of error messages telling me that the change is not reflected fully in the sourcecode and when compiling that Form1 is not found. Also if I did the namechnage in the Form1 properties Window and then tried to change the name back to Form1 it didn't work. Neither is it possible to change the name in the ...Show All

• Visual Studio Team System Multiple classes and namespaces

  Hi, I am supposed to do a couple of rules using fxcop: avoid multiple namespaces in a file and avoid multiple classes in a file. The CCI classes missing api document is hindering a little bit. I tried using the sourcecontext object, but it returns null for the source text and thus can not parse it and see in which file is a class implemented in. The other thing is that the following code does not tell me if a namespace had anoth ...Show All

• Windows Forms Set SelectedItem on DataGridViewComboBoxColumn When DataSource is Set

  Hello, I am having a devil of a time setting the SelectedItem on a DataGridViewComboBoxColumn when the grid datasource is set. I have one ComboBoxColumn that is bound to an enum and it just binds the value from the db with no extra effort. I set the column datasource and the grid datasource and the grid just knows how to load the right option when it renders the grid. My problem arises on two other columns that are bound to arrays of custo ...Show All

• Windows Forms Domain Upgrade from NT to 2003 AD

  Hi, I know we are years behind times but we are currently working on upgrading our current NT domain to 2003 Active Directory. We are setting up a new domain in the 2003 environment and then setting up trusts to our NT domain and then are planning on using the Migration utility provided by Microsoft to move the Users, Groups, and Computers, as well as Mail boxs from our current Exchange 5.5 box to the new Exchagen 2003 boxs. We have the 2003 dom ...Show All

• SQL Server SSIS Connection Object and Expressions

  I have been writing a custom source adapter that uses a file connection within the connection manager. If I hard-code a specific file then the component works. However if I use a file connection that has an expression defined which updates the connection, for example when you have a for-each loop looping over a set files. The file connection doesn’t seem to re-evaluate expression each time you access the file connection via the code. Is there s ...Show All

• Visual C# Splitting a string using multiple delimiter error

  Hi guys, I am using C# express august edition, i get this error when trying to do this string t = "Once,Upon:A/Time\\In\'America" ; char[] seps = new char[]{ '/', '\'}; foreach ( string ss in t.Split(sep2)) Console.WriteLine(ss); it says too many character in character litral what do i do but i have a string that has \r\n\r at its end, and i want to remove that from the upper bound of the arraay, like This\r\n\r, how do i remove ...Show All