C#

//Create a DataTable for binding to combobox
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");

//Read values from dbase and fill it in datatable
//I am taking DataReader here

while(reader.Read())
{
DataRow dr = dt.NewRow();
dr["ID"] = reader.GetValue(0);
dr["Name"] = reader.GetValue(0) + reader.GetValue(1);
dt.Rows.Add(dr);
}

combobox.DataSource = dt;
combobox.DataBind();

Tunisien86 wrote:

ListViewItem

C#

item = new listviewitem();
if (item != null)

item = lv.SelectedItems(0);

ListView lv = (ListView)sender;

ListViewItem item = new listviewitem();
item = lv.SelectedItems(0);
if (item != null)
{....

Error	2	'System.Windows.Forms.ListView' does not contain a definition for 'SelectedItems' and no extension method 'SelectedItems' accepting a first argument of type 'System.Windows.Forms.ListView' could be found (are you missing a using directive or an assembly reference?)	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Form1.cs	24	11	ModeDifféré

ListView lv = (ListView) sender;

if (lv.SelectedItems.Count <> 0)
{
    ListViewItem item = lv.SelectedItems[0];
    switch (item.Text)
    {
        ...

it should work, however I don't think wildcards are a good idea for authentication.
Chances are entering

username: a
password: a

will let you in, as it would match Jan/MySecretPassword as well as an infinite number of other possible accounts.

Smile 

LIKE '%a%'

a
aaaa
bac
WhateverTheUserEntersAsLongAsItContainsAtLeastOneLowerCaseA

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

namespace ModeDifféré
{
    public partial class Connexion : Form
    {
        public Connexion()
        {
            InitializeComponent();
        }

        private void Connexion_load(object sender, EventArgs e)
        {
            createconnexion();
        }

        private void createconnexion()
        {
            /*string chbd= Environment. + "\\BaseGmaoLocale.sdf";
            //string chcon= "Data source=\'[0]'\ BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn= new SqlCeConnection(chcon);
            sqlceconn.Open();*/
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string chcon = null;
            SqlCeCommand command;
            SqlCeDataAdapter adapter = new SqlCeDataAdapter();
            adapter.TableMappings.Add("Table", "Connexion");
            DataSet ds = new DataSet();
            string sql = null;
            string login,MotPass;
            sql = "Select login from Connexion where login=@login and MotPass=@MotPass ";
            string chcc= "BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn= new SqlCeConnection(chcc);
            sqlceconn.Open();
            try
            {
                  sqlceconn.Open();
                command = new SqlCeCommand(sql, sqlceconn);
                adapter.SelectCommand = command;
                adapter.Fill(ds, "SQL Temp Table");
                adapter.Dispose();
                command.Dispose();
                sqlceconn.Close();

                MessageBox.Show("Number of row(s) - " + ds.Tables[0].Rows.Count);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can not open connection ! ");
            }
            if (ds.Tables[0].Rows.Count != 0)
            {
                MessageBox.Show("Authentification réussie");
                MenuP m = new MenuP();
                m.Show();
            }
            else
            {
                MessageBox.Show("Login ou mot de passe incorrect veuillez réessayer");
            }
        }
    }
}

Warning	1	The variable 'chcon' is assigned but its value is never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	2	The variable 'login' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	3	The variable 'MotPass' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	4	The variable 'ex' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	

//Create the connection
string chcc= "Data Source = BaseGmaoLocale.sdf;";
SqlCeConnection sqlceconn= new SqlCeConnection(chcc);

//Create the command
SqlCeCommand command = sqlceconn.CreateCommand();
command.CommandText = "Select login from Connexion where login=@login and MotPass=@MotPass ";

//Add the parameters
string s1; //store the login name here YOU MUST FILL THIS IN
SqlCeParameter login = new SqlCeParameter("@login", SqlDbType.NVarChar);
login.value = s1;

string s2; //store the password here YOU MUST FILL THIS IN
SqlCeParameter MotPass = new SqlCeParameter("@MotPass", SqlDbType.NVarChar);
MotPass.value = s2;

command.Parameters.Add(login);
command.Parameters.Add(MotPass);

//Create the adapter
SqlCeDataAdapter adapter = new SqlCeDataAdapter(command);

//Create and fill the dataset
DataSet ds = new DataSet();

try
{
   adapter.Fill(ds, "SQL Temp Table");
}
catch (Exception ex)
{
   MessageBox.Show(ex.Message);
}
if ((ds.Tables.Count > 0) && (ds.Tables["SQL Temp Table"] != null))
    MessageBox.Show("Number of row(s) - " + ds.Tables["SQL Temp Table"].Rows.Count);

adapter.Dispose();
sqlceconn.Dispose();
command.Dispose();

string req = "SELECT * FROM Connexion WHERE Login = @login AND MotPasse = @pass";
SqlCeCommand cmd = new SqlCeCommand(req, cnx);
SqlCeParameter login = new SqlCeParameter("login", s1);
cmd.Parameters.Add(login);
SqlCeParameter pass = new SqlCeParameter("pass", s2);
cmd.Parameters.Add(pass);

string req = "SELECT * FROM Connexion WHERE Login = @login AND MotPasse = @pass";
SqlCeCommand cmd = new SqlCeCommand(req, cnx);
SqlCeParameter login = new SqlCeParameter("@login", s1);
cmd.Parameters.Add(login);
SqlCeParameter pass = new SqlCeParameter("@pass", s2);
cmd.Parameters.Add(pass);

object value = cmd.ExecuteScalar();
if (value != DbNull.Value)
{
   MessageBox.Show("Authentification réussie");
}