SQL Query to fill default value in comboBox in C#

Create a database and table named Country and fill countries in it.

the database code is here:

create database Earth

use Earth

create table Country (ID int primary key identity (1,1), Name varchar(50))

Take a dropdownlist in webform and the cs code is here:

public partial class WebForm1 : System.Web.UI.Page
{
DataTable dt;
SqlDataAdapter adap;
SqlConnection con = new SqlConnection("YOUR CONNECTION STRING");
protected void Page_Load(object sender, EventArgs e)
{
GetCountry();
}

void GetCountry()
{
DropDownList1.DataSource = Get_Con();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();

DropDownList1.Items.Insert(0, new ListItem("Australia", "0"));
DropDownList1.Items.Insert(1, new ListItem("India","1"));
}

public DataTable Get_Con()
{
adap = new SqlDataAdapter("Select * from Country order by Name", con);
dt = new DataTable();
adap.Fill(dt);
return dt;
}
}
do it and let me know if you have any problem.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nimit Joshi13y ago
Accepted answer
Create a database and table named Country and fill countries in it.

the database code is here:

create database Earth

use Earth

create table Country (ID int primary key identity (1,1), Name varchar(50))

Take a dropdownlist in webform and the cs code is here:

public partial class WebForm1 : System.Web.UI.Page
{
DataTable dt;
SqlDataAdapter adap;
SqlConnection con = new SqlConnection("YOUR CONNECTION STRING");
protected void Page_Load(object sender, EventArgs e)
{
GetCountry();
}

void GetCountry()
{
DropDownList1.DataSource = Get_Con();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();

DropDownList1.Items.Insert(0, new ListItem("Australia", "0"));
DropDownList1.Items.Insert(1, new ListItem("India","1"));
}

public DataTable Get_Con()
{
adap = new SqlDataAdapter("Select * from Country order by Name", con);
dt = new DataTable();
adap.Fill(dt);
return dt;
}
}
do it and let me know if you have any problem.
Nimit Joshi13y ago
If your problem has been solved, accept the answer please.