dataset ds;
string connectionstring;
sqlconnection con;
sqlparameter[] param;
sqldataadapter da;
public form1(){
initializecomponent();
ds=new dataset();
param=new sqlparameter[2];
param[0]=new sqlparameter("@a",sqldbtype.varchar);
param[0].value="C#";
param[1]=new sqlparameter("@b",sqldbtype.varchar);
param[1].value="update_example";
con=new sqlconnection();
connectionstring="my connection string";
con.connectionstring=connectionstring;
da=new sqldataadapter();
da.selectcommand.commandtext="select * from table";
da.selectcommand.connection=con;
da.selectcommand.commandtype=commandtype.text;
da.selectcommand.parameters.addrange(param);
// field1 & field2 are column name.
da.updatecommand.connection=con;
da.updatecommand.commandtext=@"update my_table set [field1]=@a, [field2]=@b where ([field1]=@aa) and (field2=@bb);
da.updatecommand.parameter.addrange(new sqlparameter[] {
new sqlparameter("@a",sqldbtype.varchar,0,"field1"),
new sqlparameter("@b",sqldbtype.varchar,0,"field2"),
new sqlparameter("@aa",sqldbtype.varchar,0,parameterdi rection.input,true,((byte)(0)),((byte)(0)),"field1 ",datarowversion.original,null),
new sqlparameter("@bb",sqldbtype.varchar,0,parameterdi rection.input,true,((byte)(0)),((byte)(0)),"field2 ",datarowversion.original,null)});}
private void form1_load(object sender, eventargs e){
da.fill(ds,"my_table");
mydatagridview.datasource=ds.table[0];}
private void btnUpdate_click(object sender, eventargs e){
da.update(ds);}