C#

private void button1_Click(object sender, EventArgs e)
        {

            /*string req = "select Login, MotPasse from Connexion";
            DataTable tab = new DataTable();
            SqlCeCommand com = new SqlCeCommand(req, sqlceconn);
            SqlCeDataAdapter ada = new SqlCeDataAdapter(com);
            ada.Fill(tab);*/
            //Create the connection
            string wCS = @"Data Source =\Storage Card\ModeDifféré\BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn = new SqlCeConnection(wCS);

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

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

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

            command.Parameters.Add(Login);
            command.Parameters.Add(MotPasse);

            //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);
                if(ds.Tables["SQL Temp Table"].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");}
            adapter.Dispose();
            sqlceconn.Dispose();
            command.Dispose();



        }

<br />
PrintDocument document = new PrintDocument();<br />
<br />
document.PrinterSettings.DefaultPageSettings.PrinterResolution.X = 300;<br />
document.PrinterSettings.DefaultPageSettings.PrinterResolution.Y = 300;<br />
<br />

LoadCubeInBackground = New BackgroundWorker();
LoadCubeInBackground.WorkerReportsProgress = True;
LoadCubeInBackground.WorkerSupportsCancellation = True;

LoadCubeInBackground.DoWork += new DoWorkEventHandler(LoadCube);
LoadCubeInBackground.ProgressChanged += new ProgressChangedEventHandler(LoadCubeInBackground_ProgressChanged);

LoadCubeInBackground.RunWorkerAsync(_connectionString);

Luc Pattyn wrote:

1. is the code shown running on the main thread? BGW does NOT behave the way one expects when created on another thread!

Luc Pattyn wrote:

2. what is inside DoWork(), could you show the first few lines?

//Open DataCube
ADODB.Connection oCn = New ADODB.Connection();
ADOMD.Catalog oCat = New ADOMD.Catalog();

LoadCubeInBackground.ReportProgress(0, "Opening Data Cube");

ConnectionString myCStringType = e.Argument;

Luc Pattyn wrote:

3. "the first line of my LoadCube function never gets hit." how do you observe that?

Luc Pattyn wrote:

4. Environment.GetCommandLineArgs. Beware command line length limitations (could be 2K).