SqlConnection con=new SqlConnection("server=.;database=testst;uid=sa;pwd=sa");
con.Open();
SqlDataAdapter sda=new SqlDataAdapter("select * from testst",con);
DataSet ds=new DataSet();
sda.Fill(ds,"test");
sda.InsertCommand=new SqlCommand("insert into testst values(3,'aap')",con);
sda.Update(ds,"test");
con.Open();
SqlDataAdapter sda=new SqlDataAdapter("select * from testst",con);
DataSet ds=new DataSet();
sda.Fill(ds,"test");
sda.InsertCommand=new SqlCommand("insert into testst values(3,'aap')",con);
sda.Update(ds,"test");
"insert into testst (字段名,字段名) values (3,'aap')"