CODEWITHSUNDEEP
c#ms-accessc#-2.0
New Coder
New Coder

Reputation: 501

Search record in ACCESS DATABASE using c#

i am trying to find the records based on the user input in msaccess database. below is the code 

string strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Employees.mdb";
string strSql = "SELECT * FROM tbl_employees where description like '" + txtsearch.Text.ToString() + "*'";

OleDbConnection con = new OleDbConnection(strProvider);
OleDbCommand cmd = new OleDbCommand(strSql, con);
con.Open();
cmd.CommandType = CommandType.Text;
OleDbDataReader dr = cmd.ExecuteReader();
int columnCount = dr.FieldCount;

When i ran the same query in my SQLView of msaccess i am getting records but when i ran it in VS i am not getting any records.

Upvotes: 3

Views: 11908

Answers (1)

DonBoitnott
DonBoitnott

Reputation: 11035

I think your matching should be changed:

String strSql = "SELECT * FROM tbl_employees WHERE description LIKE '" + txtsearch.Text.ToString() + "%'";

//Replaced * with %

Upvotes: 5

Related Questions