C#

private void button1_Click(object sender, EventArgs e)
        {
            //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 NBT, Nature from Travaux where NBT=@NBT ";

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

            command.Parameters.Add(NBT);
            //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);
            }
            foreach (DataRow da in adapter)
            { string s = adapter["Nature"]; }

            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("Numéro de BT trouvé");
                    SqlCeCommand command1 = sqlceconn.CreateCommand();
                    command1.CommandText = "Select NoEtape, Etape from Travaux where TypeTravail=@typ ";

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

                    command1.Parameters.Add(Typ);
                    SqlCeDataAdapter adapt = new SqlCeDataAdapter(command1);

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

                    try
                    {
                        adapt.Fill(dat, "SQL Temp Table");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    foreach (DataRow ligne in adapt.)
                    {
                        System.Console.WriteLine(adapt[0]);
                    }


                    
                }
                else MessageBox.Show("Veuillez saisir un autre NBT");
            }
            adapter.Dispose();
            sqlceconn.Dispose();
            command.Dispose();

        }

Error	1	foreach statement cannot operate on variables of type 'System.Data.SqlServerCe.SqlCeDataAdapter' because 'System.Data.SqlServerCe.SqlCeDataAdapter' does not contain a public definition for 'GetEnumerator'	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Travail.cs	
Error	2	Cannot apply indexing with [] to an expression of type 'System.Data.SqlServerCe.SqlCeDataAdapter'	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Travail.cs	
 Error	3	foreach statement cannot operate on variables of type 'System.Data.SqlServerCe.SqlCeDataAdapter' because 'System.Data.SqlServerCe.SqlCeDataAdapter' does not contain a public definition for 'GetEnumerator'	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Travail.cs	

 Error	4	Cannot apply indexing with [] to an expression of type 'System.Data.SqlServerCe.SqlCeDataAdapter'	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Travail.cs	

surender.m wrote:

I hope it can not be done like

• You should do a sanity check over what you are doing. If you want to pass objects/information round as strings, you can easily serialize/deserialize between objects and XML. Here, most of the work is done for you
• If you can't change the format, and you have a limited number (e.g. 10 or so) of inbound types, just implement a simple if statetment.
• If you have more types to deal with, you'll need to do the work by reflection. Reflection takes much more code and is relatively messy.