Dropdown list value and text issue

ankit gaur

5y857.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi,

You need to change your select query from where you are binding gridview. You are storing dropdown value field to to your table. While gettging values you need to join all master table where you have values.
SELECT [ComId],[ComplainerName],[ComplainerAddress]," +
" [ComplainerMobile],[ComplaintFor],[BuildingDevelopment],[PlantMachCategory]," +
" [PlantMachSubCategory],[PlantMachItem],[ItemIdentification]
SELECT ComId,ComplainerName,ComplainerAddress,
ComplainerMobile,ComplaintFor,BuildingDevelopment,ct.PlantMachCategoryTextFieldName as PlantMachCategory,  sct.PlantMachSubCategoryTextFieldName as
PlantMachSubCategory, pm.PlantMachItemTextFieldName as PlantMachItem, itm.ItemIdentificationTextFieldName as ItemIdentification

From ABC t1
Left JOIN YourCategoryTable ct ON t1.PlantMachCategory= ct.PlantMachCategory
Left JOIN YourSubCategoryTable sct ON t1.PlantMachSubCategory= sct.PlantMachSubCategory
Left Join YourPlantMachItemTable pm ON t1.PlantMachItem = pm.PlantMachItem
Left Join YourItemIdentificationTable itm on t1.ItemIdentification = itm.ItemIdentification
You will get desire result. Just need to replace your column name and table name properly in above query
0
Sachin Singh5y ago
i think in you are saving Id of the following Field into table as these are foreign keys in your table.
1. AssetCat
2. AssetSubCat
3. AssetItem
4. ItemIdentification
So , now you need to join these tables and select the necessary field and then bind that to Gridview like below example
string cmd="select comId,ComplainerName,ComplainerAdress,CategoryName from tblComplaint  com
Join tblCategory ct  on com.Id =ct.ComplaintId
-------
-------
//so on join all tables ,
//better is to make a Store procedure for the same

"


using (SqlCommand cmd = new SqlCommand("spSelect",con){
cmd.CommandType=CommandType.StoredProcedure;
Grid.DataSource = cmd.ExecuteReader();
Grid.DataBind();
}
}
}
+1