Looping through dataset rows conditionally outputting columns

Hi All,

I have a dataset containing a similar table to the 1 below:

ProductTypeID      Title     Colour
1                            Shirt    Blue
2                            Lace    NULL
1                            Shirt    Blue

Please could anyone show me how to iterate through each row in the dataset writing it to the browser using response.write() but if the ProductTypeID isn't 1 then omit the Colour column?

Many thanks,

Rit
LVL 1
rito1Asked:
Who is Participating?
 
nmarunCommented:
There are different ways to do this. Here's one:

string sqlConnection = "define connection string here";
//http://www.connectionstrings.com/
 
using (SqlConnection sqlConn = new SqlConnection(sqlConnection))
{
    SqlCommand cmd = new SqlCommand("Select ProductTypeID, Title, Colour from myTable", sqlConn);
    SqlDataReader rdr = cmd.ExecuteReader();
    Response.Write("<table><tr><th>ID</th><th>Title</th><th>Colour</th></tr>");
    while(rdr.Read())
    {
        if(rdr["ProductTypeID"].ToString() == "1")
        {
            Response.Write("<tr><td>" + rdr["ProductTypeID"] + "</td><td>" + rdr["Title"] + "</td><td></td></tr>");
        }
        else
        {
            Response.Write("<tr><td>" + rdr["ProductTypeID"] + "</td><td>" + rdr["Title"] + "</td><td>" + rdr["Colour"] + "</td></tr>");
        }
    }
}

Open in new window

0
 
rito1Author Commented:
Excellent. This suits what I am doing. Thank You
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.