Getting a SelectedItem from SQL server to DropDownList

Hi Praveen,

protected void Page_Load(object sender, EventArgs e)
   {
       string cs = ConfigurationManager.ConnectionStrings["samplecnstring"].ConnectionString;
       SqlConnection cn = new SqlConnection(cs);
       SqlDataAdapter da = new SqlDataAdapter("select countryname from country", cn);
       DataSet ds = new DataSet();
       da.Fill(ds, "Country");

       DropDownList1.DataSource = ds;
       DropDownList1.DataTextField = "countryname";
       DropDownList1.DataValueField = "countryname";
       DropDownList1.DataBind();
       DropDownList1.Items.Insert(0, "-Select-");
   }

Have a good day!!!

try
{
if (!IsPostBack)
{
if (drpdwnlist.SelectedValue == null)
{
Response.Redirect("login.aspx");
}

else
{

ListItem lt;
DataSet ds = new DataSet();
ds = balObj.getCustomerValues();

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
lt = new ListItem();
lt.Text = ds.Tables[0].Rows[i][1].ToString();
lt.Value = ds.Tables[0].Rows[i][0].ToString();
this.drpdwnlist.Items.Add(lt);

}

this.drpdwnlist.SelectedIndex = 0;
objComp.CompIntlId = int.Parse(this.drpdwnlist.SelectedValue);
lbldispaly.Text = drpdwnlist.SelectedItem.Value.ToString();
}

}