Dataset question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Keith Smith (keithsmith3_at_verizon.net)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 13:30:41 GMT

For authentication purposes I query my Access database using a Username and
Password. If the dataset turns up empty then the user does not have access.
If it shows up with a value in the dataset then the user is authenticated.

The problem I am having is that when I count the number of entries in my
dataset it always shows up as "1". Even when I query the database with
values that aren't in the database.

I am using this code...
int RecordCount=dtSet.Tables.Count;

Is there a better way to count the entries in a dataset? Or perhaps a
better way of authentication all together?

Relevant Pages

  • Re: Merging data from Access Query
    ... Data from the database will be placed in the document, ... Y/N ?" ... If the query references the Form, ... The process starts in an access database. ...
    (microsoft.public.word.mailmerge.fields)
  • This ones a challenge: 1.9 not equaling 1.9..... Whats going on???
    ... I've got a real challenge this time with an access database that I'm ... I'm writing this database for work, ... column #1 in the query is titled ...
    (microsoft.public.access.queries)
  • Re: Creating forms in Excel to Import access data ! Please reply
    ... File>Table Definition, select your database, and set your query - you can ... also type in SQL directly. ... >> access a query in the Access database. ...
    (microsoft.public.excel)
  • ADO to ADO.NET 2.0
    ... and an Access database. ... In this application, we routinely query multiple ... to the database are implemented by the record set's Update command. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Excel - MS Query - changing location of Access data source
    ... > I created a spreadsheet and use MS Query to get data from a Access ... > to the Access database and the query fails because it can't find the ... > to store the path to the database in a cell and use a macro to ...
    (microsoft.public.excel.programming)