newbie command builder question

  • Thread starter Thread starter Marina
  • Start date Start date
M

Marina

SqlDataAdapter1.Update(myDataTable), where 'myDataTable' is the datatable
that you used to create the dataview.
 
I have an app which uses a dataview. You page through the record one at a
time and the text boxes are 'bound' ie their text property is set manually.
A little like an Access form. I am using a dataview so I can use the filter.
I can get the changes in each record to be reflected in the dataview but
can't get the command builder to work so I can update the database.

Dim CommandBuilder As System.Data.SqlClient.SqlCommandBuilder = New
System.Data.SqlClient.SqlCommandBuilder(SqlDataAdapter1)

Now I want to call the update method how do I do that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is faster? Dim dv As New DataView(session("myDataTable")) or CType(session("myDataTable")) 1
datatable and gridview...binding..? doubt? 2
ListView DataView, it shows me this letters "System.Data.Row.View" 1
Bind ListView to DataTable - why is this a problem? 4
Paging question 4
HOWTO: data table into acess accdb using vb 1
Accessing DataTable Problem 1
Selecting in a DataGrid 3

Back
Top