asp.net sql datareader loop by columns

Question

I have sql query in my asp.net webapp and the result is stored in datareader. Every row in datareader contains 10 columns. I want to fill table with these data. However, I have no idea, how to loop through columns in datareader. I need something like this:

while (vysledky.Read())
{
    TableRow row = new TableRow();
    tab.Controls.Add(row);
    foreach (column in ((datareader(row)))  //it is not real code
    {
      TableCell cell = new TableCell();
      cell.Text = datareader(row).content;
      row.Controls.Add(cell);
    }
}

I hope you got the point. Thanks

Rob · Accepted Answer · 2012-02-09 17:56:17Z

22

Use the FieldCount property of the SqlDataReader:

while (vysledky.Read())
{
    // Iterate over each of the fields (columns) in the datareader's current record
    for (int i = 0; i < vysledky.FieldCount; i++)
    {
        var value = vysledky[i];

        TableCell cell = new TableCell(); 
        cell.Text = Convert.ToString(value); 
        row.Controls.Add(cell); 
    }
}

answered Feb 9, 2012 at 17:56

Rob

45.9k24 gold badges126 silver badges155 bronze badges

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

Comments

user596075 · Accepted Answer · 2012-02-09 17:57:50Z

2

You should just do it through a SqlDataAdapter:

SqlConnection Conn = new SqlConnection(YourConnectionString);
SqlCommand YourSqlCommand = new SqlCommand();
YourSqlCommand.Connection = Conn;
YourSqlCommand.CommandText = "select * from yourtable";

DataTable dt = new DataTable();

SqlDataAdapter sda = new SqlDataAdapter(YourSqlCommand);

sda.Fill(dt);

At the point, your DataTable (dt) contains all of the data from your query.

answered Feb 9, 2012 at 17:57

user596075

3 Comments

Magnus Over a year ago

Looks like its a ASP table not a DataTable

user596075 Over a year ago

@Magnus ASP table? I'm not following. That's definitely a DataTable with complete data from the query of the SqlCommand.

Magnus Over a year ago

@Shark he wants to fill an ASP table not a DataTable. In the question he is referring to TableRow not DataRow

Collectives™ on Stack Overflow

asp.net sql datareader loop by columns

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related