[RESOLVED] talking to access

[ubernoob]

Ok I am very new to vb.net and visual studio in general. I have an access database set up and would like to use that database with my vb.net windows application.

I clicked on the data section of vs and now have a list of choices. Obviously oracle is not the one I want to use but there are several others. Which tool do I need to use to connect to the access db on my server and which tool do I need to use to run quieries?

tia

[jmcilhinney]

You would use OleDb to interact with Access. Here is an example of using OleDb with the OLEDB Provider for Oracle. All you have to do is change the OLEDB Provider to use essentially the same code for Access. You do this via the ConnectionString of your OleDbConnection object. Visit www.connectionstrings.com for the appropriate value to use for Access.

[Mark Gambo]

Same site as the one jmcilhinney posted but here is an example using Access: Data Access using MSAccess

[jmcilhinney]

Same site as the one jmcilhinney posted but here is an example using Access: Data Access using MSAccess

Can you believe it? That's what I was looking for when I went to that site but I didn't see it. I think the clever disguise of putting "MS" in front of "Access" is what threw me. C'mon, anyone would have been fooled!

[Mark Gambo]

Can you believe it? That's what I was looking for when I went to that site but I didn't see it. I think the clever disguise of putting "MS" in front of "Access" is what threw me. C'mon, anyone would have been fooled!

and just think, I use to look up at you, oh well another icon bites the dust

[ubernoob]

OK so I created the connection and am now attempting to load the command.

dbQuery = New OleDbCommand("select * from drinks where drinks.drinkname like " + txtInput.Text + "%")

dbQuery is my oledbcommand that I draged and dropped on my form.

The underlined part is giving me a blue squiggle.

Is it possable to change the command text depending on the event driven procedures chosen by the client?

What is my issue here?

tia

[gigemboy]

Well you should use "&" instead of "+" when concatenating strings, don't think that will solve your problem, but what error is it showing????? Error messages are important

[jmcilhinney]

You have to either import the System.Data.OleDb namespace at the top of the file, or else qualify the class name with the namespace:

dbQuery = New OleDb.OleDbCommand("select * from drinks where drinks.drinkname like [B][U]'[/U][/B]" [U]&[/U] txtInput.Text [U]&[/U] "%[B][U]'[/U][/B]")

Note that only the OleDb is necessary as all WinForms applications already have a project wide import of the System.Data namespace.

Two other things to note. I have replaced your addition operators with the proper string concatenation operators. "+" will work sometimes but not others so it is best avoided altogether so that you don't make mistakes. Also, strings in SQL code are enclosed in single quotes, which I have added.

[ubernoob]

\Bar Tender\Form1.vb(798): Type 'OleDbCommand' is not defined.
is the error message

thanks for the note on the & and +. Originally I was using a "." (php) and it was giving me an eroor. There are just way to many different concat operators ;(

and jmcilhinney that fixed the problem. thanks alot.