I'm a newbie at programming for asp.net. My question i think is a simple one.

I need to pass the result of a SQL select statement into a variable.

var1 = "Select Company_name from Employee where ID = 615"

will this work? Do i need to run everything separately? any help is greatly appreciated.

Thanks!