Search results for query: *

I am using a strongly typed dataset and have filled the table adapter like so: Me.TblOrderTableAdapter.Fill(Me.DS_OrderLookup.tblOrder, "OrderUID < 0") giving me tblOrder table in my dataset with no records (since none will have OrderUID < 0). I'm using the following SQL stored proc...

Unfortunately, I don't get the problem on the development pc, I get other errors further along in the vb.net app like Microsoft exception errors. The vb.net app works great when it is run by itself... Sometimes I can get it to work ok when called from vb6, sometimes not. Very frustrating...

blah.exe is the name of my vs2005 vb.net exe and the parameters to pass to it follow in the error message.

I can't tell. The titlebar just says Error and the message says: The program ["blah\blah.exe "x" "y" 4 "z"] caused a problem and is going to close. Would you like to save a dump file? with Yes and No buttons. I never get to the vb.net main form.

I want to run a vb.net exe from a vb6 form's button. The vb.net exe must receive some passed parameters. I'm using the shell command. Sometimes this works, sometimes I get all kinds of different errors/exceptions. Can anyone tell me the correct way to do this? Thank you

I need to distribute a MS Access 2003 mdb that will connect to SQL Server 2005 data on a remote server via tcp/ip. How could I do this in code so they can't see the connection userid and password? I'll be making an mde from it. I know how to programmatically create and use a connection...

Ahhhhh. Thank you!!! That was it.

Trying to run the following script in SQL Server 2005. The syntax checks out fine but when I execute it I get: Msg 2714, Level 16, State 3, Procedure ehe_ConditionSubForm, Line 22 There is already an object named 'ehe_ConditionSubForm' in the database. There is NO stored proc or anything else...

Thanks jebenson!

I'm trying to add a new record to a listbox. The listbox is bound to a dataview. When I trace through the code below, the dataview gets the newly added record correctly and the listbox says it has all the items. Problem is, the listbox shows a blank item where the newly added item should be...

I have a column in a datagrid that contains a button. I always want this button's picture to show on the row, not just when I put the cursor on a cell in the column. How could I do this? thanks

I don't want to create the SQL table ahead of time. I want the program to create the SQL table just like it was a copy of the structure and data in the TempImport table in the dataset.

I have this code (partial shown) and add more columns, then insert rows into the added table. The table only resides in memory, not in SQL Server. Dim workTable As DataTable = mdsTempImport.Tables.Add("TempImport") workTable.Columns.Add("UID"...

I have a datatable built within the program. The data has not come directly from any underlying table. I want to now save this datatable as a new SQL Server table. Is this possible and if so, how? Thks

I need to show zeros at the rightmost decimal place(s) if the user entered them. If they didn't, I don't want to show the zeros. Example: entered 4.90 needs to show as 4.90 on all screens/reports and needs to be save in the database as 4.90 entered 4.9 in the same field, needs to show 4.9 on...

When using an Access database, you are supposed to use question marks and then the parameters must be added in order. The 1st question mark is replaced by the 1st parameter, etc. This logic is to update the table only if the shipperUID and TStamp have not changed - in other words, it handles...

I'm getting concurrency violations on the following code: sSql = "UPDATE tblShippers SET ShipperKey = ?, " & _ "Description = ?, " & _ "MaxWeight = ?, " & _...

Sorry! I meant oledb. Here's the link in the VS2005 help: ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/WD_ADONET/html/f21e6aba-b76d-46ad-a83e-2ad8e0af1e12.htm In any event, I just want to see if there is a way to trace what happens during an update command against an Access...

The help says to use ? for the parameters in the sql statement when it goes against an odbc data source - in this case Access.

I have the following code: sSql = "UPDATE tblShippers SET ShipperKey = ?, " & _ "Description = ?, " & _ "MaxWeight = ?, " & _ "TStamp = '" & Now() & "' " & _...