//添加数据------------------------------------------
void AddAuthor_Click(Object sender, EventArgs e)
{
if (user_id.Text == "" || user_name.Text == "" || password.Text == "")
{
Message.Text = "错误:“用户 ID”、“名字”或“口令”不允许使用空值";
Message.Style["color"] = "red";
BindGrid();
return;
}
Message.Text = "您好 " + user_name.Text;
String insertCmd = "insert into user_reg (user_id, user_name,password) "+
"values ("+user_id.Text+",'"+user_name.Text+"','"+password.Text+"')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, myConnection);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
Message.Text = "<b>已添加记录</b><br>" + insertCmd.ToString();
}
catch (OleDbException ex)
{
if (ex.ErrorCode == 2627)
Message.Text = "错误:已存在具有相同主键的记录";
else
Message.Text = "错误:未能添加记录,请确保正确填写了字段";
Message.Style["color"] = "red";
}
myCommand.Connection.Close(); BindGrid();
}
void AddAuthor_Click(Object sender, EventArgs e)
{
if (user_id.Text == "" || user_name.Text == "" || password.Text == "")
{
Message.Text = "错误:“用户 ID”、“名字”或“口令”不允许使用空值";
Message.Style["color"] = "red";
BindGrid();
return;
}
Message.Text = "您好 " + user_name.Text;
String insertCmd = "insert into user_reg (user_id, user_name,password) "+
"values ("+user_id.Text+",'"+user_name.Text+"','"+password.Text+"')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, myConnection);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
Message.Text = "<b>已添加记录</b><br>" + insertCmd.ToString();
}
catch (OleDbException ex)
{
if (ex.ErrorCode == 2627)
Message.Text = "错误:已存在具有相同主键的记录";
else
Message.Text = "错误:未能添加记录,请确保正确填写了字段";
Message.Style["color"] = "red";
}
myCommand.Connection.Close(); BindGrid();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货