C#

I just did it but I have an error: the function 'SCOPE_IDENTITY' not defined in the expression

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

    cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
    cmd1.CommandText = "SELECT SCOPE_IDENTITY()";

    cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);

    cmd1.ExecuteNonQuery();
    int id = Convert.ToInt32(cmd1.ExecuteScalar());
    TxtNunCmd.Text = id.ToString();

}

and I wanted to clarify that I am on an access database

it’s already done sir but what I don't understand textbox does not recover the id, it displays zero

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

                     cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
                     cmd1.CommandText = "SELECT @@IDENTITY";

                     cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);

                     //sql_cmd = new OleDbCommand(CommandText, sql_con);
                     cmd1.ExecuteNonQuery();
                      id = (int)cmd1.ExecuteScalar();
                     TxtNunCmd.Text = id.ToString();
                 }

:doh:  :doh:  :doh:  :doh: you are right sir and I promise you find the solution and you ride it

yes yes sir I am still looking for, I will find it, I assure you sir

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

                       cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
                       OleDbCommand cmr = sql_con.CreateCommand();
                       cmr.CommandText = "SELECT @@IDENTITY AS LastId";

                       cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);
                       id = (int)cmr.ExecuteScalar();
                       TxtNunCmd.Text = id.ToString();

                       cmd1.ExecuteNonQuery();

                   }

but i can't get the id

Hello sir and all my excuses for yesterday I had a connection problem that's why I disconnected but by dint of fighting all night I could find the solution regaré and tell me if the code is clean. I must say I am glad I did ...

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

                      cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
                      cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);
                      cmd1.ExecuteNonQuery();
                      OleDbCommand cmr = sql_con.CreateCommand();
                      cmr.CommandText = "SELECT @@IDENTITY AS LastId";


                      int LastId = Convert.ToInt32(cmr.ExecuteScalar());
                      TxtNunCmd.Text = LastId.ToString();
                      //sql_cmd = new OleDbCommand(CommandText, sql_con);


                  }

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

hello sir all my apologies for the delay ... i was putting my code clean as you advised me. I have an error like microsoft jet engine

try
                        {
                            setConnection();
                            sql_con.Open();
                            using (sql_cmd = sql_con.CreateCommand())
                            {
                                string txtQuery = "INSERT INTO Detail_temp (ref_det, qute_det, Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det,@qute_det,@Designation,@Prix_unitaire_HT,@Prix_total_HT)";
                                sql_cmd.Parameters.AddWithValue("@ref_det", TxtRefProduit.Text);
                                sql_cmd.Parameters.AddWithValue("@qute_det", TxtQteCmd.Text);
                                sql_cmd.Parameters.AddWithValue("@Designation", TxtDesignation.Text);
                                sql_cmd.Parameters.AddWithValue("@Prix_unitaire_HT", TxtPrixUnitaire.Text);
                                sql_cmd.Parameters.AddWithValue("@Prix_total_HT", total);
                                sql_cmd = new OleDbCommand(txtQuery, sql_con);
                                sql_cmd.ExecuteNonQuery();
                                //ExecuteQuery(txtQuery);
                            }
                        }
                        catch(OleDbException ex)
                        {
                            MessageBox.Show(ex.Source);
                        }

Quote:

I have an error like microsoft jet engine