I'm building a VB.Net Windows form application.
I have a DataGrid and 5 unbound textboxes on a form.
The DataGrid is populated with a OleDbDataAdapter and is using a table
called Clients.
What I want to do is have the users fill in the unbound textboxes and click
a button and have those values inserted into the table clients. I will then
refresh the datagrid and the new values will appear.
I created a New Connection, A New DataSet and A New Select Command to the
table Clients.
When I Create a datarow like so:
Dim drw2 As DataRow
drw2 = DataSet1.Tables("tblClients").NewRow
I recieve a error " Object reference not set to an instance of an
object......"
When I look up the error it looks like the new select command I've built is
interfering with the one on the OleDbDataAdapter.
Does anybody have any workaround ideas?
Thanks
Erik