8,834
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn=new SqlConnection("Server=.;Initial Catalog=MyDb;uid=sa;pwd=sa;");
SqlDataAdapter adp= new SqlDataAdapter(@"select s.Id as SRId,s.SRName,s.SRNum,s.ConId,
c.name,c.age,c.sex from SR s,Contact c where c.id=s.conid", conn);
adp.UpdateCommand = new SqlCommand(@"update Contact set name=@name,age = @age,sex=@sex
where id = @ConId;update SR set SRName=@SRName,SRNum = @SRNum where id = @SRId", conn);
SqlParameter p = adp.UpdateCommand.Parameters.Add("@name", SqlDbType.VarChar);
p.SourceColumn = "name";
p = adp.UpdateCommand.Parameters.Add("@age", SqlDbType.VarChar);
p.SourceColumn = "age";
p = adp.UpdateCommand.Parameters.Add("@sex", SqlDbType.VarChar);
p.SourceColumn = "sex";
p = adp.UpdateCommand.Parameters.Add("@ConId", SqlDbType.VarChar);
p.SourceColumn = "ConId";
p = adp.UpdateCommand.Parameters.Add("@SRName", SqlDbType.VarChar);
p.SourceColumn = "SRName";
p = adp.UpdateCommand.Parameters.Add("@SRNum", SqlDbType.VarChar);
p.SourceColumn = "SRNum";
p = adp.UpdateCommand.Parameters.Add("@SRId", SqlDbType.VarChar);
p.SourceColumn = "SRId";
DataSet ds = new DataSet();
adp.Fill(ds, "MyCon");
DataView v = ds.Tables["MyCon"].DefaultView;
dgv.DataSource = v;
//--------------------------
private void button1_Click(object sender, EventArgs e)
{
adp.Update(ds, "MyCon");
}