
	Home > Ask the SQL Server Experts > Andrew Novick - Development Questions & Answers > Connecting Visual Basic to SQL Server

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

Connecting Visual Basic to SQL Server

EXPERT RESPONSE FROM: Andrew Novick

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database administration

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 02 September 2005
How do I connect Visual Basic to SQL Server? (Visual Basic front end and SQL back end.) I am doing a project in Visual Basic working in networks. Many client systems must access data at one time.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	.NET Development for SQL Server
	Creating Windows PowerShell scripts to manage SQL Server 2008 instances
	Manipulate column names in a SQL Server table
	Code to restore SQL Server databases in VB.NET
	Custom VB.Net scripting in SQL Server Integration Services
	Retrieve images from SQL Server and store in VB.Net
	Connect to SQL Server database with Visual Basics
	Top 10 SQL Server development questions
	Developing CLR database objects: 10 tips, 10 minutes
	CLR architecture
	CLR stored procedures
	.NET Development for SQL Server Research

Andrew Novick - Development

Nullable fields in a table

Stored procedures in Crystal Reports

Storing an image file in SQL Server

Storing large amounts of data as ntext data type

Stored procedures looking at different databases

Code trigger that captures login and system date

Stored procedures and remote procedure calls

Using newid in SQL Server to insert records in parent-child tables

How to use results from one stored procedure in another

How to display the XML result of 'Select For XML Explicit'

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

The connection between Visual Basic and SQL Server is made using one of several interface APIs. The APIs you should consider depends on which version of Visual Basic you're using. For Visual Basic.Net, use ADO.Net. For Visual Basic 6 use ADO.

Do you have comments on this Ask the Expert Q&A? Let us know.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy