OleDbConnection oldbConn = new OleDbConnection(ConfigurationSettings.AppSettings["connectionString"]);						
			OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
			myDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM [Opportunity Table]", oldbConn);				
			OleDbCommandBuilder cbldr = new OleDbCommandBuilder(myDataAdapter);
			cbldr.QuotePrefix = "[";
			cbldr.QuoteSuffix = "]";
			OleDbDataAdapter myDataAdapter1 = new OleDbDataAdapter();
			myDataAdapter1.SelectCommand = new OleDbCommand("SELECT * FROM [Opportunity Task Table]", oldbConn);				
			OleDbCommandBuilder cbldr1 = new OleDbCommandBuilder(myDataAdapter1);
			cbldr1.QuotePrefix = "[";
			cbldr1.QuoteSuffix = "]";

			try
			{
				oldbConn.Open();
				if(pOppDs.Tables[ 0 ].Rows[ 0 ]["Opportunity Number"] is DBNull)
				{
				}
				else
				{
					int i = (int)pOppDs.Tables[ 0 ].Rows[ 0 ]["Opportunity Number"];
				}				
				myDataAdapter.Update(pOppDs, CONST_OPPORTUNITY_TABLE);	
				myDataAdapter1.Update(pOppDs, CONST_TASK_TABLE);

			}
			finally
			{				
				if (oldbConn != null)
				{
					oldbConn.Close();
					oldbConn = null;
				}
			}	

OleDbCommand cmdGetLastIndex = new OleDbCommand("SELECT TOP 1 [Opportunity Number] FROM [Opportunity Table] ORDER BY [Opportunity Number] DESC", oldbConn);

protected static void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs args)
  {
    // Include a variable and a command to retrieve the identity value from the Access database.
    int newID =  0 ;
    OleDbCommand idCMD = new OleDbCommand("SELECT @@IDENTITY", nwindConn);

    if (args.StatementType == StatementType.Insert)
    {
      // Retrieve the identity value and store it in the CategoryID column.
      newID = (int)idCMD.ExecuteScalar();
      args.Row["CategoryID"] = newID;
    }
  }