I have developed a windows form application. In this, I created a search history option to search history of records.
The database having these followings fields :
and some others fields are there.
I created one textBox and two comboBox to get Values from user. And two buttons for search and clear respectively.Following are conditions:
- If user enters in those three textboxes , it should display records which contain only those keywords.(i.e. record should statisfies all five keyword)
2.If user enters only one or two values, it should display values which contain only those keywords(i.e records should statisfies those entered keywords.if any record didn statisfies all entered keywords means it must not been displayed).
i have given code as below:
da=new oledbDataAdapter("Select * from total where Pgma='"+TextBox1.Text+"' or type ='"+combox1.text"' or mname='"+Combobox2.Text+"'",con);
Please provide a solution for my issue on searching techniques.