how to display full name into multiple textbox

Bhavesh Vankar

5y952

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

9 Replies

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

Bhavesh Vankar5y ago
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))<=0 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
+1
Bhavesh Vankar5y ago
its not working.
which another way can use to do this. in sql query...
+1
Vinay Singh5y ago
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];
+1
Bhavesh Vankar5y ago
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.
+1
Sachin Singh5y ago
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);
            }
0
Bhavesh Vankar5y ago
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);
            }
+1
Arnab Mukherjee5y ago
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]);
0
Sachin Singh5y ago
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];
+1
Pranam Bhat5y ago
string fullName = "Yogesh B Solanki ";
var names = fullName.Split(' ');
string fname= names[0];
string mname= names[1];
string lname= names[2];
+1