显示行从表中的数据绑定:我后面有一个从表W1 ....我试图找到一种方法，它可以显示所有TABL W1行，因为现在它只能显示1行显示的弹出窗口代码..有谁知道该怎么办是什么？感谢
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();
}
}