I've wrote this code to read from database:

```
SqlDataReader DR1 = Cmd.ExecuteReader();
if (DR1.Read))
{
Textbox1.text =DR1.GetValue(0).ToString();
TextBox2.text = DR1.GetValue(1).ToString();
}

```

This displays the *first* row from the table. How can I continue to iterate through the table and store/display all values?