How to bind DropDownList from DataBase in ASP.NET with C# - Asp.Net,C#,Sql server,jquery,Angularjs,Mvc,interview tips and coding tips

Creating a table like this format

create table tblCity

(

Id int identity,

City varchar(10)

)

insert into tblCity values('Mumbai')

insert into tblCity values('Delhi')

insert into tblCity values('Pune')

Write your database connection string in web.config file within <connectionStrings> tag.

<configuration>

  <connectionStrings>

    <add name="MyConnString" connectionString="server=ipaddress;database=DBNAme;uid=sa;password=sa;"

    providerName="System.Data.SqlClient"/>

   </connectionStrings>

</configuration>

<asp:DropDownList ID="ddlCity" runat="server"></asp:DropDownList>

//retrieving connection string from web.config file

        string MyConnString = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString;

        SqlConnection con=null;

        SqlCommand cmd=null;

        protected void Page_Load(object sender, EventArgs e)

            if (!IsPostBack)

                BindDropDown();

        public void BindDropDown()

            con = new SqlConnection(MyConnString);

            cmd = new SqlCommand("select Id,City from tblCity", con);

            cmd.CommandType = CommandType.Text;

            con.Open();

            SqlDataAdapter sda = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            sda.Fill(ds);

            ddlCity.DataSource = ds;

            ddlCity.DataTextField = "City";

            ddlCity.DataValueField = "Id";

            ddlCity.DataBind();

            ddlCity.Items.Insert(0, new ListItem("--select--"));

Output: