ASP.NET ---- How to get database value as dropdownlist selected value

[arunbojan]

Hi All,

I have an editable datagrid with 10 columns, one of those is ddl column which I used for showing the status....

[ Please note : Status is a template column with an item template as label... and edit item template as dropdownlist]

By default all the columns are readonly, when user clicks edit, status ll be enabled and im getting the values in the grid.......

say, following are the values in status

Beginner
Intermediate
Expert

If i update my status as Expert it should show Expert in my next edit, but dropdownlist always takes first value ..... Can any one help me how to fetch the database value as dropdownlist selected value......


Thanks a lot in Advance ......

[dmj07]

Attach a databound event to your dropdownlist on .aspx page e.g.

<asp:DropDownLi st ID="ddl" runat="server" OnDataBound="dd l_DataBound" />

Then in code behind retrieve value from database and make it selected value on drop down list e.g.

protected void ddl_DataBound(o bject sender, EventArgs e)
{
//Connect to SQL and run select statement to retrieve value
//i.e. SELECT Status FROM Table WHERE......

SqlDataReader rdr = cmdUser.Execute Reader();

while (rdr.Read())
{
ddl.ClearSelect ion();
ddl.Items.FindB yText(rdr.GetSt ring(0)).Select ed = true;
}
rdr.Close();
}