two problems in ASP.NET 2.0?

Question

How I can know my sqldatasourse found any record or not I dont want to use datalist or another data table .and how I can put each feild that sqldatasource found on a string object( ineed just one record that sqldatasource found.)
I need a code that on page load automaticly goto another page

Answer 1

first you have to make a datareader (let's call it rd1 for example), and fill it with proper data from the datasource.

now you use

while ( rd1.read())
{
// do what ever and then go the next record in rd1
}

the secret is that the method rd1.read() will check if there are any records retrieved, and if yes it will return them

Answer 2

The DataTable has a property called Rows, which has a property called Count. Obvoiusly, if Count == 0, then no rows were return.
Simple as that.