SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPConnectionString"].ConnectionString);
string strQry = "SELECT user_id FROM member";
SqlCommand cmd = new SqlCommand(strQry, conn);
conn.Open();
Response.Write("<script>javascript:alert('" + strQry + "') </script>");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DropDownList1.Items.Add(reader["user_id"].ToString());
}
reader.Close();
conn.Close();
private void BindDropDownList()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPConnectionString"].ConnectionString);
string strQry = "SELECT user_id FROM member";
SqlCommand cmd = new SqlCommand(strQry, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DropDownList1.Items.Add(reader["user_id"].ToString());
Response.Write("<script>javascript:alert('" + reader["user_id"].ToString() + "') </script>");
}
reader.Close();
conn.Close();
}