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 <= broj_ds; i++ )
{                                    
    QuantityInIssueUnit_value => VALUE FROM DataTable
    QuantityInIssueUnit_uom  => VALUE FROM DataTable    
}

Is this possible or not? If yes then how to pass data from DataTable to those variables?

Thanks!

It's a int value, serves in a counter, no string to datatable, i use it to count elements in dataset int broj_ds = ds.Tables["Line"].Rows.Count; — CrBruno
– CrBruno, Commented Jul 19, 2012 at 8:41
Why would you want to overwrite the value of your variables on each iteration ? — Stig
– Stig, Commented Jul 19, 2012 at 8:59
I have a for-each loop and in it i have this for loop, for loop must execute as many times as for-each does, not more,not less, so i have to build some kind of counter to work all that — CrBruno
– CrBruno, Commented Jul 19, 2012 at 9:05

Nikhil Agrawal · Accepted Answer · 2012-07-19 08:38:59Z

21

DataTable dr_art_line_2 = ds.Tables["QuantityInIssueUnit"];

for (int i = 0; i < dr_art_line_2.Rows.Count; i++)
{
    QuantityInIssueUnit_value = Convert.ToInt32(dr_art_line_2.Rows[i]["columnname"]);
    //Similarly for QuantityInIssueUnit_uom.
}

answered Jul 19, 2012 at 8:38

Nikhil Agrawal

48.8k25 gold badges134 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HatSoft · Accepted Answer · 2012-07-19 08:41:01Z

8

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"]);
  }

answered Jul 19, 2012 at 8:41

HatSoft

11.3k3 gold badges30 silver badges43 bronze badges

Comments

mamiz · Accepted Answer · 2012-07-19 08:51:44Z

0

I think it will work

for (int i = 1; i <= broj_ds; i++ ) 
  { 

     QuantityInIssueUnit_value = dr_art_line_2[i]["Column"];
     QuantityInIssueUnit_uom  = dr_art_line_2[i]["Column"];

  }

edited Jul 19, 2012 at 8:51

mamiz

275 bronze badges

answered Jul 19, 2012 at 8:43

Anuraj

19.7k7 gold badges61 silver badges84 bronze badges

Comments

Billy Xd · Accepted Answer · 2021-01-11 08:41:54Z

0

For VB.Net is

        Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "database path")
        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)("fieldName")
        Next

answered Jan 11, 2021 at 8:41

Billy Xd

895 bronze badges

Collectives™ on Stack Overflow

Reading values from DataTable

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related