One of various ways to do this: Use a dynamically created web page for the page that you do not want to be directy accessed. When page one is accessed, properly, and with your predetermined permission; then page two is made available via a javascript that directs them to page two with it's dynamically created name. Example: Page 1 = daPage01.html Page 2 = [does not exist except in the database] User goes to Page 2 : Oh wait! There is no Page 2. That page is still in the database. User goes to Page 1. There is no link to Page 2. User does what YOU want them to do on Page 1. Page 2 is created dynamically with a changable name. Exmaple: daPage12E13F4576496587G5447868764K5P7q84578_02.html Page 2 is then added to Page 1 for that user to click on and to go to. Later that user goes to Page 2 via that link. Oh wait! When they were detected of having closed or left Page 1 and *also* closed or left Page 2 then Page 2 was removed from the system. There is no Page 2 for them.

private void Ajouter (String refProd, String quantite, String design, String prixU, String prixTtc) { String\[\] row = { refProd, quantite, design, prixU, prixTtc }; ListViewItem item = new ListViewItem(row); listView1.Items.Add(item); } private void BtnAjouter_Click(object sender, EventArgs e) { double total; decimal total_achat; if (Lbl\_Affich\_Designation.Text == "" || Lbl\_Affich\_PrixUnitaire.Text == "" || TxtQteCmd.Text == "" || Lbl\_affich\_TxtQteStock.Text == "" || CmbRef\_Produit.Text == "") { MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (CmbRef\_Produit.Text != "") { double a = 0; double b = 0; double c; int nbprod; double.TryParse(TxtQteCmd.Text.Trim(), out a); double.TryParse(Lbl\_affich\_TxtQteStock.Text.Trim(), out b); double.TryParse(Lbl\_Affich\_PrixUnitaire.Text.Trim(), out c); if (a <= b) { total = a \* c; total\_achat = 0; nbprod = 0; try { using (OleDbCommand cmd = d.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", CmbRef\_Produit.Text); cmd.Parameters.AddWithValue("@qute\_det", TxtQteCmd.Text); cmd.Parameters.AddWithValue("@Designation", Lbl\_Affich\_Designation.Text); cmd.Parameters.AddWithValue("@Prix\_unitaire\_HT", Lbl\_Affich\_PrixUnitaire.Text); cmd.Parameters.AddWithValue("@Prix\_total\_HT", total);

public class ConnectionDB { // Declaration des objets sql public OleDbConnection sql\_con; public OleDbCommand sql\_cmd; public OleDbDataAdapter DB; public DataSet DS = new DataSet(); public DataTable DT = new DataTable(); public OleDbDataReader DR; public string connetionString = null; // declaration de la methode connecter public void CONNECTER() { //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); } // declaration de la methode deconnecter public void DECONNECTER() { if (sql\_con.State == ConnectionState.Open) { sql\_con.Close(); } } public partial class Form1 : Form { public Form1() { InitializeComponent(); } ConnectionDB d = new ConnectionDB(); private void LoadDB() { using (OleDbConnection sql_con = new OleDbConnection(d.connetionString)) { sql_con.Open(); using (OleDbCommand sql_cmd = d.sql_con.CreateCommand()) { string CommandText = "SELECT * FROM Detail_temp"; d.DB = new OleDbDataAdapter(CommandText, d.sql_con); d.DS.Reset(); d.DB.Fill(d.DS); d.DT = d.DS.Tables[0]; dataGridView1.DataSource = d.DT; d.DECONNECTER(); } } } private void Form1_Load(object sender, EventArgs e) { try { LoadDB(); d.sql\_con.Open(); TxtQteCmd.Text = "1"; Lbl\_Affich\_TotalCmd.Text = "0"; LblAfficDate.Text = DateTime.Now.ToString(); using (OleDbCommand cmbox = d.sql\_con.CreateCommand()) { cmbox.CommandText = "SELECT Code\_article FROM Catalogue";

Understood sir and thank you for your frankness. I will continue following your advice

Off topic, but why do you keep putting your messages in text tags? 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.

Yes, that's fine - you don't need the "AS LastID" because ExecuteScalar doesn't return labels, but it doesn't matter if you add it. "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

thank you sir i will do it now

You are storing passwords in plain text. Don't do that! Secure Password Authentication Explained Simply[^] Salted Password Hashing - Doing it Right[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

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

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

You already posted this question at help me - Visual Basic Discussion Boards[^]. Please do not repost.

Where is the connectionstring? I do not see anything that references your database-file. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)