.net控件显示动态的数据库信息

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bind();
}
}
public void Bind()
{
int i=1;
string commstr="select * from biao";//biao的组成为id,name,realname
string connstr = "server=(local);database=aaa;uid=sa;pwd=";
SqlConnection conn = new SqlConnection(connstr);
SqlCommand comm = new SqlCommand(commstr, conn);
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
DropDownList1.Items.Add(new ListItem(reader[name].ToString()));
DropDownList1.Items[i].Value = reader[id].ToString();
i++;
}
conn.Close();
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DataRow dr = null;
string connstr = "server=(local);database=aaa;uid=sa;pwd=";
SqlConnection conn = new SqlConnection(connstr);
string strsql=&q