473,320 Members | 1,838 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.

Search Page

Please solve my issue .

i want to develope a search form for which will search the values from a table and fetch the values from the table and show that value in the a gridview.

now i am going t describe everything:.


i have a table suppose tbl_update which having following coloums:

tb_id int
file_id int
App_Type nvarchar(50)
Role_id int
Field_Name nvarchar(50)
Old_Value nvarchar(50)
New_Value nvarchar(50)
Form_Name nvarchar(50)
Cycle nvarchar(50)
Date datetime(50)


Now about the form:

In the form i have 5 Dropdowns whose id's are:

1)ApplicationType ( should populate from App_Type coloum of table and appname should be distinct)

2)case name (should populate from File_id coloum of table)

3)Cycle (should populate from cycle coloum of table)

4)formName (should populate from form_name coloum of table)

5)fieldname (should have to populate from field_ name column of table)


now the conditions are as :

1) when i click applicationtype dropdown then case name should be populated and value should change by selecting value of applicationtype dropdown,
and also when i select cycle the case name should be changed and affected or should be populated.

2) Also when i select ApplicationType then the formname dropdownlist should be populated and then when i select formname dropdownlist then
fieldname dropdown should be populated.


And then when all dropdown is populated as by the mentioned condition above then there will be a button on the form named "SEARCH ", when clicking on the

button search the searched value will be shown in a gridview.

please help me in making database handling in this form , i mean if using stored procedure then help me in making that also .. i mean i want everything from
scratch , since i dont know ohw to write a storedprocedure or query also and to write logical query.


I Hope Someone can help me , since i am a fresher to programming and learning so finding very difficult to handle .

i am attaching the snapshot of the database table so that a clear view can be made.

Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever
he/she finds suitable for validations can add that also.


Please , this is very urgent.... hope will get support from members.

Thank You.
Aug 7 '08 #1
1 1014
Curtis Rutland
3,256 Expert 2GB
Please i want a full code of everything if possible with javascript validations, i mean anyone who help me then have to take some time for this and whatever
he/she finds suitable for validations can add that also.
Sorry, this isn't that kind of forum. This is a programming help forum, not a place where you can get someone else to do your job for you for free. If you were to code this yourself and have some problems then we can help, but nobody is going to do your assignment for you.

MODERATOR
Aug 7 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: R. Rajesh Jeba Anbiah | last post by:
Q: Is PHP search engine friendly? Q: Will search engine spiders crawl my PHP pages? A: Spiders should crawl anything provided they're accessible. Since, nowadays most of the websites are been...
1
by: Les Juby | last post by:
A year or two back I needed a search script to scan thru HTML files on a client site. Usual sorta thing. A quick search turned up a neat script that provided great search results. It was fast,...
2
by: CharitiesOnline | last post by:
Hello, I have set this script up to add paging to a search results page. Which on the first page works fine. I calculates how many pages there should be depending on the number of results returned...
5
by: George | last post by:
Hi, Anyone has the background for explaining? I have made a search on my name and I have got a link to another search engine. The link's title was the search phrase for the other search engine...
4
by: MDW | last post by:
Posted this on another board, but evidently it was off-topic there...hope you folks will be able to provide some guidance. I've been working on a Web site for a business (my first non-personal...
11
by: emailus | last post by:
I am webmaster for the domain <www.alpha1.org.au>. Not being an expert in html, I take advantage of my domain Registrant's web building tool, 'Instant Website'. This tool is provided as part of...
4
by: bendlam | last post by:
I have a page that contains search criteria and when you click on the search button it causes a post back that populates a dataview on the same page. One of the gridview columns contains a link...
1
Merlin1857
by: Merlin1857 | last post by:
How to search multiple fields using ASP A major issue for me when I first started writing in VB Script was constructing the ability to search a table using multiple field input from a form and...
13
by: jfarthing | last post by:
Hi everyone! I am using the script below to search a db. If the is more than one match in the db, all goes well. But if there is only one match in the db, nothing gets displayed. Any...
3
by: Bigalan | last post by:
Hello, i am relatively new to PHP and i am struggling with printing multiple search results on to different pages. The code below works ok but when you click on next page button, it brings up a blank...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

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.