Reading values from DataTable

Question

I have a DataTable populated with samo data values and I want to read data from DataTable and pass it to a string variable   I have this code    DataTable dr art line 2   ds Tables  QuantityInIssueUnit      I have a countert like this   for  int i   1  i  lt   broj ds  i                                               QuantityInIssueUnit value   gt  VALUE FROM DataTable     QuantityInIssueUnit uom    gt  VALUE FROM DataTable         Is this possible or not  If yes then how to pass data from DataTable to those variables   Thanks

User · Answer

You can do it using the foreach loop  DataTable dr art line 2   ds Tables  QuantityInIssueUnit       foreach DataRow row in dr art line 2 Rows           QuantityInIssueUnit value   Convert ToInt32 row  columnname

User · Answer

DataTable dr art line 2   ds Tables  QuantityInIssueUnit     for  int i   0  i  lt  dr art line 2 Rows Count  i          QuantityInIssueUnit value   Convert ToInt32 dr art line 2 Rows i   columnname           Similarly for QuantityInIssueUnit uom

User · Answer

For VB Net is         Dim con As New OleDb OleDbConnection  quot Provider Microsoft Jet OLEDB 4 0 Data Source  quot     quot database path quot           Dim cmd As New OleDb OleDbCommand         Dim dt As New DataTable         Dim da As New OleDb OleDbDataAdapter         con Open           cmd Connection   con         cmd CommandText   sql         da SelectCommand   cmd          da Fill dt           For i As Integer   0 To dt Rows Count             someVar   dt Rows i   quot fieldName quot           Next

User · Answer

I think it will work  for  int i   1  i  lt   broj ds  i                 QuantityInIssueUnit value   dr art line 2 i   Column         QuantityInIssueUnit uom    dr art line 2 i   Column

[c#] Reading values from DataTable

Examples related to c#

Examples related to datatable