Re: recording problem - C# Discussion Boards

ago248617-Mar-20 4:39

17-Mar-20 4:39

it does not matter sir I understand you but nevertheless if I have a problem I will post it for a possible help

Re: recording problem

ZurdoDev17-Mar-20 2:39

ZurdoDev

17-Mar-20 2:39

ago2486 wrote:
'No value given for one or more of the required parameters.'

That is not "some error", it tells you exactly what the problem is. You need to make sure you are submitting a value for all parameters.

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Re: recording problem

OriginalGriff17-Mar-20 2:52

OriginalGriff

17-Mar-20 2:52

Look at his code and see what he does immediately after adding the parameters and their values...

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

Re: recording problem

ZurdoDev17-Mar-20 2:59

ZurdoDev

17-Mar-20 2:59

OriginalGriff wrote:
Look at his code

Ya, I know. I was more referring to the fact that three separate people asked what the error was and the OP just kept saying "some error." D'Oh! | :doh:

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Re: recording problem

Luc Pattyn17-Mar-20 12:08

Luc Pattyn

17-Mar-20 12:08

Hi,

please stop doing

catch(OleDbException ex)
                      {
                          MessageBox.Show(ex.Source);
                      }

instead do

catch(Exception ex)
                      {
                          MessageBox.Show(ex.ToString());
                      }

It will (1) be able to catch more problems, and (2) will provide much more information when something goes wrong (including the exact line number when running in Visual Studio); you may not understand all of its output right away, but that typically is the info one needs to easily pinpoint what went wrong.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: recording problem

ago248617-Mar-20 22:04

ago2486

17-Mar-20 22:04

Hello sir and thank you for the info, I think I saw it when I was doing my research. And it was written only to see the problems with connection to the database. So I would like to know if we could use it only at the connection of the database or not?

Re: recording problem

Luc Pattyn17-Mar-20 22:18

Luc Pattyn

17-Mar-20 22:18

All exceptions derive from the Exception class, so catching Exception will catch "everything".

Whatever your code is about, it is most often wise to put it inside a try-catch block that catches
and displays all information about all exceptions.

And when your code misbehaves and you don't yet have a try-catch, adding one is the first thing you should do.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

modified 18-Mar-20 11:15am.

Re: recording problem

ago248617-Mar-20 23:20

ago2486

17-Mar-20 23:20

thank you sir i will do it now

Re: problem to retrieve an info in a sql request / problème pour recéper une info dans une requête sql

Richard Deeming16-Mar-20 9:28

Richard Deeming

16-Mar-20 9:28

As Griff already pointed out, your first command needs to use a parameter. You should also wrap the OleDbCommand object in a using block, and get rid of the ExecuteQuery method.

using (var cmd = sql_con.CreateCommand())
{
    cmd.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
    cmd.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);
    cmd.ExecuteNonQuery();
}

OleDbParameterCollection.AddWithValue(String, Object) Method (System.Data.OleDb) | Microsoft Docs[^]

The second command does not need any parameters. But you do need to execute the command and read the returned value.

long numCmd;
using (var cmd = sql_con.CreateConnection())
{
    cmd.CommandText = "SELECT MAX(num_com) AS dernier_num FROM Commandes";
    
    object result = cmd.ExecuteScalar();
    if (result is null || Convert.IsDBNull(result))
    {
        numCmd = 0L;
    }
    else
    {
        numCmd = Convert.ToInt64(result);
    }
}

OleDbCommand.ExecuteScalar Method (System.Data.OleDb) | Microsoft Docs[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

problem registering in the access database

ago248617-Mar-20 0:58

ago2486

17-Mar-20 0:58

Hello sir and thank you for your help. I did as you advised me but I have a microsoft jet engine error. I will see another tutorial on this subject if I will find a solution ...

Re: problem registering in the access database

Richard Deeming17-Mar-20 1:01

Richard Deeming

17-Mar-20 1:01

If you want someone to help you fix an error, you need to give us the full details of the error.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: problem registering in the access database

ago248617-Mar-20 1:08

ago2486

17-Mar-20 1:08

ok thank you sir. But there is not much detail except that when I submit the button to add I receive the message microsoft jet engine.

private void BtnAjouter_Click(object sender, EventArgs e)
       {
           int total;
           decimal total_achat;
           //si les champs sont vides
           if (TxtDesignation.Text == "" || TxtPrixUnitaire.Text == "" || TxtQteCmd.Text == "" || TxtQteStock.Text == "" || TxtRefProduit.Text == "")
           {
               MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else
           {
               //Vérifier si la valeur saisie est numeric
               if (Int32.TryParse(TxtQteCmd.Text, out int value) && TxtRefProduit.Text != "")
               {
                   //Vérifier si la commande est inferieur ou egale au stock
                   int a = 0;
                   int b = 0;
                   int c;

                   //Convertire les textBox en int
                   int.TryParse(TxtQteCmd.Text.Trim(), out a);
                   int.TryParse(TxtQteStock.Text.Trim(), out b);
                   int.TryParse(TxtPrixUnitaire.Text.Trim(), out c);

                   if (a <= b)
                   {
                       total = a * c;
                       total_achat = 0;

                       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);
                       }

                       //Création de la requête sql pour inserer des valeurs dans DB
                      //string txtQuery = "INSERT INTO Detail_temp (ref_det, qute_det, Designation, Prix_unitaire_HT, Prix_total_HT) VALUES ('"+ TxtRefProduit.Text+ "', '" + TxtQteCmd.Text + "', '" + TxtDesignation.Text + "', '" + TxtPrixUnitaire.Text + "', '" + total + "')";

                      //ExecuteQuery(txtQuery);

                       try
                       {

                           LoadDB();

                           //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                           for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                           {
                               total_achat += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

                           }
                           TxtTotalCmd.Text = total_achat.ToString();//convertir total_achat en string^pour pouvoir l'afficher dans le textbox
                           TxtDesignation.Text = "";
                           TxtQteCmd.Text = "";
                           TxtPrixUnitaire.Text = "";
                           TxtRefProduit.Text = "";
                           TxtQteCmd.Text = "";
                           //SupDetail_Temp();

                       }

                       catch (OleDbException ex)
                       {
                           MessageBox.Show(ex.Source);
                           sql_con.Close();
                       }
                       finally
                       {
                           sql_con.Close();
                       }

                   }
                   else
                   {
                       MessageBox.Show("Veuillez verifier le stock du produit!!!");
                   }
               }

           }

       }

Re: problem registering in the access database

Richard Deeming17-Mar-20 1:10

Richard Deeming

17-Mar-20 1:10

That's not the full error message.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: problem registering in the access database

ago248617-Mar-20 1:17

ago2486

17-Mar-20 1:17

I followed your advice, sir, regarding possible SQL injection. I may be wrong but I made the parameter request as you told me, but if he has other errors, can you help me please

Re: problem registering in the access database

Richard Deeming17-Mar-20 1:35

Richard Deeming

17-Mar-20 1:35

Sorry, I posted that before I noticed that you'd commented-out the vulnerable code.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: problem registering in the access database

ago248617-Mar-20 2:00

ago2486

17-Mar-20 2:00

thank you sir i was afraid i didn't do what you told me.

Re: problem registering in the access database

ago248617-Mar-20 1:18

ago2486

17-Mar-20 1:18

private void BtnAjouter_Click(object sender, EventArgs e)
       {
           int total;
           decimal total_achat;
           //si les champs sont vides
           if (TxtDesignation.Text == "" || TxtPrixUnitaire.Text == "" || TxtQteCmd.Text == "" || TxtQteStock.Text == "" || TxtRefProduit.Text == "")
           {
               MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else
           {
               //Vérifier si la valeur saisie est numeric
               if (Int32.TryParse(TxtQteCmd.Text, out int value) && TxtRefProduit.Text != "")
               {
                   //Vérifier si la commande est inferieur ou egale au stock
                   int a = 0;
                   int b = 0;
                   int c;

                   //Convertire les textBox en int
                   int.TryParse(TxtQteCmd.Text.Trim(), out a);
                   int.TryParse(TxtQteStock.Text.Trim(), out b);
                   int.TryParse(TxtPrixUnitaire.Text.Trim(), out c);

                   if (a <= b)
                   {
                       total = a * c;
                       total_achat = 0;

                       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);
                       }



                       try
                       {

                           LoadDB();

                           //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                           for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                           {
                               total_achat += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

                           }
                           TxtTotalCmd.Text = total_achat.ToString();//convertir total_achat en string^pour pouvoir l'afficher dans le textbox
                           TxtDesignation.Text = "";
                           TxtQteCmd.Text = "";
                           TxtPrixUnitaire.Text = "";
                           TxtRefProduit.Text = "";
                           TxtQteCmd.Text = "";
                           //SupDetail_Temp();

                       }

                       catch (OleDbException ex)
                       {
                           MessageBox.Show(ex.Source);
                           sql_con.Close();
                       }
                       finally
                       {
                           sql_con.Close();
                       }

                   }
                   else
                   {
                       MessageBox.Show("Veuillez verifier le stock du produit!!!");
                   }
               }

           }

       }

Re: problem registering in the access database

Richard Deeming17-Mar-20 2:57

Richard Deeming

17-Mar-20 2:57

Griff has already spotted the problem in the thread above, but in case it's not obvious, here's what your code is doing:

Quote:

// 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);
}

Creates a string variable to hold the query;
Adds 5 parameters to the sql_cmd variable;
Throws the sql_cmd variable away and sets it to a new OleDbCommand instance;
Attempts to execute the sql_cmd without adding any parameters to it;

This is yet another reason not to store the OleDbConnection and OleDbCommand objects in class-level fields. The first bit of your code is manipulating a command from a previous method. If the sql_cmd field hasn't been initialized, you may even get a NullReferenceException.

Change your code to create and use a new OleDbCommand instance, wrapped in a using block:

using (OleDbCommand cmd = sql_con.CreateCommand())
{
    cmd.CommandText = "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)";
    
    cmd.Parameters.AddWithValue("@ref_det", TxtRefProduit.Text);
    cmd.Parameters.AddWithValue("@qute_det", TxtQteCmd.Text);
    cmd.Parameters.AddWithValue("@Designation", TxtDesignation.Text);
    cmd.Parameters.AddWithValue("@Prix_unitaire_HT", TxtPrixUnitaire.Text);
    cmd.Parameters.AddWithValue("@Prix_total_HT", total);
    
    sql_con.Open();
    cmd.ExecuteNonQuery();
}

Ideally, you should change your code to create the OleDbConnection as a local variable wrapped in a using block too, and delete the sql_con and sql_cmd fields.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: problem registering in the access database

ago248617-Mar-20 3:14

ago2486

17-Mar-20 3:14

Thank you very much to you I try it and I come back to you

Re: problem registering in the access database

ago248617-Mar-20 1:10

ago2486

17-Mar-20 1:10

and here is my connection

private void setConnection()
     {
         try
         {
             string connetionString = null;
             //connection à la base de donnée avec mot de passe
             connetionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + @"\DB_CaisseEnregistreuse.mdb;Persist Security Info=True;Jet OLEDB:Database Password=B@sta08091987";
             sql_con = new OleDbConnection(connetionString);
         }
         catch (Exception ex)
         {
             MessageBox.Show("Erreur de connexion à la base donnée" + ex.Message);
         }


     }

Re: problem registering in the access database

Richard MacCutchan17-Mar-20 2:18

Richard MacCutchan

17-Mar-20 2:18

But what is the error message?

Re: problem registering in the access database

ago248617-Mar-20 2:26

ago2486

17-Mar-20 2:26

System.Data.OleDb.OleDbException: 'No value given for one or more of the required parameters.'

Re: problem registering in the access database

Richard MacCutchan17-Mar-20 2:36

Richard MacCutchan

17-Mar-20 2:36

That cannot be true since there is no SQL command in the code you posted.

Java Api Callbacks crashes on dotnet framework version 4.5 and above

isaketranjan16-Mar-20 0:06

isaketranjan

16-Mar-20 0:06

Hi All, trying to work with Java Access Bridge in c#, everything works fine however whenever i try to subscribe on dotnet framework version 4.5 and above e.g.

JabApi.MouseClickedDelegate mcd = new  JabApi.MouseClickedDelegate(HandleMouseClickedDelegate);
JabApi.setMouseClickedFP(mcd);

Application crashes, but same code works fine on dotnet framework version 4.0.
Checked Event log : Faulting module name: windowsaccessbridge-64.dll

Re: Java Api Callbacks crashes on dotnet framework version 4.5 and above

Gerry Schmitz16-Mar-20 5:05

Gerry Schmitz

16-Mar-20 5:05

The "Bridge" appears to involve components (for testing) that are no longer supported. I'd think a # COM server or something would be more forward-looking.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.