private void button1_Click(object sender, System.EventArgs e) { if (conn.KickOut(textBox_UserName.Text) == "") { MessageBox.Show("必须输入用户名!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (textBox_UserName.Text.Length > 20) { MessageBox.Show("请不要超长输入用户名!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } bool bool_UserName_Had = true; try { bool_UserName_Had = conn.UserName_Had(textBox_UserName.Text); } catch { MessageBox.Show("数据库错误!!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } if (bool_UserName_Had == true) { MessageBox.Show("请不要输入重复的用户名!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (textBox_PassWord.Text == "") { MessageBox.Show("必须输入密码!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (textBox_PassWord.Text.Length > 20) { MessageBox.Show("请不要超长输入密码!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (conn.Sniffer_In(textBox_PassWord.Text) || conn.Sniffer_In(textBox_UserName.Text)) { MessageBox.Show("用户名或密码不得用空格或者'\"?%=空格!", "警告!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } //去除'"?%=空格,插入办事处表 string errorstring = "", str_ReadOnly, str_Sql; if (checkBox_ReadOnly.Checked == true) { str_ReadOnly = "1"; } else { str_ReadOnly = "0"; } str_Sql = "insert into Users (UserName,PassWord,ReadOnly) values ('" + conn.KickOut(textBox_UserName.Text) + "','" + conn.KickOut(textBox_PassWord.Text) + "'," + str_ReadOnly + ")"; errorstring = conn.ExeSql(str_Sql); if (errorstring != "OK") { MessageBox.Show("未成功添加!请检查数据库!" + errorstring, "提醒!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); button1.Enabled = false; return; } MessageBox.Show("成功添加!", "提醒!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); //刷新DataGrid显示 str_Sql = "SELECT UserName AS 用户名,PassWord AS 密码,ReadOnly AS 仅为只读用户 FROM Users"; try { errorstring = conn.Fill(str_Sql); } catch { MessageBox.Show(errorstring, "提醒!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); conn.Close(); } DataGrid1.SetDataBinding(conn.ds, "TableIn"); textBox_UserName.Text = ""; textBox_PassWord.Text = ""; checkBox_ReadOnly.Checked = true; }