添加一条记录(100分)

           string strConnect = ConfigurationSettings.AppSettings["DsnUserList"];
           string userName = tbUserName.Text.Trim();
           string Sex = ddlSex.SelectedItem.Text.Trim();
           int    Age =Int32.Parse(this.tbAge.Text.Trim());	
	string Email = tbEmail.Text.Trim();
           string strSQL = "SELECT TOP 1 * FROM USER";
try
   {
	  // create a new Connection object
   OleDbConnection objConnect = new OleDbConnection(strConnect);
				
				// open the connection to the database
    //  objConnect.Open();
       OleDbCommand selectCMD = new OleDbCommand(strSQL, objConnect);
                
       selectCMD.CommandTimeout = 30;
        OleDbDataAdapter custDA = new OleDbDataAdapter();
        custDA.SelectCommand = selectCMD;
        DataSet custDS = new DataSet();
        custDA.Fill(custDS,"USER");
        DataRow myNewRow;
        myNewRow = custDS.Tables["USER"].NewRow();
        myNewRow["UserName"] = userName;
        myNewRow["UserSex"] = Sex;
        myNewRow["UserAge"] = Age;
        myNewRow["UserEmail"] = Email;
        custDS.Tables["USER"].Rows.Add(myNewRow);
        custDS.AcceptChanges();
         custDA.Update(custDS);
				}
catch (Exception objError)
     {
				
	Label6.Text="错误"+objError.Source;
	Label7.Text=strConnect;
			
	return;			// and stop execution
}