C#

// Logic Behind this Kata
   // 1, 2,....100
   // take first example 36- 36 is a perfect square of 6 and it is divisble by 36,18,12,9,6,4,3,2,1 which is 9 Odd
   // take first example 25- 25 is a perfect square of 5 and it is divisble by 25,5,1 which is 3 Odd
   // If we talk about not perfect square then - 50 is divisble by 50,25,10,5,2,1 which is 6 Even
   // If we talk about not perfect square then - 8 is divisble by 8,4,2,1 which is 4 Even
   // Now take example of 25 => 25 (Open), 5(Close), 1 (Open)
   // Now 36 => 36(Open),18(Close),12(Open),9(Close),6(Open),4(Close),3(Open),2(Close),1 (Open)
   // It means every perfect square has Open door
   // And Every non perfect square has Closed Door

[TestMethod]
      public void TestIfAllDoorsAreClosedAtBiginning()
      {
          bool[] result = _100DoorsKata.CheckDoorState(0);
          for (int i = 1; i <= 100; i++)
          {
              Assert.IsFalse(result[i]);
          }
      }

      [TestMethod]
      public void TestIfAllDoorsAreOpenedAfterFirstRound()
      {
          bool[] result = _100DoorsKata.CheckDoorState(1);
          for (int i = 1; i <= 100; i++)
          {
              Assert.IsTrue(result[i]);
          }
      }

public bool[] CheckDoorState(int pass)
       {
           bool[] doors = new bool[101];
           for (int i = 1; i <= 100; i++)
           {
               if (pass == 0)
               {
                   doors[i] = false;
               }
               else
               {

                   doors[i] = true;

               }

           }
           return doors;

       }

good evening gentlemen and thank you to you who brought me help but I am continuing my project and I have a problem retrieving info from one table to insert it into another.
I have three tables which are related
1.product (article_ID, design, price_U, Qty)
2.order (com_number, com_date, com_amount)
3.detail_command (num_det, num_com, ID_article, qute_det)
I can't fill the detail_commende table. It must be said that I am lost. can you put me on the track please
I may have made a serious mistake in my codes.

private void BtnValider_Click(object sender, EventArgs e)
      {
          DialogResult dialogResult = MessageBox.Show("Voulez vous valider la facture?", "VALIDATION DE LA FACTURE", MessageBoxButtons.YesNo);
          if (dialogResult == DialogResult.Yes)
          {
              try
              {

                  setConnection();
                  sql_con.Open();

                  using (OleDbCommand cmd1 = sql_con.CreateCommand())
                  {

                      cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
                      cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);
                      //sql_cmd = new OleDbCommand(CommandText, sql_con);
                      cmd1.ExecuteNonQuery();
                      //ADODB.Recordset dbrst = new ADODB.Recordset();
                  }

                  long Qte_prod, numCmd;
                  string ref_prod;


                  using (OleDbCommand cmd2 = sql_con.CreateCommand())
                  {
                      //setConnection();

                      cmd2.CommandText = "SELECT MAX(num_com) AS dernier_num FROM Commandes";
                      // cmd2.Connection.Open();
                     // sql_con.Open();
                      object result = cmd2.ExecuteScalar();
                      if (result is null || Convert.IsDBNull(result))
                      {
                          numCmd = 0;
                      }
                      else
                      {
                          numCmd = Convert.ToInt64(result);
                          TxtNunCmd.Text = numCmd.ToString();


                          //LoadDB();
                          //object result1 = cmd3.ExecuteScalar();
                          for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                              {
                                  ref_prod = Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
                                  Qte_prod = Convert.ToInt64(dataGridView1.Rows[i].Cells[1].Value);

                                  using (OleDbCommand cmd3 = sql_con.CreateCommand())
                                  {

                                      cmd3.CommandText = "INSERT INTO * Detail_commandes (com_det, ref_det, qute_det) VALUES (@com_det,@ref_det,@qute_det)";
                                      cmd3.Parameters.AddWithValue("@com_det", TxtNunCmd.Text);
                                      cmd3.Parameters.AddWithValue("@ref_det", ref_prod);
                                      cmd3.Parameters.AddWithValue("@qute_det", Qte_prod);
                                      cmd3.ExecuteNonQuery(); //***I have an error at this level: INSERT INTO syntax error

                                  }

                                  using (OleDbCommand cmd4 = sql_con.CreateCommand())
                                  {
                                      setConnection();
                                      cmd4.CommandText = "UPDATE Catalogue SET Quantite = Quantite - (@Qte_cmd) WHERE code_article = (@code_article)";
                                      cmd4.Parameters.AddWithValue("@Qte_cmd", Qte_prod);
                                      cmd4.Parameters.AddWithValue("@code_article", TxtRefProduit.Text);
                                      cmd4.ExecuteNonQuery();

                                  }
                              }
                          sql_con.Close();
                          SupDetail_Temp();
                          //vider();
                          TxtTotalCmd.Text = "";



                      }
                  }

              }

              catch (Exception ex)
              {
                  MessageBox.Show(ex.ToString());
                  sql_con.Close();
              }
          }
          else if (dialogResult == DialogResult.No)
          {
              //do something else
          }

      }