1.

How Do You Update A Dataset In Ado.net And How Do You Update Database Through Dataset?

Answer»

UPDATE a dataset:

Dataset ds = new dataset(); SqlDataAdapter adp = new SqlDataAdapter(QUERY,connection); Adp.fill(ds); Again you can add/update Dataset as below SqlDataAdapter adp1 = new SqlDataAdapter(Query1,connection); Adp1.fill(ds);

Update DATABASE through dataset.

SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter); Foreach(datarow dr in ds.table[0].rows) { Dr[“column NAME”] = “value”; mySqlDataAdapter.Update(ds); }

Update a dataset:

Update database through dataset.


Discussion

No Comment Found

Related InterviewSolutions