How to iterate through a DataTable

Question

I need to iterate through a DataTable  I have an column there  named ImagePath   When I am using DataReader I do it this way   SqlDataReader dr   null  dr   cmd ExecuteReader    while  dr Read          TextBox1 Text   dr  ImagePath   ToString        How can I achieve the same thing using DataTable

User · Answer

foreach  DataRow row in myDataTable Rows       Console WriteLine row  ImagePath         I am writing this from memory  Hope this gives you enough hint to understand the object model   DataTable -  DataRowCollection -  DataRow  which one can use  amp  look for column contents for that row  either using columnName or ordinal    -    contains

User · Answer

The above examples are quite helpful  But  if we want to check if a particular row is having a particular value or not  If yes then delete and break and in case of no value found straight throw error  Below code works   foreach  DataRow row in dtData Rows                        if  row  Column name   ToString      txtBox Text                                   Getting the sequence number from the textbox                  string strName1   txtRowDeletion Text                      Creating the SqlCommand object to access the stored procedure                    used to get the data for the grid                  string strDeleteData    Sp name                   SqlCommand cmdDeleteData   new SqlCommand strDeleteData  conn                   cmdDeleteData CommandType   System Data CommandType StoredProcedure                      Running the query                  conn Open                    cmdDeleteData ExecuteNonQuery                    conn Close                     GetData                     dtData    DataTable Session  GetData                    BindGrid dtData                    lblMsgForDeletion Text    The row successfully deleted       txtRowDeletion Text                  txtRowDeletion Text                       break                            else                               lblMsgForDeletion Text    The row is not present

User · Answer

You can also use linq extensions for DataSets   var imagePaths   dt AsEnumerble   Select r   gt  r Field lt string gt   ImagePath    foreach string imgPath in imagePaths        TextBox1 Text   imgPath

User · Answer

DataTable dt   new DataTable     SqlDataAdapter adapter   new SqlDataAdapter cmd    adapter Fill dt    foreach DataRow row in dt Rows        TextBox1 Text   row  ImagePath   ToString           assumes the connection is open and the command is set up properly  I also didn t check the syntax  but it should give you the idea

User · Answer

There are already nice solution has been given  The below code can help others to query over datatable and get the value of each row of the datatable for the ImagePath column    for  int i   0  i  lt  dataTable Rows Count  i               var theUrl   dataTable Rows i   quot ImagePath quot   ToString

[c#] How to iterate through a DataTable

Examples related to c#

Examples related to asp.net