How do you update a Dataset in ADO.Net and How do you update database through Dataset?
Submitted by: Administratora. 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);
b. Update database through dataset.
SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);
Foreach(datarow dr in ds.table[0].rows)
{
Dr[“column Name”] = “value”;
mySqlDataAdapter.Update(ds);
}
Submitted by: Administrator
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);
b. Update database through dataset.
SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);
Foreach(datarow dr in ds.table[0].rows)
{
Dr[“column Name”] = “value”;
mySqlDataAdapter.Update(ds);
}
Submitted by: Administrator
Read Online ADO.NET Job Interview Questions And Answers
Top ADO.NET Questions
| ☺ | Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET? |
| ☺ | Difference between SqlCommand and SqlCommandBuilder? |
| ☺ | Can dataReader hold data from multiple tables? |
| ☺ | What provider ADO.net use by default? |
| ☺ | What is different between SqlCommand object and Command Behavior Object? |
Top Dot Net Technologies Categories
| ☺ | MSF Interview Questions. |
| ☺ | .Net Architecture Interview Questions. |
| ☺ | ASP.Net MVC Interview Questions. |
| ☺ | Entity Framework Interview Questions. |
| ☺ | C# (Sharp) Programming Language Interview Questions. |
