C# Database Log in

[newkhan]

Hi Experts,

I am using login mechanism in my currently developed software but i am confused to use the SQL query for login attempt.

SELECT * FROM <tablename> WHERE id="<login>" AND password="<pass word>";

Now tell me how to check that whether any value come in dataset in result of the above query.

Thanx.

[mzmishra]

what is your confusion.
please explain more

[newkhan]

Hi,

I want to get know that in result of execution of the above query, values (id,password) will go on DataSet but i want to enquire that how can i check that any value come in DataSet or not if no correct login information will be sent by user then i will display the error message for the user.
Hope now u will understand.
Thanx.

[mzmishra]

ok you can do like this
if(Dataset.tabl es(0).rows.coun t==0) then

[Shashi Sadasivan]

ok you can do like this
if(Dataset.tabl es(0).rows.coun t==0) then

and equivalent in c#

if(myDataset.Tables[0].Rows.Count == 0)
{
   //nothing found
}