How to Fetch and Display record in textboxes

Question

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#?

Laxmidhar Sahoo · 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

Shahzad Muhammad · Answer

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

Bhavesh Vankar · Answer

its working thanks a lot sir....

Bhavesh Vankar · Answer

this is not working in my c# project please kindle help me to implement in c# web base project

Bhavesh Vankar · Answer

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.

Laxmidhar Sahoo · Answer

Hi What is the pattern of storing data in the single column of sql Thanks and regards