Populating rows with data from a stored procedure using DataTables

Question

I want to populate some fields on a PDF with data from a SQL database, I have a data access class that works but I can't get the values from the rows:

DataAccess DA = new DataAccess();

DataSet S = DA.CashData();

DataTable Cash = S.Tables[0];
DataTable Other = S.Tables[1];
DataTable Check = S.Tables[2];
DataTable Else = S.Tables[3];

string s = "";

foreach (DataRow row in Cash.Rows)
{
    foreach (DataColumn col in Cash.Columns)
    {
        for (int i = 0; i < Cash.Columns.Count; i++)
        {
            DataRow cashRow = Cash.Rows[i];
            s = s + cashRow[0].ToString() + ";";
        }
    }

    Console.ReadLine();
}

string[] data = s.Split(';');
cell32.AddElement(new Paragraph(""));
cell32.AddElement(new Paragraph(data[0]));
cell32.AddElement(new Paragraph(data[1]));

The columns show data but the rows do not

jomsk1e · Accepted Answer · 2016-04-18 08:35:12Z

1

If I understand your source correctly, you have a wrong execution in your loop for the rows, please consider this edited source:

DataAccess DA = new DataAccess();
DataSet S = DA.CashData();
DataTable Cash = S.Tables[0];
DataTable Other = S.Tables[1];
DataTable Check = S.Tables[2];
DataTable Else = S.Tables[3];
string s = "";

foreach (DataRow row in Cash.Rows)
{
    for (int i = 0; i < row.Columns.Count; i++)
    {
        s += row[0].ToString() + ";";
    }
    Console.ReadLine();
}

string[] data = s.Split(';');
cell32.AddElement(new Paragraph(""));
cell32.AddElement(new Paragraph(data[0]));
cell32.AddElement(new Paragraph(data[1]));

answered Apr 18, 2016 at 8:35

jomsk1e

3,6457 gold badges37 silver badges61 bronze badges

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

1 Comment

Nonagon Over a year ago

Hi Jomsk1e Changing the 0 in row[0].ToString to row row[i].Tostring seems to have done the trick! thank you very much

Collectives™ on Stack Overflow

Populating rows with data from a stored procedure using DataTables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related