Groups > Databases > Access Databases and AccessDataSource Control > Re: AccessDataSource with Gridview




AccessDataSource with Gridview

AccessDataSource with Gridview
Thu, 3 Apr 2008 14:48:18 +0000
I am very new to asp.net and visual web developer, and I am working on a very
simple website. The site consists of an access database, a login page, and a
main page. The main page pulls the data from the database and displays it in a
gridview. There are a total of 3 columns in the gridview named: Entry Date,
Entry Time, and Name. These 3 columns are the names of the columns in the
database. As of right now, I have a working dropdownlist that is populated with
every unique name from the Name column in the database. 

What I want to do is create an additional dropdownlist that will allow a user to
further filter the gridview by the very first entry time per entry date, per
name. Is there a way to add a second dropdownlist that uses a accessdatasource,
but the accessdatasource only selects the first entry time for each entry
date?
Post Reply
Re: AccessDataSource with Gridview
Thu, 3 Apr 2008 22:14:24 +0000
i might be oversimplifying the question but could you add a parameter to the
access data source then add TOP 1 so it only returns the first record in the
returning recordset
Post Reply
about | contact