updating database from dataset

[carobee]

How do i update a database from dataset.

SqlDataAdapter.Update()

is not working

[Aneesh_Argent]

Try using the SqlCommandBuilder Class like this

SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);

 mySqlDataAdapter.Update(myDataSet, "myTableName");

[carobee]

Tried that but its not working. Do i have to set the update,delete and insert command?

Try using the SqlCommandBuilder Class like this

SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);

 mySqlDataAdapter.Update(myDataSet, "myTableName");

[Aneesh_Argent]

Can u post your full code here.

[carobee]

Here is the code

SqlDataAdapter da = new SqlDataAdapter("select * from mytable",strCon);
        DataSet ds = new DataSet();
        da.Fill(ds);

        GridView2.DataSource = ds;
        GridView2.DataBind();
        SqlCommandBuilder m_cd = new SqlCommandBuilder(da);
        string UpdateCommand = m_cd.GetUpdateCommand().CommandText;
             
        da.Update(ds, "mytable");

[Aneesh_Argent]

Try this:

SqlDataAdapter da = new SqlDataAdapter("select * from mytable",strCon);
SqlCommandBuilder m_cd = new SqlCommandBuilder(da);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;

        DataSet ds = new DataSet();
        da.Fill(ds);

        GridView2.DataSource = ds;
        GridView2.DataBind();
        
        string UpdateCommand = m_cd.GetUpdateCommand().CommandText;
             
        da.Update(ds, "mytable");

[carobee]

Throwing an error as

Update unable to find TableMapping['mytable'] or DataTable 'mytable'

Try this:

SqlDataAdapter da = new SqlDataAdapter("select * from mytable",strCon);
SqlCommandBuilder m_cd = new SqlCommandBuilder(da);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;

        DataSet ds = new DataSet();
        da.Fill(ds);

        GridView2.DataSource = ds;
        GridView2.DataBind();
        
        string UpdateCommand = m_cd.GetUpdateCommand().CommandText;
             
        da.Update(ds, "mytable");

[Aneesh_Argent]

da.Update(ds, "mytable");

Here "mytable" should be replace by your tablename. I have given it just as an example. Since your Dataset contains only one table you can use this instead.

da.Update(ds.Tables[0]);

[carobee]

i had replaced it with my table name.Still it was showing that error. while changing it to

da.Update(ds.Tables[0]);

as you suggested, no updation was done on the table

[carobee]

finally i hv found the solution. i was actually tryng to update MS access. for that you have to check the permissions of the table and give proper permissions

[ggl0rd]

can show the solution u do?