I need to select one of the Columns and put into a session variable.

[osirisa]

Hi Group,

First, Just for your information, I am very new to the .Net world. So, please forgive my ignorance.

I need to extract two fields from a DataSet 1. ChartObject and 2.NetObject. Once I have the results for this two fields, I need to assigned them to a Session Variable.

Enclsoed is what I have done so far...of course the code doesn't work but it will give you an idea of my dilema.



'calling the Stored Procedure to Populate the Grid
cmdSP = New Data.SqlClient.SqlCommand("Select", cnSW)
cmdSP.CommandText = Data.CommandType.Text.ToString()
SqlDataLocation.SelectCommand = "SELECT DISTINCT [Region_Description], [Server_Code_Location], [ChartObject], [NetObject] FROM [Location]"
SqlDataLocation.ToString()


Thanks for the Help!!!!!!!!!!!