SQL query results are stored in a DataTable and then data is taken from a DataTable

  for(inti =0; i < dt. Rows.Count; i++)            {                strings ="Select COUNT (*) from"+ dt. rows[i]["aliasname"] +". Dbo.web_historydata where factoryid="+ dt. rows[i]["Factoryid"] +"and datetime >dateadd (Hour,-1,getdate ())"; intCount =my_sqlhelper.selectcounts (s); if(count<=0) {Log.save ("Shu Hkta is so handsome."); }            }

If you don't know what the column name is, you can also traverse

    for (int0; i < dataTable.Rows.Count; i++)            {                for (int0; j < DataTable.Columns.Count; J + + )                {                    Console.WriteLine (Datatable.rows[i][j]. ToString ());                 }             }

SQL query results are stored in a DataTable and then fetch data from a DataTable