(C#) ASP.NET - Transaction()

Trans = objConn.BeginTransaction(); 
Trans.Commit();
Trans.Rollback();

            System.Data.OleDb.OleDbConnection objConn;
            System.Data.OleDb.OleDbCommand objCmd;
            String strConnString, strSQL;
            OleDbTransaction Trans;

            strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
            Server.MapPath("database/mydatabase.mdb") + ";Jet OLEDB:Database Password=;";
            objConn = new System.Data.OleDb.OleDbConnection(strConnString);
            objConn.Open();

            //*** Start Transaction ***//
            Trans = objConn.BeginTransaction(IsolationLevel.ReadCommitted);

            try
            {

                //*** Query 1 ***//
                strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " +
                "VALUES ('C005','Weerachai Nukitram','[email protected]','TH','2000000','1000000')";
                objCmd = new System.Data.OleDb.OleDbCommand();

                objCmd.Connection = objConn;
                objCmd.Transaction = Trans;
                objCmd.CommandType = CommandType.Text;
                objCmd.CommandText = strSQL;

                objCmd.ExecuteNonQuery();

                //*** Query 2 ***//
                strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " +
                "VALUES ('C005','Weerachai Nukitram','[email protected]','TH','2000000','1000000')";
                objCmd = new System.Data.OleDb.OleDbCommand();

                objCmd.Connection = objConn;
                objCmd.Transaction = Trans;
                objCmd.CommandType = CommandType.Text;
                objCmd.CommandText = strSQL;

                objCmd.ExecuteNonQuery();

                Trans.Commit();  //*** Commit Transaction ***//
                this.lblText.Text = "Record is commit";

            }
            catch (Exception ex)
            {
                Trans.Rollback(); //*** RollBack Transaction ***//

                this.lblText.Text = "Record is rollback (" + ex.Message + ")";
            }

            objCmd = null;
            objConn.Close();
            objConn = null;

System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
DataSet ds = new DataSet();

strSQL = "SELECT * FROM customer";

objConn.ConnectionString = strConnString;
objConn.Connection = objConn;
objConn.Transaction = Trans;
objConn.CommandText = strSQL;
objConn.CommandType = CommandType.Text;

//*** DataSet Under Transaction ***//
dtAdapter.SelectCommand = objCmd;
dtAdapter.Fill(ds);

System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
DataTable dt = new DataTable();

strSQL = "SELECT * FROM customer";

objCmd = objConn.CreateCommand;
objCmd.Transaction = Trans;
objCmd.CommandText = strSQL;
objCmd.CommandType = CommandType.Text

//*** DataTable Under Transaction ***//
dtAdapter.SelectCommand = objCmd;
dtAdapter.Fill(dt);