How do you connect your VB.NET application to SQL Server?

Public sub Form_Load()
Dim sampleConnection As New SqlConnection
Dim sampleCommand As New SqlCommand
Dim sampleReader As SqlDataReader
Try
sampleConnection.ConnectionString = AppSettings.Item(“SampleConnString”)
sampleConnection.Open()
sampleCommand = New SqlCommand(“Select rollNo from Students”)
sampleCommand.Connection = sampleConnection
sampleReader = sampleCommand.ExecuteReader()
Do While sampleReader.Read()
lstRollNo.Items.Add(sampleReader.Item(“rollNo”))
Loop
Catch sampleEx As Exception
Throw sampleEx
Finally
sampleConnection.Close()
End Try
<appSettings>
<add key=” SampleConnString” value=”Server=sampleSQLServer;UserID=scott; Database=Students”/>
</appSettings>
End Sub

In this example, you create a sampleConnection by defining its ConnectionString attribute. You then open the connection by calling Open() method of sampleConnection. Now you can use this connection in your command and finally you have to call close() of the connection.

_______________________________________________________________________

FREE Subscription

Subscribe to our mailing list and receive new articles
through email. Keep yourself updated with latest
developments in the industry.

Name:
Email:

Note : We never rent, trade, or sell my email lists to
anyone. We assure that your privacy is respected
and protected.

Visit .NET Programming Tutorial Homepage

______________________________________________________

Recommended Resource

| How do you prevent a class from overriding in .NET? | How are classes related to objects in .NET Application | How are Delegates different from Events in .NET? | How are system exceptions different from application exceptions in .NET? | How are Value Types different from Reference Types in .NET? | How can a finalize method be suppressed in .NET? | How can you call Stored Procedure in ADO.NET? | How can you force Dispose method to be called automatically in .NET? | How do you call a Base Class Constructor from Derived Class Constructor in .NET? | How do you connect your VB.NET application to SQL Server? | How do you implement Cloning in .NET? | How do you implement Façade Design Pattern in .NET? | How do you implement MVC Pattern in ASP.NET? | How do you install .NET Assembly in GAC? | How is shadowing different from overriding in .NET? | How to prevent a particular .NET DLL from being decompiled? | Illustrate Delay Signing Process of an Assembly in .NET? | What are Reference Types in .NET? | What are the advantages of C#? | What are the advantages of VB.NET? | What are the differences between Namespace and Assembly in .NET? | What are the similar features between class and structure in .NET? | What are Value Types in .NET? | What do you mean by mixed mode authentication in .NET? | What do you mean by Satellite Assembly in .NET? | What do you mean by shadowing in .NET? | What is CTS in .NET? | What is ILDASM in .NET? | What is Managed Code in .NET? | What is Manifest in .NET? | What is MSIL in .NET Framework? | What is the importance of finalize method in .NET? | What is the need for Visitor Pattern in C#? | What is the purpose of bindingRedirect tag in web.config file of .NET? | What is the purpose of CodeDom in .NET? | What is the purpose of dispose method in .NET? | What is the purpose of Ngen.exe in .NET? | What is the purpose of Strong Name in COM Components of .NET? | What is the purpose of virtual keyword in .NET? | What Object Oriented Principles can be incorporated in .NET Application? |