retriving 3 columns data frm sql in 1 textbox

Question

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_NAMEMIDDLE_NAMELAST_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.......

Vinay Singh · Answer

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;

Hima Bindu · Answer

If you need only one space please remove the concatenations in Rajeesh Code For ex: SELECT FIRST_NAME + MIDDLE_NAME + '' + LAST_NAME As FULLNAME FROM Table_Name

ketan borsdiya · Answer

Hi Anurag You may also use in c# before assign value to textbox. string.Format({0} {1} {2}firstNamemiddleNamelastName);

anurag guhe · Answer

first of all thanks to u rajesh its working sucessfully bt maintaing to much space between first_namemiddle_namelast_name bt i want only one space between that concatination...so can u solve my this problem

Rajeesh Menoth · Answer

Hi Try this Sql code to concatenate FIRST_NAMEMIDDLE_NAMELAST_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