Display rows from a table in Databound

See more:

C#

Hi I have code behind for a pop windows which displays from table w1....I was trying to find a way where it can display all the rows from tabl w1 cause right now it only displays 1 row..anyone know how to do that? thanks

public partial class Default2 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=xxx.xx.xxx.xxx;Initial Catalog=x;Uid=t;Password=xxx;");
    SqlCommand cmd;
    SqlDataReader dr;
    TextBox email = new TextBox();
    protected void Page_Load(object sender, EventArgs e)
    {
        email.Text = "" + Session["email"];
    }
    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        con.Open();
        cmd = new SqlCommand("SELECT C, P, t,  FROM w1 WHERE email='" + email.Text + "'", con);
        dr = cmd.ExecuteReader();
        con.Close();
    }
}