syed abdul kather

• Dec 21st, 2006

 

i am not sure that this is right we can update our dataset by updating data adapter ex :- string str="Provider=Microsoft.Jet.OLEDB.4.0;Data Source= My Documents/syed.mdb"; OleDbConnection con=new OleDbConnection(str); OleDbDataAdapter ada=new OleDbDataAdapter("select * from student",con); DataSet ds=new DataSet(); ada.Update(ds,employee); DataGrid1.DataSource=ds.Tables[0].DefaultView; DataGrid1.DataBind();

sbehera02

 Profile Answers by sbehera02 Questions by sbehera02

• Dec 21st, 2006

 

Hi syed abdul kather,

What i am saying,First you Fill Dataset or Update Dataset, Then how you updated Databse?

jai_mnti

 Profile Answers by jai_mnti 

• Jan 3rd, 2007

 

You update the dataset using the fill() and update the database using the update() method of the dataset

dharmesh kubavat

• Feb 8th, 2007

 

Using Update method of Data Adapter : DA.Update(DS)

sahu

 Profile Answers by sahu Questions by sahu

• Mar 29th, 2007

 

Hi,


Ans:


Step 1:

 //Fill the DataSet by using SqlDataAdapter (sDa)
sDa.Fill(ds)// ds is DataSet Object

Step two:

   // Change DataSet and update by using  sDa.update(datasetopbject) Method

    sDa.update(ds);//it will update DataBase



   


   

ynvpavan

 Profile Answers by ynvpavan 

• Apr 18th, 2008

 

It's sure u can easily update the data by using the code as following:


DataSet objDataset1 = new DataSet();

objAdapter1.Fill(objDataset1);

objConn.Close();

ynvpavan

 Profile Answers by ynvpavan 

• Apr 18th, 2008

 

And updating database through dataset will be by following code:


foreach (DataRow row in objDataset1.Tables[0].Rows)

{

string Loannumber = row[0].ToString();int count = bllObj.Savenumber(number,DateTime.Now);

total += count;

}


where bll is the object of business layer

hasham13

 Profile Answers by hasham13 

• May 1st, 2008

 

a. 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);
}

PratapCh

 Profile Answers by PratapCh 

• May 3rd, 2008

 

We will update the dataset by calling Update Method.
We will update the database by calling AcceptChanges Method.

nayan21

 Profile Answers by nayan21 

• Oct 31st, 2011

 

we can update Dataset in ADO.Net using "AcceptChanges" method of dataset and
we can update database through dataset using "Update" method of data adapter with parameter as dataset (from which database to be updated).

lata negi

 Profile Answers by lata negi 

• Nov 4th, 2011

 

Code
SqlConnection conn = new SqlConnection("Server=__; DataBase=__; UID: __; Password: __");


DataAdapter da;


DataSet ds = new DataSet();


da = new SqlDataAdapter("select * from employee", conn);


ds = da.fill(ds);


GridView.DataSource=ds;


GridView.DataBind();


 

brajesh gautam

• Feb 6th, 2012

 

In ADO.Net if you use the disconnect mode then local copy are already update but if we want to update a database type this program in visual studio

sqlconncection = new sqlconection (" connection string");

take a date set;
dataset ds;

and take sqldata adaptor da;
and give the command in data adptor

and
da.update(ds.tables[0]);
tables [0];
is your index