c# - Retrieving Individual Columns from an ADO.NET Result Set -

i have website set query database username, , populate session[] variables user's info. when query using server's stored procedure, entire row. how can split apart row , parse every column gets parsed separately?

my code button is:

protected void button4_click(object sender, eventargs e) {     string strconn = webconfigurationmanager.connectionstrings["ticketsconnectionstring"].connectionstring;     sqlconnection myconnection = new sqlconnection(strconn);     //search button     string sqltext = ("select * [dbo].[user]");           sqlcommand mycommand = new sqlcommand(sqltext,myconnection);     mycommand.commandtype = commandtype.text;     myconnection.open();     sqldatareader objreader;     objreader = mycommand.executereader();      objgrid.datasource = objreader;     objgrid.databind(); } 

update

i updated string sqltext = ("select 'userid', 'firstname' [dbo].[user] userid='"+txttest.text+"' , password='" + txtpass.text+"'");

but following column column1 column2 userid firstname

to read column's value use this:

 avar = row["colname"];