I want to create session variables for Company and Role in the below query:

objConn.Open()
objCmd = New SqlCommand("SELECT Username, Company, Role FROM A_Users WHERE Username=@givenUsername", objConn)
objCmd.Parameters.AddWithValue("@givenUsername", Username)
objRdr = objCmd.ExecuteReader()

I am a CF Programmer new to .Net. So I am learning how to do .Net on the fly.

Your help is appreciated.

John

You have to loop through the reader and assign a value into a session variable.

session("Company") = readervalue .. Check the syntax on how to get the reader value.