I am new to VB.NET and reading thorugh a textbook and trying varoius applications. I have made a connection to an SQL database on a server using VB. NET
I have created a simple form and have included the SQLDataAdapter, SQL Connecition1 and Dataset11. The connections works fine.
I also bound the dataset to a data grid and can preview the data adapter and see the requested data.
I then attempted to fill the dataset in coded from the data adapter using the following code on a button click event -
DataSet11.Clear()
SQLDataAdapter1.Fill(DataSet11)
When I try to run the "Fill" button in the form to generate the query result set I get the following error:
An unhandled exception of the type 'System.Data.SQLClient.SQL Exception' occured in the system.data.dll
Q: Any suggestions as to what I am missing would be appreciated.
Connecting to SQL - Newbee
traitor28
You're using the new objects that generate SQL for you I'd say that you need to specify what the insert query should look like, although I'm not sure, I don't use that stuff, I think it's rubbish.
If you go to msdn.microsoft.com and look up SQLDataAdapter, I'm sure you'll find examples that will tell you what's going wrong.