Store result of a query in variable

[nelco]

I am trying to store the result of this query:

Select Max(Cookie_ID) From CookieLeadSource

into a variable in VB.

Any ideas on how to do this?

 

[RiverGuy]

Look at the SqlCommand.ExecuteScalar() function.

 

[nelco]

Thanks Riverguy. It worked with ExecuteScalar.