Updating a datatable
But it is not working when I create the Ole DBCommand Builder. People need to learn, put in their efforts and then seek help.I have the Data Adapter as a global variable, it is in the module1, so the data adapter is accessible every where. When I create the Data Adapter, I am doing this;it is in the module1 Public DBConnection as new Ole Db. Update(Data Table1) Data Base.close() End Sub() But it is not working! Nihar Mody Net To Life Technologies" id="ctl00_m_m_i_ctl00_gr_ctl21_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5371381" / Hi Nihar Mody Well, I really don't see a good answer in your email, or in the email that you refer.You need to learn how to load the table (using a Data Adapter), how to make changes to records in the Data Table, how to add Insert, Update, and Delete queries to the Data Table (using a Command Builder), and how to use the Data Table.
I am not asking how create a data adapter property, or a data adapter object.
So I don't understand why you think that I should learn how do it. Maybe my English is not very clear, but I need to make sure that my words are clear, because reading your answer, I am thinking that you didn't understand me.