Retrieve data from database to dropdownlist

See more:

C#

ASP.NET

drop-down

Hi,I am ceating a web application.In that i have registration form with some text boxes and dropdown list.When i retrieve and fill the controls with the data from database ,In 'Gender' drop down list the actual gender is not displaying.Always the first item is being displayed.how can i retrieve from database and display a user's Gender value selected on the dropdownlist.These are my asp and C# codes.

This is the code for loading a record and filling them in web controls for editing.

SqlCommand cmd = new SqlCommand("spu_RetriveUserValue", SqlConObject);
                   cmd.CommandType = CommandType.StoredProcedure;
                   DataTable dt = new DataTable();
                   cmd.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = id;
                   SqlConObject.Open();
                   SqlDataAdapter da = new SqlDataAdapter(cmd);
                   da.Fill(dt);
                   if (dt.Rows.Count > 0)
                   {
                   txtEmployeeName.Text = dt.Rows[0]["Employee_Name"].ToString();
                   ddlGender.SelectedItem.Value = dt.Rows[0]["Gender"].ToString();
                   txtDateOfJoining.Text = dt.Rows[0]["JoinedDate"].ToString();
                   txtAddress.Text = dt.Rows[0]["Employee_Address"].ToString();
                   ddlCountry.SelectedItem.Text = dt.Rows[0]["Country"].ToString();
                   int CountryID =Convert.ToInt32(dt.Rows[0]["Country_ID"]);
                   Bind_ddlCity(CountryID);
                   ddlCity.SelectedItem.Text = dt.Rows[0]["City"].ToString();
                   txtEMail.Text = dt.Rows[0]["Employee_Email"].ToString();
                   ddlDeptName.Text = dt.Rows[0]["Employee_Department"].ToString();
                   }
                   else
                   {
                       lblError.Text = "No matching record found";
                   }

<pre lang="HTML">
 <asp:DropDownList ID="ddlGender" runat="server">
                               <asp:ListItem>Select</asp:ListItem>
                                    <asp:ListItem Value="M">Male</asp:ListItem>
                                    <asp:ListItem Value="F">Female</asp:ListItem>
                                </asp:DropDownList>

Help me out friends...