Hello:

I have a Visual Basic Program and have created a DataSet through the GUI which represents my three table database in SQL Server with all the defined relationships.

I have a bunch of raw data read from spreadsheets and populated to arrays. I want to take this array information and now add records, or update if they already exist.

I do not care to see any datagrids for this information, just populate the data. Is there not a way to just use the current 'JobSheetDataSet.xsd' file to insert the data? I am a little confused, and would not mind an overview of DataSets, DataTables and Data Adapters so I can understand how to accomplish this. I have probably asked similar questions about this before, so my apologies ahead of time.

It seems to me if I am able to see this data model through the DataSet, I should be able to just reference those objects and not have to write any kind of connection string, since this is how the dataset was created to begin with. Everything I've read online takes me through the steps of writing the connection string.

Thanks for all the great help on this forum!