C# - Access - Problems with double queries : I'm trying to execute 2 query in one button click.. It doesn't seem to work and just closes automatically.. Does anyone can help me or explain to me why my code doesn't work? Here's the code:

     test = 1;
                        {
                connection.Open();
                string strTemp = " [StudentNum] Text, [StudentName] Text, [Section] Text, [TimeIn] Text, [TimeOut] Text, [Status] Text";
                    OleDbCommand myCommand = new OleDbCommand();
                    myCommand.Connection = connection;
                    myCommand.CommandText = "CREATE TABLE [" + date + "](" + strTemp + ")";
                    myCommand.ExecuteNonQuery();
                if (test == 1)
                {
                    OleDbCommand commandl = new OleDbCommand();
                    commandl.Connection = connection;
                      commandl.CommandText = "INSERT INTO ['" + date + "']([StudentNum],[StudentName],[Section]) select [StudentNo],[Name],[Section] from StudInfo";
                    commandl.ExecuteNonQuery();
                }