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;
Hello, I can't display images from database.
I have folder called "images" next to index.php where I keep images.
I suppose I have wrongly defined folder path with images or ...
I recently inherited a project that has been in production for a number of years. They want a new field added. Easy peasy - or so you would ...
i am creating an app with android studio and i'm using mySQL.and i want to implement friends feature in my app to enable users send and recieve friend requests, i ...