Is there anyone know how to use LIKE statement?
Try this code.
private void button1_Click(object sender, EventArgs e)
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Northwind.mdb");
String sqlText = "SELECT * FROM Customers WHERE CompanyName LIKE '%" + textBox1.Text + "%'";
OleDbDataAdapter adapter = new OleDbDataAdapter(sqlText, conn);
DataTable dtCust = new DataTable();
dataGridView1.DataSource = dtCust;
Also refer this link.
Microsoft Office Access 2007 - Like Operator
sorry..i'm new in c#..i got this error..
Line 27: OleDbDataAdapter adapter = new OleDbDataAdapter(sqlText, conn);
Line 28: DataTable dtCust = new DataTable();
Line 29: adapter.Fill(dnis);
Line 30: conn.Close();
Line 31: dataGridView1.DataSource = dnis;
While I'm just trying to pull up data from the db, as soon as the page shows up with the data it is already sending an email. How can I ...
i want to print a persian file by thermal printer..
i can print an english file esily..but i face the proble while printing persian text..
i think i ...
I had created a function updateprintingqc() that work like this