Hello All Friends,
I am raj from New Delhi,India.
I am Developing a WebSite on ASP.Net Platform.Now I am executing a sqlQuery
"Select uid from tablename where uid='" + txtuid.Text + "'"

I wanna check whether this Query returns result or returns blank.
I can do this with inserting records in DataTable and then counting the rows in DataTable.
But is there any other way of doing this without DataTable or DataSet.
Thanks........raj

rajkumar

__________________
rajkumar

What are you going to use to hold the data?

Before you actually run the query you can run another query like:
"Select Count(*) from tablename where uid='" + txtuid.Text + "'"

You can return the count into a variable and check if it is >0.

Jim