using System; using System.Collections.Generic; using System.Linq; using System.Data; using System.Data.OleDb; using System.Text; namespace AccesAuDonnées { class Program { static void Main(string[] args) { //Chaine de connexion String ConnectionString @"Provider Microsoft.Jet.OLEB.4.0; Data Source = C:\Users\omar\Documents\XX.mdb"; OleDbConnection connection = new OleDbConnection(ConnectionString); try { connection.Open(); Console.WriteLine("Open Connection "); Console.Write(""); } catch (Exception e) { Console.WriteLine(e); Console.ReadLine(); } Console.Write(" > Username : "); String Username = Console.ReadLine(); Console.Write(" > Password : "); String Password = Console.ReadLine(); string strSQL "SELECT * FROM [Costumers] where Uername '"+Username+"' AND Password = '"+Password+"'"; OleDbCommand cmd = new OleDbCommand(strSQL,connection); OleDbDataReader rd = cmd.ExecuteReader(); if (rd!=null) while (rd.Read()) { Console.WriteLine("Welcome : " + rd["Username"].ToString()); Console.Read(); } Console.WriteLine("Costumers :" +Username+ " Does not exist ") ; Console.Read(); } } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question"Provider Microsoft.Jet.OLEB.4.0;Data Source C:\Users\omar\Documents\XX.mdb".