C#

Quote:

...added the reference to System.Management...

OK I install it and I give you the rest
thank you for your promptitude

Thank you thank you and thank you you just relieved me of a problem that tired me for a long time. I followed your advice and walk. But my question is the following, if I will have to burn it on a CD to give it to a friend or mm has everyone how to go about it so that in the course of installatoin the sytem.data.sqlite installs automatically?

I use inno setup. i made a comment when i was installing my program on the pc it asked me the framwork .NET 3.5 which is launching once i have accepted but for the system.data.sqlite no ...

Hello sir and thank you for your answer ...
I will like some advice about my program. If I want to give it to friends, I have to ask them to install system.data.sqlite on their pc? But is there not another alternative?

Thank you I use inno setup, I will document and make you a continuation of my research

I just realized that although I managed to connect to my database thanks to you, I can not register ... here is the error message:
Failed to connect to the data source attempt to write a readonly database
attempt to write a readonly database

I send you my code and if possible give me a link or I can send you all the program for inspection on your part

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SQLite;

namespace Acode
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            
           
        }
        private SQLiteConnection sql_con;
	    private SQLiteCommand sql_cmd;
        private SQLiteDataAdapter DB;
	    private DataSet DS = new DataSet();
	    private DataTable DT = new DataTable();

        private void setConnection()
	    {
            //CONNEXION A LA BASE DE DONNEE
	    sql_con = new SQLiteConnection(@"Data Source=DBcode.db; Version=3;New=;Compress=True;");
	    }

        private void LoadData()
        {
            setConnection();
            sql_con.Open();
            sql_cmd = sql_con.CreateCommand();
            string CommandText = "select * from InfoCode";
            DB = new SQLiteDataAdapter(CommandText, sql_con);
            DS.Reset();
            DB.Fill(DS);
            DT = DS.Tables[0];
            dataGridView1.DataSource = DT;
            sql_con.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            LoadData();

        }

        private void ExecuteQuery(String txtQuery)
	    {
        setConnection();
	    sql_con.Open();
	    sql_cmd = sql_con.CreateCommand();
	    sql_cmd.CommandText = txtQuery;
	    sql_cmd.ExecuteNonQuery();
	    sql_con.Close();
	    }

        public static string randomstring(int length)
        {
            const string chars = "ABCDEFGHIJKLMNOPQRSTUVWYZ0123456789";
            Random random = new Random();
            return new string(Enumerable.Repeat(chars, length).Select(s => s[random.Next(s.Length)]).ToArray());
        }
        private void btnGenerer_Click(object sender, EventArgs e)
        {
           
            lblAffichage.Text = randomstring(4);
            txtAffichPrix.Text = "100";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            lblAffichage.Text = randomstring(5);
            txtAffichPrix.Text = "300";
        }

        private void button2_Click(object sender, EventArgs e)
        {
            lblAffichage.Text = randomstring(6);
            txtAffichPrix.Text = "500";
        }

       
        private void btnEnregistrer_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))
                {
                    try
                    {
                        con.Open();
                        // Insert code to process data.
                        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;
                        btnImprimer.Enabled = true;
                        this.Refresh();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Échec de la connexion à la source de données" + ex.Message);
                    }
                    finally
                    {
                        con.Close();
                    }
                    
                    
                }
            }
        }

        private void btnAjouter_Click(object sender, EventArgs e)
        {
            groupBoxGenerer.Enabled = true;
            btnEnregistrer.Enabled = true;
        }

        private void quitterToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
            FrmAuthentification retour = new FrmAuthentification();
            retour.Show();
        }

        private void codeVenduToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FrmCodeVendu ventcode = new FrmCodeVendu();
            ventcode.Show();
            this.Hide();
    
        }

        private void pointToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FrmPointJournalier pointQ = new FrmPointJournalier();
            pointQ.Show();
            this.Hide();
        }

        private void btnImprimer_Click(object sender, EventArgs e)
        {
            FrmImprimer imprmer = new FrmImprimer();
            imprmer.Show();
            this.Hide();
        }

        private void imprimerToolStripMenuItem_Click(object sender, EventArgs e)
        {
            FrmImprimer imprmer = new FrmImprimer();
            imprmer.Show();
            this.Hide();
        }
    }
}