dropdown list

[ptvce]

i have one dropdown list and i bind it but: i want the content of dropdown list be Id and name like: 1203/Frank can u help me???????

[enjoycrack]

Hi there, You can change your datasource before binding it to ddl, you might have to change the SQL query to something like "select id+'/'+name...." Anyway you should check the query again as I'm not sure if it's correct or not :laugh: << >>

[ptvce]

hi thats not right i did that in asp.net(c#). what should i write in this code insted of * dropdownlist.datatextfield = "*";

[enjoycrack]

hi I dont know about this solution, but IMO if selecting datatextfield="*", that means all fields will be shown in ddl, right? if so, what is the delimeter between these fields? Re. my suggestion, I think it's also correct as you just select 2 fields (id and name) and combine these into one field as your format, then just bind the combined field to ddl (SQL: select id+'/'+name as combinedfield....) << >>

[VaibhavJ]

Hi, I think u can do it in Asp.NET and also in the SQL query. I just tried the same. Here it is... SELECT ct.intUSCityId, ct.strUSCityName,CAST(ct.intUSCityId AS VARCHAR(50)) + '/' + ct.strUSCityName AS Vaib ,ct.isDeleted FROM tbCity AS ct WHERE ct.intUSCountyId=10 To bind it to the dropdownlist DropdownList.DataTextField = "Vaib"; DropdownList.DataValueField = "intUSCityId"; The other one ofcourse by concatenating ID+ "/" + "Name" in Asp.NET It's working fairly well. So, I think u can use any of these methods Thanks for reading, Vaibhav :)

[VaibhavJ]

Hi, I think u must be returning a DataSet to bind it to the dropdown containing "ID" and "Name"...You can do following to display "ID/Name" to DropdownList where ID & Name are column names u return through ur query. if(ds!=null && ds.Tables.Count > 0) { if( ds.Tables[0].Rows.Count > 0) { ds.Tables[0].Columns.Add("strDisplay",typeof(System.String)); for(int i = 0 ; i < ds.Tables[0].Rows.Count;i++) { ds.Tables[0].Rows[i]["strDisplay"] = ds.Tables[0].Rows[i]["ID"] +"/" + ds.Tables[0].Rows[i]["Name"] ; } } } And to bind the dropdownlist DropdownList.DataTextField = "strDisplay"; DropdownList.DataValueField = "Value"; I think this should work fine... Thank u, Vaibhav

[enjoycrack]

yes sure it should work, but to be more efficient you can do this from SQL query....No need to load data into dataset and loop over all records in dataset to create the third column :cool::cool: << >>

[VaibhavJ]

ya..That's a useful advice... Thanks a lot..:-D

[RSArockiam]

You can use expression column in datatable. In this method, no need to loop through all the records. Regards R.Arockiapathinathan

[VaibhavJ]

Thanks a lot.. I tried this one and it's really very good solution. Thanks a lot for the help. Thanks & regards, Vaibhav :)

[ptvce]

thanks for your help yes thats right.:rose: