C#, Looping through dataset and show each record from a dataset column

Question

In C#, I'm trying to loop through my dataset to show data from each row from a specific column. I want the get each date under the column name "TaskStart" and display it on a report, but its just shows the date from the first row for all rows can anybody help?

 foreach (DataTable table in ds.Tables)
 {

     foreach (DataRow dr in table.Rows)
     {
         DateTime TaskStart = DateTime.Parse(
             ds.Tables[0].Rows[0]["TaskStart"].ToString());
         TaskStart.ToString("dd-MMMM-yyyy");
         rpt.SetParameterValue("TaskStartDate", TaskStart);
     }
 }

score 24 · Answer 1 · edited Mar 06 '13 at 16:19

24

I believe you intended it more this way:

foreach (DataTable table in ds.Tables)
{
    foreach (DataRow dr in table.Rows)
    {
        DateTime TaskStart = DateTime.Parse(dr["TaskStart"].ToString());
        TaskStart.ToString("dd-MMMM-yyyy");
        rpt.SetParameterValue("TaskStartDate", TaskStart);
    }
}

You always accessed your first row in your dataset.

edited Mar 06 '13 at 16:19

Eric Leschinski

146,994
96
417
335

answered Mar 06 '13 at 16:06

bash.d

13,029
3
29
42

score 14 · Accepted Answer · answered Mar 06 '13 at 16:06

14

DateTime TaskStart = DateTime.Parse(dr["TaskStart"].ToString());

answered Mar 06 '13 at 16:06

Denys Denysenko

7,598
1
20
30

Hi Thanks for the reply, now its just showing the last date on the last row for all records? – Peter Mar 06 '13 at 16:07
It looks like you have issue with your rpt.SetParameterValue("TaskStartDate", TaskStart); because you setting it at each lap but you use it elswhere outside of it. Also your formatted date doesn't go anywhere as well. – Denys Denysenko Mar 06 '13 at 16:09

score 8 · Answer 3 · edited May 18 '14 at 12:39

8

foreach (DataRow dr in ds.Tables[0].Rows)
{
    //your code here
}

edited May 18 '14 at 12:39

Alexey Malev

6,408
4
34
52

answered May 18 '14 at 12:14

Chưa biết

919
8
6

score 7 · Answer 4 · edited Jul 01 '14 at 08:43

7

foreach (DataTable table in ds.Tables)
{
    foreach (DataRow dr in table.Rows)
    {
        var ParentId=dr["ParentId"].ToString();
    }
}

edited Jul 01 '14 at 08:43

famousgarkin

13,687
5
58
74

answered Jul 01 '14 at 08:21

Vaishakh

71
1
1

score 0 · Answer 5 · answered Feb 02 '23 at 11:34

0

        foreach (DataRow table in ds.Tables[0].Rows)
        {
                int ForType = Convert.ToInt32(table["Fortype"].ToString());
                ds.Tables[0].DefaultView.RowFilter = "ForType ='" + ForType +"'";
                rbtnQuestion.DataSource = ds.Tables[0].DefaultView;
                rbtnQuestion.DataBind();

        }

answered Feb 02 '23 at 11:34

Sumit Kumar Keshri

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Feb 04 '23 at 20:21

C#, Looping through dataset and show each record from a dataset column

5 Answers5