[digitalbcp]

First off Im not sure if this is the correct forum to be posting questions about Visual Basic 2008. However if this is the correct forum then ill continue...

Im developing a commercial program that involves heavily around large amounts of pricing cells. These prices are associated with other cells that narrow down to a specific product/price. I was hired on for this job as an internship opportunity however, we never got that deep into databases in my VB classes.

I have discovered that an SQL database is the best route to go since I will be able to perform search quires however I don't know how to implement the database I constructed into Visual Basic. The main questions I need help answering are as follows:

1) How to import a SSMS database into Visual Basic
2) How to perform search queries in Visual Basic to call upon a specific cell
3) How to transfer a constructed database to another computer using SSMS or how to import the database directly into Visual Basic and be able to edit the data directly in VB.

Any information or a link to tutorials would be greatly appreciated! Thank you so much for your time!

[modi123_1]

Moving from vb6 to vB.NET.

FYI - typically you would reference which version of the .NET framework you are using and not the year off the Visual Studios IDE.

[CharlieMay]

This might help you get started, it's a series on a method of database access with visual basic .net.

At the very least, it should answer most, if not all of your questions.

[DarenR]

i would think for this application you would want sql server and not have the database inserted into the vb app. The sql server would allow you to use the app in mulitple locations without pinning it to one machine.

but that is just a start

[digitalbcp]

This looks perfect! I will have to spend some time looking through it and hopefully will lead me on the right path. The first thing I did notice, however, was that it involves SSMS 2005 and VB 2005. Both of the ones I am using are the 2008 version. Do you know if that will that pose any crucial road blocks?

[CharlieMay]

Should be fine.