1,105,578 Community Members

Most efficient way to query a single value from a database?

Member Avatar
Paradox 99
Newbie Poster
8 posts since Jul 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi all,

I've been using this type of code to pull out a single value from my SQL database but I can't help thinking that there's a simple command I'm not using:

strSQL = "SELECT MAX(Stage) FROM Visits WHERE ScheduleRef = 22"
        FinalStage = dl.getPRISMdata(strSQL).Tables(0).Rows(0).Item(0)
Public Function getPRISMdata(ByVal strSQL As String) As DataSet

        Dim conn As New SqlConnection(ConnectionStringPRISM)
        Dim ds As New DataSet

        conn.Open()

        Dim da As New SqlDataAdapter(strSQL, ConnectionStringPRISM)
        da.Fill(ds)
        Return ds


    End Function

It's the tables(0).rows(0).item(0) that bothers me. It works, but should I be doing something different here? Something more efficient in the function perhaps?

Thanks!

Member Avatar
sufyan2011
Junior Poster
165 posts since Dec 2011
Reputation Points: -1 [?]
Q&As Helped to Solve: 23 [?]
Skill Endorsements: 0 [?]
 
0
 
Member Avatar
Paradox 99
Newbie Poster
8 posts since Jul 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

ExecuteScaler, see the following link for your solution:

http://funbytebitstop.wordpress.com/2008/04/15/count-records-using-executescalar-in-aspnet/

Perfect! Thank you!

Question Answered as of 2 Years Ago by sufyan2011
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: