//添加数据------------------------------------------
       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();        
       }