We help IT Professionals succeed at work.
Get Started

Using SqlHelper.ExecuteDataset in VB.Net

Sheritlw asked
Last Modified: 2012-05-06
Hi Experts,

I am new to .Net and have been reading, reading, reading...
From a previous question, I found out about the Microsoft.ApplicationBlocks.Data and am trying to use this to access my data.
I have created the code below to fill grids (fpSpread).  
Everything I have read says that you always close the connection, but with the sqlhelper I was wondering if this will close the connection for me and if this code is correct?

Public Shared ReadOnly Property ConnectionString() As String
            Return ConfigurationManager.AppSettings("ConnectionString")
        End Get
    End Property
Public Function GetDataSetGrd(ByVal strSQL As String) As DataSet
        Dim ds As New DataSet
            ds = SqlHelper.ExecuteDataset(AppConfig.ConnectionString, _
                                CommandType.Text, strSQL)
            Return ds
            Exit Try
        Catch ex As Exception
            Return Nothing
            If Not ds Is Nothing Then
            End If
        End Try
    End Function

Open in new window

Watch Question
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE