how to display full name into multiple textbox

Question

my name stored as full name into single column like Yogesh B Solanki in table i want to display this name in textbox like fname, mname lname. how to do this. ? in fname textbox should be display name only Yogesh in mname textbox should be display name only B in lname textbox should be display name only Solanki

Sachin Singh · Answer

yes, use the split method and split with space. var FullName= rdr[ "Name" ].ToString().split( ' ' ); txtFirtsName.Text= FullName[0]; txtMiddlename.Text=FullName[1]; txtLastName.Text=FullName[2];

Bhavesh Vankar · Answer

i have used below query to split name in sql server now how to implement it in c# code behind to fetch record from sql server using three textbox. Select Ltrim( SubString ( NAME ,1, Isnull ( Nullif (CHARINDEX( ' ' , Name ),0),1000))) As FirstName, Ltrim( SUBSTRING ( Name ,CharIndex( ' ' , Name ), CAse When (CHARINDEX( ' ' , Name ,CHARINDEX( ' ' , Name )+1)-CHARINDEX( ' ' , Name )) then 0 else CHARINDEX( ' ' , Name ,CHARINDEX( ' ' , Name )+1)-CHARINDEX( ' ' , Name ) end )) as MiddleName, Ltrim( SUBSTRING ( Name , Isnull ( Nullif (CHARINDEX( ' ' , Name ,Charindex( ' ' , Name )+1),0),CHARINDEX( ' ' , Name )), Case when Charindex( ' ' , Name )=0 then 0 else LEN( Name ) end )) as LastName From UserRecord

Bhavesh Vankar · Answer

its not working. which another way can use to do this. in sql query...

Vinay Singh · Answer

Hi Try the code. //Suppose you are fatching your data into datatable named as "dt" var fullName= dt.Rows[0][ "Name" ].ToString().split( '' ); txtFirtsName.Text= fullName[0]; txtMiddlename.Text=fullName[1]; txtLastName.Text=fullName[2];

Bhavesh Vankar · Answer

its not working when i press and lost focum from last name textbox popup window not open. but when i use response.redirect its working. for single textbox. name not fetch by three textbox.

Sachin Singh · Answer

test this con.Open(); SqlCommand cmd = new SqlCommand( "Select * from UserRecord Where NAME='" + txtfname.Text + "" + txtmname.Text + "" + txtlname.Text + "'" ,con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); int i = ds.Tables[0].Rows.Count; if (i > 0) { string url = "Userdetails.aspx" ; string s = "window.open('" + url + "')" ; ClientScript.RegisterStartupScript( this .GetType(), "newwin" , s, true ); }

Bhavesh Vankar · Answer

can we use it like sql query. i have used like as below... actualy i want to find out existing use or not. if user is exist in table or record then popup page should be display with user's details... Select * from TableName Where NAME = '" + txtfname.Text +""+ txtmname.Text +""+ txtlname.Text + "' " i have use below code to do this... code working fine but in table name in only single column and in form there are three textboxes like fname mname and lname. only single textbox can find existing user when user find then popup page not open. kindly see the below code and help to solve this. con.Open(); SqlCommand cmd = new SqlCommand( "Select * from UserRecord Where NAME='" + txtfname.Text + "" + txtmname.Text + "" + txtlname.Text + "'" ,con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); int i = ds.Tables[0].Rows.Count; if (i > 0) { // Response.Redirect("Userdetails.aspx"); string url = "Userdetails.aspx" ; string s = "window.open('" + url + "', 'popup_window', 'width=450,height=620,left=450,top=50,resizable=no');" ; ClientScript.RegisterStartupScript( this .GetType(), "script" , s, true ); }

Arnab Mukherjee · Answer

Try the code snippet given below, string Name = "Yogesh B Solanki" ; var ObjName = Name.Split( ' ' ); txtfname.Text=Convert.ToString(ObjName[0]); txtmname.Text= Convert.ToString(ObjName[1]); txtlname.Text= Convert.ToString(ObjName[2]);

Pranam Bhat · Answer

string fullName = "Yogesh B Solanki "; var names = fullName.Split(' '); string fname= names[0]; string mname= names[1]; string lname= names[2];