Last post Jun 14, 2010 05:14 PM by hans_v
Jun 14, 2010 05:07 PM|kimbu|LINK
Sir i have got a problem with acces 2003. i wrote these code with c# :
public partial class Admin : Form
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\Hitman\\Desktop\\Bilet Satış\\Otomation.mdb");
private void button1_Click(object sender, EventArgs e)
string username = textBox1.Text.Trim();
string surname = textBox2.Text.Trim();
string password = textBox3.Text.Trim();
string query = "SELECT * FROM admin WHERE admin_name = '" + username + " AND admin_surname = '" + surname + "' AND password = " + password + "";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = query;
OleDbDataReader da = cmd.ExecuteReader();
Admin_Table admin = new Admin_Table();
but my program gives me this problem : Syntax error (missing operator) in query expression 'admin_name = 'can AND admin_surname = 'kemal' AND password = 1'.
What should i do? Can you help me about this problem?
Jun 14, 2010 05:14 PM|hans_v|LINK
Sir i have got a problem with acces 2003
Next time, don't reopen an old thread but start a new one:
But even better, try to find similar threads, because this is discussed many times!