473,320 Members | 2,117 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

help with simple dotnet page

Please provide a rough idea on how I can approach the following.

I have a page called student.aspx that looks like:

"See students by first letter of lastname (each letter is a link to the
current page)"
A B C D E F G .... Z

See students by gradelevel (each is a link to current page)
K 1 2 3 4 5 6 .. 12

Repeater based on what user clicked above
1234 Smith, Joe
5678 Thomas, Al
1838 Zeta, Bob

First Next Prev Last (paging for every 5 record)

For example, if I click B above it will display all students whose lastname
begins with B.

If I click K above, it will give me a list of all students who are in
Kindergarten

It has a listing of students (repeater) sorted by last name.

How can I pull this off so it would work with the dataset paging?

I can't seem to find this in any ASP.net book.

Thanks!

Nov 18 '05 #1
1 986
you can check QueryString to define the type of data set to display

e.g.

if Request.QueryString("LastName").Length=1 then
sql="select * from students where lastname like '" &
Request.QueryString("LastName") & "%'"
else if Request.QueryString("GradeLevel").Length>0 then
sql="select * from students where gradelevel='" &
Request.QueryString("GradeLevel") & "'"
else
sql="select * from students"
end if

and use that sql to get data out of the database

Alexey
"Tyro" <no****@please.com> wrote in message
news:B4*******************@newssvr25.news.prodigy. com...
Please provide a rough idea on how I can approach the following.

I have a page called student.aspx that looks like:

"See students by first letter of lastname (each letter is a link to the
current page)"
A B C D E F G .... Z

See students by gradelevel (each is a link to current page)
K 1 2 3 4 5 6 .. 12

Repeater based on what user clicked above
1234 Smith, Joe
5678 Thomas, Al
1838 Zeta, Bob

First Next Prev Last (paging for every 5 record)

For example, if I click B above it will display all students whose lastname begins with B.

If I click K above, it will give me a list of all students who are in
Kindergarten

It has a listing of students (repeater) sorted by last name.

How can I pull this off so it would work with the dataset paging?

I can't seem to find this in any ASP.net book.

Thanks!

Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Scott C. Reynolds | last post by:
Hi. I have created a templated control, and I want to know how i can set it up so that the projects consuming it will have all the same intellisense benefits of using any other server control. ...
2
by: Hazzard | last post by:
I just realized that the code I inherited is using all asp.net server controls (ie. webform controls) and when I try to update textboxes on the client side, I lose the new value of the textbox when...
19
by: Dales | last post by:
I have a custom control that builds what we refer to as "Formlets" around some content in a page. These are basically content "wrapper" sections that are tables that have a colored header and...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
1
by: deegee | last post by:
Hi, I'm new to C# and Visual Studio 2005 and very confused trying to do a very simple thing (I think). All I want to do is: when a page loads it runs a query on a table in a database and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.