how to put conditions for this code

hi friend,

Take a bool Flag=false; and use following function to check the int type inside your foreach() loop:

if( int.TryParse(c.Text))
 {
     Flag=true;
 }
else
{
   Flag=false;
}

and put your connectivity Code inside the if() like this:

If(Flag)
{
     SqlConnection con = new SqlConnection();
    con.ConnectionString = ConfigurationSettings.AppSettings["conn"].ToString();
    con.Open();
 // ............. etc and your code will goes here.
}



please mark as answer if it helps.