|
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
|
|
|
|
|
So, do I understand that your result table will always display the following columns ?
Make, Model, Engine Size, Color
If so, then you would create 4 drop down lists which would be used to filter the results grid.
Start with this,
1) Place a combo box on your page and fill it with distinct values of car makes.
Your SQL would be something like: "select distinct make from myTable order by make"
2) Create code for the combo box "SelectedIndexChanged" event that would build a new SQL string including the selected value from your combo box in the where clause. Your SQL would be something like "select * from all_cars_table where make = combobox.selectitem"
This should give you a direction to start in ...
Good luck. 
|
|
|
|
|
Thank you, that does seem like the most appropriate way of doing so. The problem is I have no idea about SQL or many other programming languages. I am a massive beginner and dont know how or where to start 
Im using Visual studio 2008 and Ms Access 2008.
I will have around 100 different makes of cars.
|
|
|
|
|
|
Hi Guys
I'm starting work on a project that is a larger scale to anything I've done before, and it is probable that we will be deploying it to clutered servers...
Do I need to do anything special to account for this in the app? or would I just carry on developing as though it was a single server web application?
Thanks in advance 
oooo, the Jedi's will feel this one....
|
|
|
|
|
You must have system intergration plan document/deployment document(deployment environement related stuff doucmented)/design documents in your project which should be having all these information. Your question does not reflect any specific technical query however which is general to technical forum.
Please correct me if I am wrong.
Thanks,
Arindam D Tewary
|
|
|
|
|
Thank you for your reply.
I'm sorry. I don't think I was very clear with what I'm after.
This is my first large scale application. Everything else I have done has been happy running on a single server. This project is to run on clustered servers, so I was wondering if I would need to code to account for the multiple servers (Data Access etc), or if I should just code as I would have for a single server solution? I don't know if the cluster would take care of itself, or if I need to take care of it programatically.
This is probably a silly question, but I'm self taught, and have never tackled this kind of thing before.
(I may be in a little over my head...  )
oooo, the Jedi's will feel this one....
|
|
|
|
|
If your application is deployed over multiple server then you might keep in mind some below mentioned points as a developer.
(1) There are load balancing software which handles incomming request.
(2) if you know that your application redirects http request across multiple domain, then you should use Response.Redirect(). Otherwise server.transfer for new redirection in case you need that.
(3) Even if you use session variable you have to store Session data in a centralised database/server so that redirtion across multiple server(domain) does not loose any session data. I would post if some more points I can provide to you in this thread.
Thanks,
Arindam D Tewary
|
|
|
|
|
Thats a good point about the session data. I didn't think about that. I suppose session data would no longer be any use unless stored in a database or maybe in cookies? to cope with the possibility of a different server serving up your newly navigated page from the previous page.
That has given me a good start. Thank you.
oooo, the Jedi's will feel this one....
|
|
|
|
|
You are welcome. 
Thanks,
Arindam D Tewary
|
|
|
|
|
See As per development point of view, if your application is going to be on multiple web servers, then you have take extra care about those items who resides in server memory like session,application variables etc.You should use DB to store most of the data. Application variables should not be used in case of multiple servers. And for session, it should not be in InProc mode.
For details about session, Exploring Session in ASP.Net
Rest thing like how your application is going to accessed by endusers ie url, how you are going to connect to DB and other server if there, should be taken care by H/W guys
|
|
|
|
|
Great. Thank you.
oooo, the Jedi's will feel this one....
|
|
|
|
|
your welcome
|
|
|
|
|
hi people
i have this issue , and am seeking solution
i want to prevent user from making changes to querystring coz i pass some parameters
i tried the querystringmodule that encrypt the query string but no luck coz if the user opened the page source he will see all the links.
i also tried some mod-rewrite or url rewrite , but its complex and also can be changed by user (its not secure, its just makes the query string pretty )
now i used iframe in home.aspx page and the src is my login page of the application , so the user see only home.aspx in the address bar
but the problem is that the user can open the iframe content in any new window so i need to prevent any access to the application that comes from other windows (not from the iframe).
please give me ideas or solutions
thanks
|
|
|
|
|
suhaib1982 wrote: want to prevent user from making changes to querystring coz i pass some parameters
You can never have any control over what user will have in their query string. User can anytime modify querystring and sent a http get request. Only thing you can try to get your needed portion to work on.
You can try basic form submission using post method in case you want to secure sumiiting data in login page.
Thanks,
Arindam D Tewary
|
|
|
|
|
you can use encryption techniques to encrypt your query string values before passing.
so that user can never get the idea about it.
|
|
|
|
|
You'll have to not use a querystring if you don't want the querystring to be edited (which it always can).
The easiest is to use the Session object to store your value temporarily.
|
|
|
|
|
Passing data values between Web pages has many applications, including maintaining personal user information. Legacy Web solutions, like using the querystring and cookies, allows you to pass and maintain values, and you can easily direct one page to another when submitted. ASP.NET 1.1 supported these solutions as well as additional ones, but ASP.NET 2.0 addresses the issue head on by supporting cross page postbacks. This makes it easy for one Web page to process data from another. Take advantage of this new concept when you're working on your next ASP.NET 2.0 application.
Please check this link :Cross-Page Posting in ASP.NET Web Pages
|
|
|
|
|
IF u wanna to transfer data from one page to another page usually we used to go for query string.
here what method we using to transfer data is the thing..
we can transfer data in two ways
Response.Redirect("page1.aspx"?z);-----this method does not have masking(means hide the data on the address bar)
or
Server.Transfer("page1.aspx"?z);------this has masking(means hide the data on the address bar)
|
|
|
|
|
Why not using a post method for sending the parameters.. Also, you can use session variable, or a cookie so that a common user wont be able to modify such details as such..
- jaypatel512
|
|
|
|
|
Hi,
How to Hide the Address bar and status bar, Asp.Net in Visual Studio 2008. I want the page to look like a windows form.
Thanks,
|
|
|
|
|
Are you trying to hide address bar and status bar in web browser??
Thanks,
Arindam D Tewary
|
|
|
|
|
|
|
You cannot do that from server side, as you dont have access to the clients browser settings.
A possible - nearly - solution would be to use javascript (and windows.open) like described in
this thread. But, like mentioned there, the
user can prohibit hiding bars in different browsers. And it will certainly not look like a windows form.
Another possibility is to use divs/panels - which look like windows forms - and make use of the ajaxcontroltoolkit (and the popup-extender controls etc.) to open/close these divs/panels. For
the user it "feels" like an seperate window/page then, even if it isnt. There are also some rich (and free) java ui kits out there, which provide these kind of "windows" functionality. The advantage is that
popup blockers dont block these "popups" because they arent popups..But it is certainly more difficult
to get dynamic content working in these szenarios.
Check componentone.com for an commercial example (window control in asp.net suite).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
