Dynamically Dropdown bind Using C#

In this example, I will show on how to Dynamically Dropdown Bind Using C# 


      
      
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT Email_Id, Id FROM Admin_Deposit WHERE           Status = '" + 1 +"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DropDownList1.DataTextField = "Email_Id";
        DropDownList1.DataValueField = "Id";
        DropDownList1.DataSource = ds;

        DropDownList1.DataBind();

Share this

Related Posts

Previous
Next Post »

Popular Posts