Need Help With DataSet(), Should Be An Easy Question

I need to get the number of elements returned by an sql statement. i have the following code


I want to know how many rows were returned from the database?





SqlConnection conn = new SqlConnection(connectionString);





string query = null;





//Gather spec_names for dropdownlist


query = "SELECT spec_name FROM Menu WHERE use_it=1";





//Add Query to an SQL Command


SqlCommand cmd = new SqlCommand(query, conn);


SqlDataAdapter adp = new SqlDataAdapter();


//Add the command to the adapter


adp.SelectCommand = cmd;


//Create and fill a DataSet


DataSet ds = new DataSet();


adp.Fill(ds,"Menu");