急啊,高手帮菜鸟,Repeater简单的绑定问题,周末加班做了好几天了~~~~~~~~

Question

SqlConnection conn2 = new SqlConnection("Data Source=ZHANG;Database=AD;uid=sa;pwd=123");
SqlCommand cmd2 = new SqlCommand("select ID from AD_Stat", conn2);
conn2.Open();
SqlDataReader reader2 = cmd2.ExecuteReader();
this.Repeater1.DataSource = reader2 
this.Repeater1.DataBind();

Answer 1

this.Repeater1 = cmd2.ExecuteReader();
reader2.Close();把条件传到SQL语句里去，把获得的数据重新绑定到Repeater

Answer 2

SqlDataReader reader2 = cmd2.ExecuteReader();
this.Repeater1.DataSource = reader2["ID"].ToString();
this.Repeater1.DataBind();
conn.Close();

Answer 3

sORRY.上面写错了 汗~
SqlDataReader reader2 = cmd2.ExecuteReader();
this.Repeater1.DataSource = reader2;
this.Repeater1.DataBind();
conn.Close();

Answer 4

不明白楼主为什么要循环绑定，只要绑一次就OK啦
循环中赋值的话是asp页面要干的事，LZ大概在做.asp向asp.net转型的project吧

Answer 5

SqlConnection conn2 = new SqlConnection("Data Source=ZHANG;Database=AD;uid=sa;pwd=123");
SqlCommand cmd2 = new SqlCommand("select ID from AD_Stat", conn2);
conn2.Open();
SqlDataReader reader2 = cmd2.ExecuteReader();
this.Repeater1.DataSource = reader2}    
this.Repeater1.DataBind();
cmd2.Dispose();
conn.Close();

Answer 6

SqlConnection conn2 = new SqlConnection("Data Source=ZHANG;Database=AD;uid=sa;pwd=123");
SqlCommand cmd2 = new SqlCommand("select ID from AD_Stat", conn2);
conn2.Open();
SqlDataReader reader2 = cmd2.ExecuteReader();
this.Repeater1.DataSource = reader2;    
this.Repeater1.DataBind();
cmd2.Dispose();
conn.Close();

Answer 7

SqlDataReader 可以绑定到数据控件码？
我平时都是使用dataset or datatable
如果使用SqlDataReader时先使用它填充到实体然后在绑定到控件，直接绑定太浪费了