updatedatabse through ado.net

hello plesehelp me to sort out this problem
when i use the update command it doesn't work
coding is here tis is in c#

Code:

sqlconnection  con=new sqlconnection();
con.connectionstring="data source=server; initial catalog=db;user id=sa";
con.open();
sqlcommand cmd=new sqlcommand("select * from table1",con);
dataset sd=new dataset("table1");
sqldataadapter da=new sqldataadapter(cmd);
da.fill(ds,"table1");
datagrid dg=new datagrid();
dg.datasource=ds;
dg.datamember="table1";
da.update(ds,"table1");
con.close();

while i use this coding it shows exception ;
but when i take datagrid through wizard and establishe connection then update command is worked;. please some body help me .

 

try this

Code:

sqlconnection  con=new sqlconnection();
con.connectionstring="data source=server; initial catalog=db;user id=sa";
con.open();
sqlcommand cmd=new sqlcommand("select * from table1",con);
dataset sd=new dataset("table1");
sqldataadapter da=new sqldataadapter(cmd);
da.fill(sd,"tbl_store");
da.fillSchema(sd,schematype.source,"tbl_store");
datagrid dg=new datagrid();
dg.datasource=ds.Tables["tbl_store"];
da.update(ds,"table1");
con.close();

it will work

dataset name recommended not to be same as table name
to update you must get the schema from data adapter

 

ooooooooooooops
there is amistake

Code:

sqlconnection  con=new sqlconnection();
con.connectionstring="data source=server; initial catalog=db;user id=sa";
con.open();
sqlcommand cmd=new sqlcommand("select * from table1",con);
dataset sd=new dataset("table1");
sqldataadapter da=new sqldataadapter(cmd);
da.fill(sd,"tbl_store");
da.fillSchema(sd,schematype.source,"tbl_store");
datagrid dg=new datagrid();
dg.datasource=ds.Tables["tbl_store"];
da.update(ds,"tbl_store");
con.close();

it will work

dataset name recommended not to be same as table name
to update you must get the schema from data adapter