how to get grid dropdown value in variabe. i am populated gridview here.
my code
<asp:GridView ID="gvUserInfo" runat="server" AutoGenerateColumns="false" OnRowDataBound="gvAppraisalForm_RowDataBound" CellSpacing="10">
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
<Columns>
<asp:BoundField DataField="sName"/>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<asp:DropDownList ID="ddlCharacteristics" runat="server" Width="200px" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void BindGridview()
{
SqlCommand cmd = new SqlCommand("select lAppraisalCharacteristicsID,sName from tblAppraisalCharistics", oSQL._SQLConnection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
gvUserInfo.DataSource = ds;
gvUserInfo.DataBind();
}
protected void gvAppraisalForm_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
var ddl = (DropDownList)e.Row.FindControl("ddlCharacteristics");
//int CountryId = Convert.ToInt32(e.Row.Cells[0].Text);
SqlCommand cmd = new SqlCommand("select * from tblAppraisalGrade", oSQL._SQLConnection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddl.DataSource = ds;
ddl.DataTextField = "sDescription";
ddl.DataValueField = "nScore";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("N-NON Evaluation", "0"));
}
}