DataSet Bind()
{
UserInfoData data = new UserInfoData();
data.Userid = txtUserid.Text;
data.Userlevel = txtUserlevel.Text;
Classes.UserInfoOperation op = new Classes.UserInfoOperation();
ds = op.GetUserInfo(data);
return(ds);
}
//删除
private void button3_Click(object sender, EventArgs e)
{
string sno = txtUserid1.Text;
Classes.UserInfoOperation op = new Classes.UserInfoOperation();
if (op.DeleteUser(sno))
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败了");
}
dataGridView1.DataSource = Bind().Tables[0];
}
//修改
private void button2_Click(object sender, EventArgs e)
{
UserInfoData data = new UserInfoData();
data.Userid = txtUserid1.Text;
data.Userpwd = txtUserpwd1.Text;
data.Userlevel = txtUserlevel1.Text;
Classes.UserInfoOperation op = new Classes.UserInfoOperation();
if (op.UpdateUser(data))
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败了");
}
dataGridView1.DataSource = Bind().Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
UserInfoData data = new UserInfoData();
data.Userid = txtUserid.Text;
data.Userpwd = txtUserpwd.Text;
data.Userlevel = txtUserlevel.Text;
if (txtUserid.Text == "" || txtUserid.Text == null)
{
MessageBox.Show("用户名不能为空");
txtUserid.Focus();
return;
}
Classes.UserInfoOperation op = new Classes.UserInfoOperation();
if (op.InsertUserInfo(data))
{
MessageBox.Show("插入成功");
}
else
{
MessageBox.Show("失败");
}
}