Need help with from clause

Hello, I have an mdb database and I'm trying to check if some records exist, using a function. The code below is giving me syntax error in FROM clause.

Code:

---

Dim dbStr As String = "SELECT * FROM ? WHERE ? = ?"
Command = New OleDbCommand(dbStr, Connection)

Command.Parameters.AddWithValue("@table", t)
Command.Parameters.AddWithValue("@column", c)
Command.Parameters.AddWithValue("@value", v)

---

I want to learn if something is wrong with this code.

It doesn't appear that you can use a table name as a parameter like any other. Here's a lengthy discussion that you might find useful:

http://www.sommarskog.se/dynamic_sql.html

You might want to learn SQL and ADO.NET before trying to use it

Ok, I see. Thanks a lot.

this would work though:

Code:

---

Dim dbStr As String = string.format("SELECT * FROM {0} WHERE {1} = ?", t, c)
Command = New OleDbCommand(dbStr, Connection)

Command.Parameters.AddWithValue("@value", v)

---

Not only would that work, it is probably the better answer.