How to get the number of query columns in the code below

su0405

private BindingManagerBase bm;

con = new OleDbConnection (constring); // Connect to the database
con.Open ();
adapter = new OleDbDataAdapter (@ "select * from theme where kemu = '" + lx + "' and teacher = '" + tch + "' order by newid ()", con);
rs = adapter.SelectCommand.ExecuteReader ();
rs.Read ();

bm = rs.? // Number of eligible records

shenmue024

datareader does not have this feature.

shenmue024

Read only one by one, unless using a DataTable

everever30

int i = 0 // i is the number of rows
while (rs.Read ()) i ++;

苹果小刀

int i = 0;
while (rs.Read ())
{
 i ++;
}

su0405

I am an online test system. The generated questions and number are random. I must put the answers to multiple choices in an array. To determine the length of the array, I must obtain the length of the query result (the number of questions generated). Also do the navigation bar (previous question, next question, first question, last question). How to achieve it, please master click, ASP. New to .NET!