forum

home / developersection / forums / search using textbox value and wildcard character

Ask Question

Search using textbox value and wildcard character

Anonymous User 2309 29-Aug-2014

I want to search the empid of a name that with the characters entered in my textbox. using wildcard characters. I wrote the statement

da = new SqlDataAdapter(

 "Select empID from emp where FirstName like ' "+textbox1.text+" ' % "

   , connstring);

da.Fill(ds);

Is this statement correct?

c#
Updated on 01-Sep-2014
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

01-Sep-2014 
string sql = "SELECT empID " +            
"FROM emp " +              
"WHERE FirstName like @FirstName";
using(var con = new SqlConnection(connstring))
using (SqlCommand command = new SqlCommand(sql, con))
{
   
command.Parameters.AddWithValue("@FirstName",  textbox1.text + "%");
    using(var da = new SqlDataAdapter(command))
    {
        da.Fill(ds);
    }
}
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy