访问和ASP [英] Access and ASP

问题描述

你好，

我有一个可访问的数据库，它包含10个表.

我已经设法使用Visual Studio，Access数据源和网格"视图来获取要在网页上显示的选定表.


在网格视图中，我从众多表格中选择了一个.这显示没有问题

我现在想要做的是让用户可以选择单个字段，然后表格将反映所选的字段.

即

有一张有4个列的桌子.

1.汽车制造
2.汽车型号
3.发动机尺寸
4.汽车颜色

我想您将需要使用下拉列表.

因此，在ist下拉列表中，用户选择了汽车制造商.然后将依次显示该网格中所有该品牌的汽车.

然后，用户可以继续选择汽车模型，这将依次选择该品牌和模型的所有汽车.

发动机的尺寸和颜色也是如此.

我希望数据库无论选择什么都具有此功能，即如果他们首先选择了汽车颜色，则表格将显示该颜色的所有汽车/品牌/型号/发动机尺寸.

用access和asp做到这一点的最佳方法是什么.

谢谢

Hi there,

I have a database in access and it contains 10 tables.

I have managed to get a selected table to disply on a webpage using Visual Studio, the Access data source, and the Grid view.


in the grid view I have selected one out of the many tables I have. This displays without a problem

What I am looking to do now is to have the option for the user to select individual fields then the table will reflect the fields selected.

i.e

there is a table with 4 colomns.

1.Car make
2.Car model
3.Engine size
4.Car colour

I presume you will need to use the drop down list.

So in the ist dropdown list the user selects the car make. this will then inturn display all the cars of that make in the grid.

The user can then go on to select a car model, which inturn will select all the cars of that make and model.

the same goes for engine size and colour.

I would like the database to have this functionality for no matter what the select, i.e if they select the car colour first , the table will then show all the cars/makes/models/engine size of that colour.

What is the best way of doing this with access and asp.

Thank you

推荐答案

基于我见过的工作，我的建议:

有一个组合或列表框的链".仅使第一个处于启用状态，并让用户选择一个项目.使它引起回发或AJAX调用(我个人认为AJAX更好，因为它不那么刺耳")，并用可能的答案更新链中的下一个.重复直到完成.

我见过的一个很好的例子是Ebay中的类别选择工具(假设他们没有更改它).



建议资源:

http://www.w3schools.com/ [ ^ ]-一个优秀的网站，可以开始学习许多浏览器技术

My suggestion, based on what I''ve seen to work:

Have a ''chain'' of combo or list boxes. Leave only the first one enabled, and get the user to select an item. Make this cause a post-back or an AJAX call (I personally think AJAX is better as it''s less ''jarring'') and update the next in the chain with the possible answers. Repeat until done.

A good example I''ve seen is the category select tool in Ebay (assuming they haven''t changed it).



Suggested Resources:

http://www.w3schools.com/[^] - An excellent website to start learning many browser technologies

@ Tony Richards

谢谢，这似乎是最合适的方法.问题是我对AJAX或许多其他编程语言一无所知.我是个初学者，不知道如何或从哪里开始:(

@ Tony Richards

Thank you, that does seem like the most appropriate way of doing so. The problem is I have no idea about AJAX or many other programming languages. I am a massive beginner and dont know how or where to start :(

这篇关于访问和ASP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！