I have a tables called tasks, for each task I have a comma delimited field for storing their schedule using SQL constants. How do I display the longname value of the constants when the data is pulled up into a data grid. When a user fires up the app I give them a list of process that need...more >>

Dear all, I write a program to update records and I make use of Sqlcommandbuilder to produce the update, delete, insert command for me. It's fine in update and insert record to database except delete. My delete procedure is shown as below: Public Sub DeleteRow(ByVal id as string) ...more >>

Hi I am nearly crying! I am reading MS Press Book and I understood what DataAdapter, Dataset, Datatable ... is. But: I can't manage to simply SHOW the Data I have stored into my DataAdapter. Dim ds As New DataSet da_Asset.Fill(ds) I created a Datadapter and filled a Dataset. Howto ...more >>

I've been trying to fill form objects with data but always get this error: An unhandled exception of type 'system.data.sqlclient.sqlexception' occured in system.data.dll Additional information: System error. I don't know what the above means because there isn't any additional information. ...more >>

Hi, is there a way to have an exact copy of a database copied to a dataset including the relations and constraints? Thanks ...more >>

Hi, I am new to Databases in VB.NET. I had no problem using them in VB 6.0. I find that it's a bit confusing under VB.NET especially that the literature available presents sophisticated examples (with lots of "bells and whistles") that tend to lose users that prefer starting with simple and raw ...more >>

Hi, I am using following code to read and generate SQL query based on values stored in ArrayList. But I am not sure if it is the best way... all suggestions are welcome! Thank you! Scott Dim SqlQuery As String Dim SqlCity As String If Not Cities.Count = 0 Then For i As Integ...more >>

I have a stored procedure I am calling to return resuts if there any to a sqldatareader. The problem I am having is my code thinks it is always returning results... the While rdr2.read always passes and the rdr2.has rows is true even if the stored procdure returns no results. I have teste...more >>

Hi folks I have a question that hopefully the answer will point me in the right direction. I have two tables... the first is as three fields Id, lot,amtReceived...... Id is the pk the 2nd as three fields, bridge,antShipped,ShipDate..... Bridge is the fk ok..now what I need to know is......more >>

Hi all - I am developing a MDI windows app that uses MSDE as it's data-store. I am coding some simple maintenance procedures (pickable as a menu item from the parent form), such as backup database, delete old records, and restore database. Backup and deletion (coupled with a dbcc shrinkd...more >>

I have a VB.Net web service that access a foxpro database. The web service and the foxpro db are on the same box. One of the methods in that web service tries to update a column in one of the foxpro tables, but I get the error: Cannot update the cursor User, since it is read-only The r...more >>

I'm used to referencing columns (fields) using a string identifier (i.e. "CustomerName") -- this doesn't appear to be an option with the DataReader -- I can only reference a field using a .Get<type>(<ordinal column position>) (i.e. dr_Data.GetString(1) -- where 1 is the second ordinal posi...more >>

Does anyone know how to hide a particular column from an autogenerated grid? Below is what I have done to read a XML file and display the data onto a grid. The first column (ID) does not get hidden. I have read that once cannot easily hide columns in the autogenerated grid but most of the exam...more >>

In my form (Teachers), how do I make my datagrid (classes) change to reflect the classes my selected teacher teaches? I can do this in MS Access by using the Link Child Fields/Link Master Fields, for a frame of reference. I am using VB in Visual Studios 2003. Thank you, Monty ...more >>

I have a datagrid that reads in a XML file but it displays the parent window all the time. How do I change it to display the child window only in vb.net? Thanks! Jonathan ...more >>

Does anyone know how to display just the child window in the Datagrid control instead of the default parent-child tree in vb.net? thanks! ...more >>

I am unfamiliar with the MS.NET datagrid control so I am hoping someone could convet the following VB6 grid control code to the MS Datagrid control. I understand that the Datagrid control is implemented very differenly than the VB6 grid control (such as the labeling of columns, column widths etc)...more >>

I am new to OOP programming with VB.NET. I have a question about designing a programming with a database and multiple tables. What sould my approach be when creating classes? I was thinking of creating a class for each table? If someone can give me an idea if I am on the right track or if I do no...more >>