Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Searching and going to a record using datasource controls

Thread Tools

Searching and going to a record using datasource controls

Posts: n/a

I'm trying to use the sqldatasource control and a detailsview to
create a fully functional data entry screen; it's quite easy. I can see
the strength of creating a master grid associated with a detailsview
that gives you access to the record you choose in the grid.

However one of the basic functions of this type of screen is the
ability to enter a search term and have the grid display the record
that is closest the search term. That would allow a user to search for
the record he or she wants and then click on it in the grid to edit it.
I've seen some vague mentions of how this would be done using
datasource controls but nothing specific.

I was also wondering if it was possible to have detailsview (or
formview or gridview for that matter) display a certain record within
from a datasource without having a parent control/datasource to
determine what record that is. For instance, let's say you added a new
record to a table and you wanted the gridview to display the page that
that record is in. You'd have to find which page the record is in by
finding the row number of the record, dividing it by the page size,
etc. I can't seem to find how to do this kind of this in 2005.

I realize I may be missing the point and that the new datasource
controls aren't designed to do this kind of thing; I'm thinking in very 1.1 disconnected dataset terms. Any advice would be helpful.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a Record using a current record MRW ASP .Net 0 02-11-2008 06:58 PM
Moving to a specific record with a gridview and datasource fig000 ASP .Net Web Controls 0 06-22-2007 05:39 PM
Adding new record using previous record information... help!! Maximus ASP General 2 04-12-2007 09:55 PM
insert record using stored proc returns no error but doesn't inserd record ASP General 1 01-09-2004 04:53 PM
using dropdown box to display db record & update record Jimmy Tran ASP General 1 10-03-2003 04:20 PM