how to deploy your software (set up)

[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

[ago2486]

thank you very much I am always looking for the solution of my problem. I hope to escape