SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
SqlDataAdapter sqlda = new SqlDataAdapter("select * from web", sqlcon);
DataSet ds = new DataSet();
sqlda.Fill(ds, "web");
string name = TextBox1.Text;
string pwd = TextBox2.Text;
ds.Tables[0].Rows[0]["name"]=TextBox1.Text ;
ds.Tables[0].Rows[0]["pwd"]=TextBox2.Text;
SqlCommandBuilder sqlcb = new SqlCommandBuilder(sqlda);
sqlda.UpdateCommand = sqlcb.GetUpdateCommand();
sqlda.Update(ds.Tables[0]);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
注意顺序和表设置主建没有