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);
            }