how to make a simple SQL query from VB.net (access db)

Question

I have a working dataset and datagrid already in my project, but I want to make my own quicksearch button. The following code gives error for connectionstring PROVIDER KEYWORD NOT SUPPORTED

connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\prod.mdb"

sql = "Select (*) from table1 where prodid=" + searchfield.Text

cnn = New SqlConnection(connetionString)
Try
    cnn.Open()
    cmd = New SqlCommand(sql, cnn)
    Dim ret = (cmd.ExecuteScalar())
    cmd.Dispose()
    cnn.Close()
    Text = ret

Shouldn't you be using OleDbConnection instead of SQLConnection ? SQLConnection is for SQLServer — no_one
– no_one, Commented Jun 2, 2009 at 7:47

no_one · Accepted Answer · 2009-06-02 08:57:41Z

4

Are you trying to just search for a particular value in field or asking for a full blown query designer?

If it is the first one, should be relatively easy, you can either select the rows directly in the datagrid or fire a paramaterized query to get the result.

If it is the second, things are slightly more complicated. You might have to use a third party component.

As requested :-)

You are using wrong Connection. You should be using OleDbConnection class. I hate to nitpick, but you are generating SQL Statements on the fly by String concatenation which leaves you open to SQL Injection attacks

edited Jun 2, 2009 at 8:57

answered Jun 2, 2009 at 6:28

no_one

1,84012 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tom Over a year ago

I was more looking for info how to make a sql query like: data.executeSql("select xxxx where a="+mykey)

no_one Over a year ago

You are using wrong Connection. You should be using OleDbConnection class. I hate to nitpick, but you are generating SQL Statements on the fly by String concatenation which leaves you open to SQL Injection attacks.

Adam Ralph Over a year ago

@no_one if you put that last comment into your answer I'll vote it up

Tom · Accepted Answer · 2009-06-02 07:14:15Z

0

its better to use

dataset.table.select("a=b")

answered Jun 2, 2009 at 7:14

Tom

6,77125 gold badges99 silver badges167 bronze badges

Collectives™ on Stack Overflow

how to make a simple SQL query from VB.net (access db)

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related