How do we connect to sql server ?, DOT NET Programming

How do we connect to SQL SERVER, which namespace do we use ?

The code is shown below, after that i will  give the explanation for it. For this sample we will also require a SQL Table setup which I have imported using the DTS wizard.

Private Sub LoadData()

' note :- with and end with makes your code more readable

Dim strConnectionString As String

Dim objConnection As New SqlConnection

Dim objCommand As New SqlCommand Dim objReader As SqlDataReader Try

file.

' this gets the connectionstring from the app.config

' note if this gives error see where the MDB file is

stored in your pc and point to that strConnectionString =

AppSettings.Item("ConnectionString")

' take the connectiostring and initialize the connection

object

Employees")

With objConnection

.ConnectionString = strConnectionString

.Open() End With

objCommand = New SqlCommand("Select FirstName from

With objCommand

.Connection = objConnection objReader = .ExecuteReader()

End With

' looping through the reader to fill the list box

Do While objReader.Read()

lstData.Items.Add(objReader.Item("FirstName")) Loop

Catch ex As Exception

Throw ex

Finally objConnection.Close()

End Try

ID=sa;Database=Employees"/>

For setting up the sample of the SQL table we can use the DTS import wizard to import the table. See the figure below which is using a data source as Microsoft Access.While importing the database author had provide the database name as "Employees".

1685_SQL server.png

Figure:- Loading "Nwind.mdb" in SQL SERVER for the sample

416_SQL server1.png

Figure :- Load only the Employee table

To make it easy we will only import the employee table as that is the only thing required in our sample code.

459_SQL server2.png

Figure :- View of loaded Employee table

Now from the interview point of view definitely you are not going to say the whole source code. The Interviewer expects only the wide answer of what are the steps required to connect to SQL SERVER. For fundamental the whole source code is explained below. In brief you have to describe the "LoadData" method in a broaderway. The steps to connect to SQL SERVER are shown below:-

1)The very First step is to import the namespace "System.Data.SqlClient".

2)The second step is to Create a connection object as shown in "LoadData" method.

With objConnection

.ConnectionString = strConnectionString

.Open() End With

3)The third step is to Create the command object with the SQL. Also assign the created connection object to the command object & execute the reader.

objCommand = New SqlCommand("Select FirstName from Employees") With objCommand

.Connection = objConnection objReader = .ExecuteReader()

            End With

4)Finally loop through the reader & fill the list box. If old VB programmers are expecting the movenext command it is replaced by Read() which returns true if there is any data to be read. If the .Read() return's false which  means that it is the end of datareader and there is no more data to be read.

Do While objReader.Read() lstData.Items.Add(objReader.Item("FirstName")) Loop

5) Do not  neglect  to close the connection object.

Posted Date: 9/24/2012 2:36:42 AM | Location : United States







Related Discussions:- How do we connect to sql server ?, Assignment Help, Ask Question on How do we connect to sql server ?, Get Answer, Expert's Help, How do we connect to sql server ? Discussions

Write discussion on How do we connect to sql server ?
Your posts are moderated
Related Questions
What is a parameter? Explain the new types of parameters introduced in C# 4.0. A parameter is a special type of variable, which is used in a function to give a piece of informa

What are the steps involved to fill a dataset ? The sample code is shown below: Private Sub LoadData() Dim strConnectionString As String strConnectionString = AppSetti

Training and placement cell Project Description: It is about placement and training cell of any college. I have made this for one college. If needed, i can modify it. Student

What is a delegate? A delegate is similar to a class that is used for storing the reference to a method and invoking that method at runtime, as needed. A delegate can hold the

Finding Maximum & Minimum Numbers - C# Program I am facing some problems in the code for Finding Maximum & Minimum Numbers. Can anybody suggest me the proper code for it.

What are the main components of .NET Framework? .NET Framework gives enormous benefits to software developers in comparison to the advantages given by other platforms. Microsof

Inventory billing and Management application in .net Project Description: Digital Inventory management Main Features         Multi user User friendly windows based s

Find out the Factorial - C# Program I've been trying so many codes for this but those codes didn't work well. Please write the code for find out the factorial of an integer nu

I need to develop a new website. Previous site was not good and I need better one with not only static but using also more details . Skills required: .NET, MySQL, C# Programm

Project Description: Simple task and requirements to be done professionally. Propose an Object Oriented design and show drawback. .NET, C Programming, Business Analysis, P