session的问题,急!!!请高手帮忙!!!

用DataSet.
SqlConnection con=new SqlConnection("链接字符串");
string sql="select * from test";
SqlDataAdapter sda=new SqlDataAdapter(sql,con);
DataSet ds=new DataSet();
sda.Fill(ds);
string str=ds.Table[0].Rows[0][0].ToString();//第一张的第一行第一例.也可以直接用例名:
string str2=ds.Table[0].Rows[1]["personid"].ToString();

SqlDataAdapter sda=new SqlDataAdapter(sql,con);
不是有了SqlDataAdapter

用SqlDataReader
SqlConnection con=new SqlConnection("ddd");
string sql = "select PESONID from PERSON"
SqlCommand cmd=new SqlCommand(sql,con.conn);
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
..=dr[o].ToString();
}