C#

sql_cmd.CommandText = "insert into InfoCode (Code, DateCode, PrixCode) values('" + lblAffichage.Text + "' , '" + dateTimePicker1.Text + "' , '" + txtAffichPrix.Text + "')";

but what should I do? since you asked me to correct the error. can you tell me more so that I can understand

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        cmd.Parameters.AddWithValue("@C1", myValueForColumn1);
        cmd.Parameters.AddWithValue("@C2", myValueForColumn2);
        cmd.ExecuteNonQuery();
        }
    }

i will do it aisin and come back to you, thanks for your help

 private void btnAdd_Click(object sender, EventArgs e)
        {
            if (lblAffichage.Text == "")
            {
                MessageBox.Show("Merci de bien vouloir générer le code");
            }
            else
            {
                using (SQLiteConnection con = new SQLiteConnection(sql_con))
                {
                    con.Open();
                    using (SQLiteCommand cmd = new SQLiteCommand("INSERT INTO InfoCode (Code, DateCode, PrixCode) VALUES (@Code, @DateCode, @PrixCode)", con))
                    {
                        cmd.Parameters.AddWithValue("@Code", lblAffichage.Text);
                        cmd.Parameters.AddWithValue("@DateCode", dateTimePicker1.Text);
                        cmd.Parameters.AddWithValue("@PrixCode", txtAffichPrix.Text);
                        cmd.ExecuteNonQuery();
                    }
                    LoadData();
                    MessageBox.Show("Enregistrement effectué avec succès");
                    lblAffichage.Text = "";
                    groupBoxGenerer.Enabled = false;
                    btnEnregistrer.Enabled = false;
                    this.Refresh();
                }
            }
        }
Thank you very much for your help ... it works

Hello sir I was able to find a solution to print, I'm going through a DataSet: I connected the DataSet to my database

here is the code: {
            setConnection();
            sql_con.Open();
            sql_cmd = sql_con.CreateCommand();
            string CommandText = "select * from InfoCode";
            DB = new SQLiteDataAdapter(CommandText, sql_con);
            DS.Reset();
            CrystalReportImprimCode x = new CrystalReportImprimCode();
            DBset dt = new DBset();
            DB.Fill(dt.InfoCode);
            x.SetDataSource((DataTable)dt.InfoCode);
            crystalReportViewer1.ReportSource = x;
            crystalReportViewer1.Refresh();
            sql_con.Close();
        }

ibrahimayhans wrote:

SerialPort.ReadExisting () Returns an Incomplete Result.

ibrahimayhans wrote:

How Do I Write a Code?

Set an index to the start of your receive buffer
Do
    Read some data using the index to position it at the correct point in the buffer
    Add the count of bytes read to the offset index
While index < 41
// when the index reaches 41 you have all the data (bytes 0 to 40)