VB Code to retrieve 1 value from sql database

[Ashe Sjedic]

Hi how do i do that in code please
thanks

 

[ThunderMusic]

dim dbconn as new System.Data.SqlClient.SqlConnection(ConnString)
dim dbCommand as new System.Data.SqlClient.SqlCommand(dbconn)

.... put your query code here

' *** here is the important line ***
TheOneValue = dbCommand.ExecuteScalar()

 

[Guest]

Ashe,
the Quickstarts are your friend:
http://samples.gotdotnet.com/quickstart/aspplus/doc/webdataaccess.aspx

They also install on your local machine, if you choose that option.
Peter

 

[Ashe Sjedic]

Thanks a lot you guys.