计算机专业毕业设计：[111]添加用户到组2

1、用RequiredFieldValidator控件判断用户名不为空

2、txt_user_name_TextChanged事件查询即将添加的会员是否存在

3、--判断用户名是否存在代码string sqlcon = "select * from [user] where user_name='" + txt_user_name.Text + "' "; if (myclass.IsSameRecord(sqlcon)) { lblMsg.Text = "已存在相同用户名"; } else lblMsg.Text = "";

4、通过选中的权限组名，查询出对应的IDstring sql_group_id = "select group_id from user_group where group_name='" + dp_group.SelectedValue + "' "; string U_group_id = myclass.sqlResult("group_id", sql_group_id);

5、string userName = txt_user_name.Text.Trim(); string userPwd = txt_user_password.Text.Trim(); string usercredit = txt_credit.Text.Trim(); DateTime New_time = DateTime.Now; if (userName != "" && userPwd != "" && lblMsg.Text == "") { string sql_change = "insert into [user](group_id,user_name,user_password,credit) values('" + U_group_id + "','" + userName + "','" + userPwd + "','" + usercredit + "')"; if (myclass.ExCom(sql_change)) { Response.Write("<script>alert('用户：'+'" + userName + "'+'添加成功！')</script>"); } } else { Response.Write("<script>alert('必填字段不能为空');</script>"); }

6、运行程序，假如添加存在的用户，会提示“已存在相同用户名”

7、输入一个新用户名，点击添加，提示：添加成功