C#

Tunisien86 wrote:

But still the same error.

string connectionString = @"Data Source='Mobile Device\Program Files\MyApplication\Orders.sdf';"

Tunisien86 wrote:

Also,I don't understand u note:

I are Troll

string chcc = "Data Source=C:\\Users\\Admin\\Documents\\Visual Studio 2008\\Projects\\GMAOMobile\\ModeDifféré\\BaseGmaoLocale.sdf;Persist Security Info=False;";

adapter.Fill(ds);

cannot found table 0

Tunisien86 wrote:

and also the step

adapter.Fill(ds, "SQL Temp Table");

I are Troll

sql = "Select login from Connexion where login=@login and MotPass=@MotPass ";

ds.Tables("Connexion").Rows.Count) - 1

Tunisien86 wrote:

Select login from Connexion where login=@login and MotPass=@MotPass

Tunisien86 wrote:

Also i wanna now how to deal with the result of the

I are Troll

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



        }

Tunisien86 wrote:

This is the code that solved my problem

I are Troll

sudhir behera wrote:

134000 records in my ... combo box

sudhir behera wrote:

opening the page.it is taking 45 seconds to load data from sql serer into combo box

sudhir behera wrote:

have 134000 records ... binded ... in the combo box

sudhir behera wrote:

please help me how will make it faster

writer.WriteAttributeString("testAtribute", "Hello world");

Nematjon Rahmanov wrote:

We are haven't bug,just temporarily undecided problems
It's not a bug, it's a feature!!!