asp.net with SQL problem

[ola123]

Here im creating a Web Form..
I have inserted data into an Access file using SQL syntax (SELECT COMMAND).

What i would like to do now is to be able to take ONE field from one of the tables within the Database and place that value inside a variable in my </script> section. So how would i go about doing this

Another thing, what would the the correct syntax for the ExecuteScalar() function be...

 

[johnwm]

ASP.NET = forum855
This forum is classic ASP

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints