Updating the database using dataset and dataadapter

So, define your command object: Dim Sql Update Command1 As New System. Than bind datagrid with datagrid from properties Than fill dataset on form load Private Sub View_All_Load(By Val sender As System.

Hi, I have a situation in where i have two instances of SQL server, the first is our Production Environment, the second is our Development environment.

Open(); Sql Connection cn Development SQL = new Sql Connection("Data Source=SQLSVR02; Integrated Security=SSPI; Initial Catalog=Master"); cn Development SQL. i'm rather new in this area so i'm trying to understand what you are saying.

Fill(ds Development,"Companies"); if (ds Production. I broke the code right before I set Data Row1 = Data Row2 and the two fields in Data Row1 did contain the expected values.

I also broke the code following the code where I set Data Row1 = Data Row2 and the changes propogated correctly to the Second Data Table.

But for some reason they were never written to the database.

Thanks for any help you can offer, Ron "Peter Bromberg [C# MVP]" RSH, I haven't looked carefully at your code sample, but I'd be willing to bet that the reason you aren't getting any updates is because the Row States of the rows in the second Data Adapter's table don't reflect any changes.

Search for updating the database using dataset and dataadapter:

updating the database using dataset and dataadapter-21updating the database using dataset and dataadapter-32updating the database using dataset and dataadapter-48updating the database using dataset and dataadapter-61

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating the database using dataset and dataadapter”