retriving 3 columns data frm sql in 1 textbox

anurag guhe

Hello,
[1] I have created one data report(student report).
[2] which shows records of students as per the fields selected from various combos situated at form2 for that I wrote a record set (bunch of sql statements) fired on command_click and it works well.....
[3] Now I am having fields like: FIRST_NAME,MIDDLE_NAME,LAST_NAME in database table
[4] For that I have to take one TextBox as FULLNAME which is not included in table but I have to concatenate these 3 fields to view FULLNAME......
[5] I don't know how to do so.......

5 Replies

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

Vinay Singh10y ago
Use sql query or concitnate the name value. have a look
SQL:
select FIRST_NAME+ ' '+ MIDDLE_NAME + ' ' +LAST_NAME as fullname from table
C#: Here dt is datatable object.
string fullname=dt.Rows[0]["FIRST_NAME"].ToString()+" "+dt.Rows[0][" MIDDLE_NAME"].ToString()+" "+
dt.Rows[0]["LAST_NAME"].ToString();
TextBox1.Text=fullname;
0
Hima Bindu10y ago
If you need only one space please remove the concatenations in Rajeesh Code
For ex: SELECTFIRST_NAME +MIDDLE_NAME +''+ LAST_NAMEAsFULLNAMEFROMTable_Name
0
ketan borsdiya10y ago
Hi Anurag,
You may also use in c# before assign value to textbox.
string.Format("{0} {1} {2}",firstName,middleName,lastName);
0
anurag guhe10y ago
first of all thanks to u rajesh its working sucessfully bt maintaing to much space between first_name,middle_name,last_name bt i want only one space between that concatination...so can u solve my this problem
0
Rajeesh Menoth10y ago
Hi,
Try this Sql code to concatenate FIRST_NAME,MIDDLE_NAME,LAST_NAME as fullname.

Sql Code :
SELECT FIRST_NAME +''+ MIDDLE_NAME +''+ LAST_NAME As FULLNAME FROM Table_Name
Reference :
http://www.sqlbook.com/SQL/SQL-CONCATENATE-24.aspx

http://www.webcodeexpert.com/2015/03/how-to-join-firstmiddle-and-last-name.html
0