hi,
I have a datagrid.in this datagrid I have a dropdownlist
like below:
the value exists in the database.
how should I get the value from db and set it to the selected value of dropdown and then update it?
 <asp:dropDownList runat="server" id="Flevel" >
            <asp:Listitem value="1">Friend</asp:Listitem>
            <asp:Listitem value="2">Good Friend</asp:Listitem>
            <asp:Listitem value="3">Best Friend</asp:Listitem>
            <asp:Listitem value="4">Acquainted</asp:Listitem>
            <asp:Listitem value="5">Haven't Met</asp:Listitem>
            </asp:dropDownList>

you need to do something like this:

<asp:dropdownlist runat=server id="something" SelectedIndex="<%#intIndex%>" />

where intIndex is declared as public and set on the backend. (You must use selectedIndex as selectedValue isn't accessible through the tag like this)

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

so you say I should write code and then set the intIndex
but can you give example
here is my code
Sub Display_Friends()

Dim strSQL as string
strSQL = "SELECT * from users"
Dim objConnection as New SQLConnection(strConnection)
Dim DataSet As DataSet = New DataSet()
    Dim Cmd as New SQLCommand(strSql,objConnection)


Dim Adapter As SqlDataAdapter = New SqlDataAdapter(Cmd)
Adapter.Fill(DataSet,"friends")
Session("DataView") = dataset.Tables("friends").DefaultView()

    displayFriends.DataSource = Session("DataView")

    if dataset.tables("friends").rows.count >0 then
    displayFriends.DataBind()
    displayFriends.visible="true"

    strCount=dataset.tables("friends").rows.count
    else
    displayFriends.visible="false"
    msgStatus.visible="true"
    msgStatus.text=NoMsg
    end if

End Sub

Since you are statically adding the ListItems it is a tad harder to get the correct index; I almost always use a stored procedure to populate Dropdown values.

Anyway.

What I would do is dynamically create you dropdown lists which will then give you the ability to loop through the result set and set the appropriate index; as it stands right now you have to set up a case statement:

switch([database value])
{
   case "Friend":
       intIndex = 0;
       break;
   case "Good Friend":
       intIndex = 1;
       break;
...etc
}

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Thanks a lot