How Do I Bind Dropdown To Value Present In Database

See more:

C#

ASP.NET

C#3.5

I am using datalist control an asp.net using C# and sqlserver 2008.I have a dropdown in datalist and need to display it's current value from database on page load.

i have tried this so far

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
       {

if (e.Item.ItemType == ListItemType.Item)
{ DropDownList ddlshowit = (DropDownList)e.Item.FindControl("DropDownList4");
ddlshowit.DataSource = ds;
ddlshowit.DataTextField = "showit";
ddlshowit.DataValueField = "showit";
ddlshowit.DataBind();
}
}

I also used

SelectedValue='<%#Eval("showit")%>' but it also did'nt work. Please Help