Question Write to SQL database using VB in Vis Studio 2008

[Barrievans]

I am brand new to Visual studio 2008 and am tryng to load a text file int a SQL database. I have created a button on a form and have successfullty read the text file into the app. I now need to write the record to SQL. First step I need to connect to the database - please help

 

[jmcilhinney]

Follow the Data Walkthroughs link in my signature for information on working with data. Most likely you'd create a typed DataSet for your database, populate a DataTable with the your data and then save it using a TableAdapter.

There are other ways too, including the SqlBulkCopy class, which may be easier if the circumstances fit.