how do i use foreach on datarow

See more:

C#

.NET

I want to find out if an input value is equal to one in the datatable. I have used the datarow select method to return all rows in the datatable meeting a certain ID, now i want to loop through these returned rows to find if there is a match between the input value and whats in the datatable. I cant seem to find the proper way to do this. Any help is much appreciated. my code is below:

DataRow[] foundrows = cvmanagerDataSet1.Tables["role"].Select("dept_id = '"+id+"'");
                    foreach(DataRow dr in foundrows)
                         {
                          //  role = foundrows[0].ItemArray[2].ToString();
                            MessageBox.Show(dr["role"]);
                            if (role1.Text == role)
                            {
                                MessageBox.Show("The role '" + role1.Text + "' already exists for this department", "Duplicate role names", MessageBoxButtons.OK, MessageBoxIcon.Error);
                                return;
                                //break;
                            }
                            else
                            {
                                addedroles.Items.Add(role1.Text);
                                role1.Text = "";
                                bttnremove.Enabled = true;
                                bttnreset.Enabled = true;
                                bttndone.Enabled = true;
                                break;
                            }
                          }