c# - Do you need a DataTable to retreive data from a DataAdapter?
===

Most of my queries are very short, 1-3 records total.  This is the code I have now.  I am wondering if there is a way to capture userid directly from DataAdapter without going through a table.  Thanks!

        SqlDataAdapter dataAdapter = new SqlDataAdapter(strSQL, strCon);
        SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
        DataTable t = new DataTable();
        dataAdapter.Fill(t);
        int userid = 0;
        if (t.Rows.Count > 0)
        {
            DataRow dr = t.Rows[0];
            userid = dr.Field<int>(0); 
 
