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

Assignment Help:

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.


Related Discussions:- How do we connect to sql server ?

Checking for validity of an expression - c# program, Checking for validity ...

Checking for validity of an expression - C# Program Hello can you please provide me some examples regarding to the Checking for validity of an   expression in C#.

Describe the rules creating a well-formed xml document, Describe the rules ...

Describe the rules and regulations that must be followed whereas creating a well-formed XML document. The following are the rules and regulations that are essential to follow w

Development of app using windows phone sdk, Windows Phone 8 Player - Radio ...

Windows Phone 8 Player - Radio Live Streaming Native XAML and C# Project Description: Player for Windows Phone 8 Scope: The project evolves the development of app using

Readerwriter locks, What is ReaderWriter Locks? You may want to lock th...

What is ReaderWriter Locks? You may want to lock the resource only whenever data is being written and permit multiple clients to parallel read data when data is not being updat

We need of an expert web developer, Web Developer Project Description: ...

Web Developer Project Description: We need of an expert web developer for long term association, please apply with models if you have the subsequent skills: ASP.NET MVC 3

Difference between asp and asp.net, How would ASP and ASP.NET apps run at t...

How would ASP and ASP.NET apps run at the same time on the same server? Both ASP and ASP.net can be run at similar server, becuase IIS has the capability to respond/serve both

Package forwarding website design and develop, Project Description: We w...

Project Description: We want to prepare a package forwarding website. Package forwarding refers to a service where US forwarder provides International shoppers with a US address

Console application, Write a C# program (C# console application) that plays...

Write a C# program (C# console application) that plays a word game with the user. The program should ask the user to enter the following: • His or her name • His or her age

How to prevent .net dll to be decompiled?, Prevent .NET DLL to be decompile...

Prevent .NET DLL to be decompiled By design phase .NET embeds rich Metadata inside the executable code using the MSIL. Anyone can easily  decompile DLL back using tools such as

Differentiate between boxing and unboxing, Differentiate between Boxing and...

Differentiate between Boxing and Unboxing. When a value type is changed to an object type, the process is known as boxing; while, when an object type is changed to a value type

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd