Monday 15 March 2010

c# - Getting a mysterious FROM clause syntax error -



c# - Getting a mysterious FROM clause syntax error -

i'm trying label display how many entries exist in database. , i'm using ridiculously simple can imagine. , i'm getting spammed "syntax error in clause" rather having label update. syntax error lot when utilize scheme reserved name table or column. table name i'm using works in other statements, assume that's not issue, , it's variable. unless it's other , it's lying me, exclusively possible...

if (datetime.now.millisecond > 500) { seek { oledbconnection conn = new oledbconnection(); conn.connectionstring = @"provider=microsoft.jet.oledb.4.0; info source=access.mdb"; conn.open(); oledbcommand cmmd = new oledbcommand("select * probe)", conn); using (oledbdatareader myreader = cmmd.executereader()) { datatable dt = new datatable(); dt.load(myreader); int count = dt.rows.count; lblcount.text = count.tostring(); conn.close(); } } grab (oledbexception expe) { messagebox.show(expe.message); } } }

select * probe)

should

select * probe

?

c# database visual-studio ms-access

No comments:

Post a Comment