SqlParameter sp=new SqlParameter();
SqlDataAdapter da;string updcmd = "Update UserInfo set UserName=@UserName,UserPwd=@UserPwd,UserAge=@UserAge,UserType=@UserType where UserName=@UserName";
da.UpdateCommand = new SqlCommand(updcmd,conn); sp = da.UpdateCommand.Parameters.Add("@UserName",SqlDbType.VarChar);
sp.SourceColumn = "UserName";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserPwd", SqlDbType.VarChar);
sp.SourceColumn = "UserPwd";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserAge", SqlDbType.Int);
sp.SourceColumn = "UserAge";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserType", SqlDbType.VarChar);
sp.SourceColumn = "UserType";
sp.SourceVersion = DataRowVersion.Current; try
{
if (ds.HasChanges())
{
objresult = MessageBox.Show("要保存更改的信息么?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (objresult == DialogResult.Yes)
{
da.Update(ds, "userinfo");
MessageBox.Show("数据已更新");
}
else
{
return;
}
}
else
{
MessageBox.Show("未做任何更改");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
SqlDataAdapter da;string updcmd = "Update UserInfo set UserName=@UserName,UserPwd=@UserPwd,UserAge=@UserAge,UserType=@UserType where UserName=@UserName";
da.UpdateCommand = new SqlCommand(updcmd,conn); sp = da.UpdateCommand.Parameters.Add("@UserName",SqlDbType.VarChar);
sp.SourceColumn = "UserName";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserPwd", SqlDbType.VarChar);
sp.SourceColumn = "UserPwd";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserAge", SqlDbType.Int);
sp.SourceColumn = "UserAge";
sp.SourceVersion = DataRowVersion.Current; sp = da.UpdateCommand.Parameters.Add("@UserType", SqlDbType.VarChar);
sp.SourceColumn = "UserType";
sp.SourceVersion = DataRowVersion.Current; try
{
if (ds.HasChanges())
{
objresult = MessageBox.Show("要保存更改的信息么?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (objresult == DialogResult.Yes)
{
da.Update(ds, "userinfo");
MessageBox.Show("数据已更新");
}
else
{
return;
}
}
else
{
MessageBox.Show("未做任何更改");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货