下面的程序对不对?
SqlConnection conn= new SqlConnection();
conn.ConnectionString = @"user id=sa;password=;initial catalog=buyer;data source=127.0.0.1;connect Timeout=20";
conn.Open();
SqlDataAdapter da=new SqlDataAdapter("select Product_No,P_NewPrice,P_OldPrice from Product",conn);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
DataSet ds=new DataSet();
da.Fill(ds,"Product");
ds.Tables["Product"].Rows[2]["P_OldPrice"]=40;
da.Update(ds,"Product");
Response.Write(ds.Tables["Product"].Rows[2]["P_OldPrice"]);
conn.Close();
SqlConnection conn= new SqlConnection();
conn.ConnectionString = @"user id=sa;password=;initial catalog=buyer;data source=127.0.0.1;connect Timeout=20";
conn.Open();
SqlDataAdapter da=new SqlDataAdapter("select Product_No,P_NewPrice,P_OldPrice from Product",conn);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
DataSet ds=new DataSet();
da.Fill(ds,"Product");
ds.Tables["Product"].Rows[2]["P_OldPrice"]=40;
da.Update(ds,"Product");
Response.Write(ds.Tables["Product"].Rows[2]["P_OldPrice"]);
conn.Close();
string sql = "select ...."
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql,conn);
sqlAdapter.Fill(ds,"Product");
后更新,
sql = "update .... where ID="+ds.Table[0].Row[2]["ID"].ToString();
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
换成server=127.0.0.1