How Do I Loop Through A List And Display Result For Each List Items

See more:

C#5.0

how everyone, how can i iterate through a list and display values for each list items,

i am retrieving a column from sql database and store in a list :var listAttributeRegion = new List<long>( ); the listAttributeRegion contains dataid values in this format: 50600,50601,50602,50603,50604 etc,

i want to pass each of this values from the list as parameter values to a select statement, and bind the resulting result set to a datagrid and also insert to a table in the database. here is my code:

while ( reader.Read( ) )
                   {

                       listAttributeRegion.Add(Convert.ToInt64(reader["id"].ToString( )) );


                   }

                   foreach ( long k in listAttributeRegion )
                   {
                       var dataId = k;

                       try
                       {

                           using ( var strCon = new SqlConnection( ConfigurationManager.ConnectionStrings["edms"].ConnectionString ) )
                           {
                               using ( var com = new SqlCommand( "Select l.AttrID , l.ValStr from csowner.LLAttrData l join csowner.dtree d on  ID = d.DataID where d.DataID = @DataID order by l.AttrID asc", strCon ) )
                               {
                                   com.CommandType = CommandType.Text;
                                   com.Parameters.Add( "@DataID", SqlDbType.Int ).Value = dataId;
                                   using ( var adapter = new SqlDataAdapter( com ) )
                                   {

                                       using (var ds = new DataSet( ) )
                                       {
                                           adapter.Fill( ds );
                                           dataGridView1.DataSource = ds.Tables[0];
                                       }
                                   }
                               }
                           }
                       }
                       catch ( SqlException ex )
                       {

                       }
                          reader.Close( );
                   }

The above code populates ds with results set, when each dataid is passed, i want to able to append/combine all result sets and display in a datagrid, also insert to a table. Please any assistance on how to do this will be appreciated.