Bind DropDownList using SqlDataReader

This code pulling out data from a database into a data reader is as follows.

 protected void Page_Load(object sender, EventArgs e)  
 {  
      if (!Page.IsPostBack)  
      {  
        bindDDL();  
      }  
 }  
 Public void bindDDL()  
 {  
      SqlConnection con =new SqlConnection(ConfigurationManager.  
      ConnectionStrings["ConnectionString"].ConnectionString.ToString();)  
      SqlCommand cmd=new SqlCommand();  
      cmd.connection=con;  
      con.open();  
      cmd.commandText="SELECT Citiid,CitiName FROM tableCity";  
      SqlDataReader dr;   
      dr=cmd.ExecuteReader();  
      ddlname.DataSource =dr;  
      ddlname.DataTextField = "CitiName";  
      ddlname.DataValueField = "Citiid";  
      ddlname.DataBind();  
      dr.close();   
      con.close();  
 }  

Thanks & Regards
Santosh

Read More

Bind dropdownlist default value

On RowDataBound
ddlCountry.SelectedValue = Ds.Tables[0].Rows[e.Row.RowIndex]["CountryId"].ToString();

On SelectedIndexChanged
ddlRGroup.SelectedValue = Ds.Tables[0].Rows[0]["RatingId"].ToString();

if (!Page.IsPostBack)
SqlDataReader dr = SqlHelper.ExecuteReader(connectionString, "tblFormula_Select", Convert.ToInt32(ViewState["CKFId"]), "S");
ddlTemp.SelectedValue = dr["TemplateId"].ToString();

Read More