how to deploy your software (set up)

[Lost User]

You need to install System.Data.SQLite[^] on the target system.

[ago2486]

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

[ago2486]

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?

[Lost User]

You need to follow the instructions of your setup builder. I think external libraries need to be added as dependencies.

[ago2486]

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 ...

[Lost User]

SQLite is not part of the standard .NET framework, it must be downloaded from the SQLite website.

[ago2486]

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?

[Lost User]

The alternative is that you add the requirement to your setup program, so it is automatically installed. Check the documentation for the setup generator that you are using.

[ago2486]

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

[ago2486]

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

:wtf: :wtf:

[Lost User]

You need to check your code and your setup. Either the database is in a protected folder, or your open statement needs an extra parameter.

[ago2486]

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

[ago2486]

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 s

[Lost User]

Sorry, I have no idea why you have posted all that code. You need to do some investigation and debugging to find out what is happening.

[ago2486]

ok sir i'm doing some research and giving you a follow up of my research.
Thank you for your patience and your availability

[Lost User]

The files you need to "distribute" are in your "bin\Release" folder. Create your setup and test on your machine. Then "zip it" and send it to your fiends via the "cloud". No "CD burning". DVD/CD drives are "optional" these days ... not the ".NET framework"; unless your friends are running XP.

"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal

[ago2486]

Thank you sir but I have an error message when I want to make a recording: Failed to connect to the data source
attempt to write a readonly database
I am looking for documentation to this problem but not in continuation

[Lost User]

What's "in the database"? Nothing? Then create it on site. Read SQLite goes "read only" with certain installations; nothing to do with C#. Google "sqlite read only" for lots of "answers". Shoulda used SQL Server CE.

"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal

[ago2486]

Hello Gerry Schmitz and thank you for your help, I will document and make you a return, But I would like you to guide me on a code that I saw during but research:
Read only connection
Data Source = c: \ mydb.db; Version = 3; Read Only = True;
I even use this connection but the same error message is displayed ...

[Lost User]

Sorry, don't understand the "question". I said the "install" is the problem; not the "connection string". My "solution" is SQL Server CE; otherwise, you have the internet's "solutions" ... because, I do not use SQLite.

"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal