How to Fetch and Display record in textboxes

Bhavesh Vankar

How can i find and display full name from single column in sql server and display full name as First name, middle name and last name in textboes in c#?

6 Replies

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

Laxmidhar Sahoo6y ago
Accepted answer
Hi

Collect the database column value in a string variable and split by a space ,
Then it convert i into array and by the index can get the firstname ,second name and lasst name
var colval = " Bhaveshkumar Amrutbhai Parmar ";
            var names = colval.Split(' ');
            var fn = names[0];
            var mn = names[1];
            var ln = names[2];
Thanks and regards
+3
Shahzad Muhammad6y ago
Hi Try This :

NOTE: Run queries together. Every name in table should contain (first_name middle_name last_name) formats
if any name have only f_name and L_name it will not work.

Drop Table #a; -- Delete temp Table if exist

Select SUBSTRING(FULL_NAME,1,CHARINDEX(' ',FULL_NAME)-1) First_Name,
SUBSTRING(FULL_NAME,CharIndex(' ',FULL_NAME)+1,LEN(FULL_NAME)-CHARINDEX(' ',FULL_NAME)) Rest_Name into #a from Your_Table; --Split Full Name and create a temp table

Select First_Name, SUBSTRING(Rest_Name,1,CHARINDEX(' ',Rest_Name)-1) Middle_Name, SUBSTRING(Rest_Name,CHARINDEX(' ',Rest_Name)+1,Len(Rest_Name)-CHARINDEX(' ',Rest_Name)) Last_Name from #a

+2
Bhavesh Vankar6y ago
its working thanks a lot sir....
+2
Bhavesh Vankar6y ago
this is not working in my c# project please kindle help me to implement in c# web base project
+2
Bhavesh Vankar6y ago
i have stored full name in sql server like Bhaveshkumar Amrutbhai Parmar and i want to display that full name in three textboxes like First Name Middle Name and Last Name on page using c#. when i double click on each record from listbox.
+2
Laxmidhar Sahoo6y ago
Hi

What is the pattern of storing data in the single column of sql

Thanks and regards
+2