Merge Column into one.

Question

User-977579175 posted

I have two colums in database table. I need to both columns in DropDownlist to show to the user but passed value should be one column.

Below is my code:

qry="Select BankCode, BacnkName from MyBanks where UID='"+uid+"'";

adapt=new SqlAdapter(qry,mycoon);

adapt.fill(ds,"MyBanks");

cmbBank.DataSource=ds["MyBanks"];

cmbBank.DataTextField="BankName";//I need both code and name

cmbBank.DataValueField="BnkCode";

cmbBank.DataBind();

Answer 1

User-873890331 posted

Hi,

Miner Change in your Query -

Select BankCode + ' ' + BankName as [FullName] , BankCode, BacnkName from MyBanks where UID='"+uid+"'";

and Now

cmbBank.DataTextField="FullName";

Regards

Shwetamber

Answer 2

User-1011865089 posted

http://stackoverflow.com/questions/7614150/how-to-merge-multiple-dataviews-into-one-vb-net

http://www.developerfusion.com/thread/52060/merge-3-columns-into-1-column-in-gridview/

Answer 3

User-183374066 posted

qry="Select BankCode, BacnkName from MyBanks where UID='"+uid+"'";

change it to

qry="Select BankCode + ' ' + BacnkName as BankDetail from MyBanks where UID='"+uid+"'";

and if your bankcode or bacnkName (is it bacnkName or bankName) isn't char/varchar/nvarchar either use

CAST(ItemId as VARCHAR(50)) as col1

Or

 CONVERT(VARCHAR(50),ItemId) as colI1

suppose your bank code is int than you have to convert it to varchar

qry="Select CAST(BankCode as varchar(100)) + ' ' + BacnkName as BankDetail from MyBanks where UID='"+uid+"'";

Answer 4

User-1635004338 posted

Hi,

Anyone who has the same problem, please refer this thread: http://forums.asp.net/t/1807386.aspx

Thanks,