5 Replies - 905 Views - Last Post: 28 September 2012 - 12:03 PM Rate Topic: -----

#1 digitalbcp  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 23-September 12

SQL Server Management Studio and VB2008

Posted 28 September 2012 - 10:00 AM

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!

Is This A Good Question/Topic? 0
  • +

Replies To: SQL Server Management Studio and VB2008

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9091
  • View blog
  • Posts: 34,144
  • Joined: 12-June 08

Re: SQL Server Management Studio and VB2008

Posted 28 September 2012 - 10:05 AM

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.
Was This Post Helpful? 0
  • +
  • -

#3 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1605
  • View blog
  • Posts: 5,162
  • Joined: 25-September 09

Re: SQL Server Management Studio and VB2008

Posted 28 September 2012 - 11:48 AM

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.
Was This Post Helpful? 0
  • +
  • -

#4 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 448
  • View blog
  • Posts: 3,103
  • Joined: 12-January 10

Re: SQL Server Management Studio and VB2008

Posted 28 September 2012 - 11:53 AM

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
Was This Post Helpful? 0
  • +
  • -

#5 digitalbcp  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 23-September 12

Re: SQL Server Management Studio and VB2008

Posted 28 September 2012 - 11:53 AM

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?
Was This Post Helpful? 0
  • +
  • -

#6 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1605
  • View blog
  • Posts: 5,162
  • Joined: 25-September 09

Re: SQL Server Management Studio and VB2008

Posted 28 September 2012 - 12:03 PM

Should be fine.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1