Pages: [1]   Go Down
Print
Author Topic: ASP VB - Display records from Recordset  (Read 2084 times)
JamesD
SWS Customer
Normal Member
*****
Offline Offline

Gender: Male
Posts: 49


View Profile WWW
« on: July 25, 2008, 06:35:43 pm »

Hey Guys,

I'm a bit stuck, and my mind is blank on this..

How do I only display records on a page to Users that have the UserID in the record??
Logged

Regards,
JimBob
Adam Spencer
Administrator
Normal Member
*****
Offline Offline

Gender: Male
Posts: 143


Administrator


View Profile WWW
« Reply #1 on: July 28, 2008, 06:33:09 pm »

Hi James,

If you want to display a users record by using their unique user ID then you simply setup a filter ont he recordset. For example, you could filter the records by using a Querystring value, posted by the previous page in the URL of the browser. Another way would be to use a session variable.

Here are the examples you should set the recordset to:

  • Request.Querystring("UserID")
  • Session("UserID")

If you need any help I can post some screens  Wink
Logged

Regards,
Adam Spencer
Silverline Web Solutions
www.silverlinewebsolutio ns.co.uk
JamesD
SWS Customer
Normal Member
*****
Offline Offline

Gender: Male
Posts: 49


View Profile WWW
« Reply #2 on: July 28, 2008, 07:11:23 pm »

That didn't help Really Confused
Logged

Regards,
JimBob
Adam Spencer
Administrator
Normal Member
*****
Offline Offline

Gender: Male
Posts: 143


Administrator


View Profile WWW
« Reply #3 on: July 28, 2008, 08:25:52 pm »

That didn't help Really Confused

Can you explain exactly what your trying to do please?
Logged

Regards,
Adam Spencer
Silverline Web Solutions
www.silverlinewebsolutio ns.co.uk
Adam Spencer
Administrator
Normal Member
*****
Offline Offline

Gender: Male
Posts: 143


Administrator


View Profile WWW
« Reply #4 on: November 30, 2009, 11:16:00 am »

I want to know :

I have the textbox in form and If i enter the value in textbox and That matches to back end record then How we will display the all the records in Data grid in ASP

Hi Vielonee,

Well basically after you have created a form with your text field, you will need to filter the record based on this textfield. To do this, make sure you name the textfield the same as the column in the database you want to filter by, and then in the action property of the form you will need to type in this:

http://mydomain.co.uk/filterpage.asp?filtercolumn=name

Obviously replace 'mydomain' with your domain name. If you have any problems, give us a shout Smiley

By the way, which host are you using?
Logged

Regards,
Adam Spencer
Silverline Web Solutions
www.silverlinewebsolutio ns.co.uk
Pages: [1]   Go Up
Print
Jump to: