C#

I have two tables:Travaux (Works in English) and Actions related by the two fields Nature (table Travaux)and typeTravail(Table Actions).If the user enters the number of the work(NBT the pk_Travaux),the system adds a number of checkboxs equal to the steps that should the user follows to accomplish(field step in Actions table).After that,the user has the possibility  to check or not the step if he did it.All the traitments will be done dynamically with the database

select Etape from Action where ((Travaux.NBT=textbox1.text) and (Travaux.Nature=Action.TypeTravail))

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