Dropdown list value and text issue

Question

Hello,

 

this is my code to save the record into database

SqlCommand cmd = new SqlCommand("INSERT INTO ABC (ComplainerName," +
" ComplainerAddress,ComplainerMobile,ComplaintFor," +
" BuildingDevelopment,PlantMachCategory,PlantMachSubCategory,PlantMachItem,ItemIdentification)" +
" VALUES(@lblnamea,@lblFlatno,@lblMobile,@ComplaintFor,@BuildingDevelopment,@ddlAssetCat," +
" @ddlAssetSubCat,@ddlAssetItem,@ddlItemIdentification)");
cmd.Parameters.AddWithValue("@lblnamea", lblMeter.Text);
cmd.Parameters.AddWithValue("@lblFlatno", lblFlatno.Text);
cmd.Parameters.AddWithValue("@lblMobile", lblMobile.Text);
cmd.Parameters.AddWithValue("@ddlAssetCat", ddlAssetCat.SelectedValue);
cmd.Parameters.AddWithValue("@ddlAssetSubCat", ddlAssetSubCat.SelectedValue);
cmd.Parameters.AddWithValue("@ddlAssetItem", ddlAssetItem.SelectedValue);
cmd.Parameters.AddWithValue("@ddlItemIdentification", ddlItemIdentification.SelectedValue);

i did save the value in sql database

 

ddlAssetCat.SelectedValue,dlAssetSubCat.SelectedValue,ddlAssetItem.SelectedValue,ddlItemIdentification.SelectedValue

 

Now i m showing the record into gridview but i want to show the DataTextField text.

 

Like ddlAssetCat value is 2 but DataTextField is Eletrical .

 

I want to show the Eletrical in gridview

using (SqlCommand cmd = new SqlCommand("SELECT [ComId],[ComplainerName],[ComplainerAddress]," +
" [ComplainerMobile],[ComplaintFor],[BuildingDevelopment],[PlantMachCategory]," +
" [PlantMachSubCategory],[PlantMachItem],[ItemIdentification] "))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = myconn;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GrdComplaintkList.DataSource = dt;
GrdComplaintkList.DataBind();
DataView dv = dt.DefaultView;
GrdComplaintkList.DataSource = dv;
GrdComplaintkList.DataBind();
}
}
}

Please help