How does Visual Basic work with SQL Server?

Question

I am wondering how Visual Basic works with SQL Server. I know very little about both programs, other then SQL is a relational database. I mostly know PC hardware, Windows (including server 2003/2008) and a bit of networks. Would any one be able to explain the two programs and how they work together?

Answer 1

Visual Basic is an tool for creating applications which usually include GUI widgets for communication with the user (hence, the 'visual' part). The current incarnation is part of the .NET framework, which has a huge amount of premade classes available for use to do various tasks. SQL Server is a database management application that (like most relational DBMSs) uses SQL as its query language. The two applications can work together if VB creates a connection to SQL Server and passes it database requests, receiving recordset objects in response. Take a look here for more info: http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp (this is discussing connecting to Access, but SQL Server would work much the same way.)

Answer 2

visual basic is a programming language and sql server is a database sql is a database language. most programming languages have classes or libraries specifically designed to communicate through sql to an sql database. just find that particular function by doing a Google search and add it into your script. connect to the database submit the queries when you need to and the program will communicate back and forth with the database as needed.

Answer 3

http://www.codeproject.com/KB/books/ASPNETIllustrated.aspx



http://www.codeproject.com/KB/database/dbhelper.aspx - here is a downloadable exemple to connect to database, or run a query, storedproc etc on it.



But first i reccomend to study the theory of databases.