how to search name like firstname and lastname

Bhavesh Vankar

5y2.3k

how to search name if name is stored in database in single column as full name. and if i want to search name like first name and last name and also entering firstname first character and middle name first character and lastname as a surname in three texboxes.

suppose.

i have three textboxes.

Textbox1 as FirstName , Textbox2 as MiddleName, Textbox3 as LastName

1) if i enter Firstname and lastname in textbox and name found in record than name should be display on label.

2) if i enter firstname first character middle name first character and enter surname in lastname than also should be display name on label.

3) if i enter onle firstname and lastname in textboxes than aslo should be display name on label

how to make this in c# web application.....

Note :- The name stored in table as fullname in single column..

6 Replies

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

Sachin Singh5y ago
first test in sql server with static first name, middle name and Last name. if it works there for all your 3 cases then it should work in code as well.

Bhavesh Vankar5y ago

("Select NAME,ADDRESS,CITYORVILLAGE,TALUKA,DISTRICT,CONTACTNO from RESTICTIED_STUDENTS Where (NAME Like 'FirstName%' and NAME like 'LastName%') or(NAME like'%MidNameChar%' and NAME like '%LastNameChar%' and NAME like 'LastName%')", con);

i use this query but its not working and not showing me any result...

Sachin Singh5y ago
bracket is missing in your code
string firstName = txtfname.Text;
      string MidName = txtmname.Text;
      string LastName = txtlname.Text;
      string FirstNameChar = firstName[0].ToString();
      string MidNameChar = MidName[0].ToString();

qlCommand cmd = new SqlCommand(" select NAME,ADDRESS,CITYORVILLAGE,TALUKA,DISTRICT,CONTACTNO from RESTICTIED_STUDENTS Where (NAME Like 'FirstName%' and NAME like 'LastName%') or(NAME like'%MidNameChar%' and NAME like '%LastNameChar%' and NAME like 'LastName%')",con2);
Bhavesh Vankar5y ago
it showing me error..

i have used your code as below...
     string firstName = txtfname.Text;
       string MidName = txtmname.Text;
       string LastName = txtlname.Text;
       string FirstNameChar = firstName[0].ToString();
       string MidNameChar = MidName[0].ToString();

SqlCommand cmd = new SqlCommand(" select NAME,ADDRESS,CITYORVILLAGE,TALUKA,DISTRICT,CONTACTNO from RESTICTIED_STUDENTS Where (NAME Like 'FirstName%' and NAME like 'LastName%') or(NAME like'%MidNameChar%' and NAME like '%LastNameChar%' and NAME like 'LastName%'",con2);

ERROR IS BELOW
System.Data.SqlClient.SqlException: Incorrect syntax near 'LastName%'.
Sachin Singh5y ago
yes, considering that only I answered.
Sachin Singh5y ago
test this
string firstName= TextBox1.Text;
string MidName= TextBox1.Text;
string LastName= TextBox1.Text;
string FirstNameChar= firstName[0];
string MidNameChar= MidName[0];
select Name from table where (Name like 'FirstName%' and Name like 'LastName%') or (Name like'%MidNameChar%' and Name like '%LastNameChar%' and Name like 'LastName%')
// prepare command
lblName.Text= Cmd.ExecuteScalar();