April 25, 2013 at 6:32 am
Hai friends,
I m creating one sample application its has two dropdown boxes ddl1 and dd2
if i choose dd1 in air
to reflect value of economy ,business ll show on dd2
how to create the code for that.
April 25, 2013 at 6:33 am
We're going to need a little more information to help...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2013 at 7:07 am
in my dd1(mode of travel) has air,bus,car,train
if choose air ===> (dd2)ll display 2 options
economy,
business
train ==>
sleeper,
semi sleeper,
II AC
car ===>
car
like dis
April 25, 2013 at 7:10 am
I have absolutely no idea what you're trying to do, what the problem is, where the data is, or anything in fact.
Look at what you've written, would you understand the problem just from that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2013 at 8:17 am
raghuldrag (4/25/2013)
Hai friends,I m creating one sample application its has two dropdown boxes ddl1 and dd2
if i choose dd1 in air
to reflect value of economy ,business ll show on dd2
how to create the code for that.
What tool are you using to develop your application? You are far more likely to get help from a C# or whatever forum. Your question is quite API-specific and at this early stage has nothing to do with SQL Server. You probably won't get your question answered here, unless someone with skills common to your application designer accidentally stops by. It could happen, but it's unlikely.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
April 25, 2013 at 8:20 am
Gila, you're such a pedant!
OP, in terms of SQL it can be as simple as (but this is jus an example) When you select from the first drop down you fire a stored proc like the below and you use the returned result set to populate the second drop down.
CREATE PROC GetTravelClass
(
@ModeOfTravel INT
)
AS
BEGIN
SELECT TravelClass From ModesOfTravel where TravelMode=@ModeOfTravel
END
You won't get help with the front end code on here though so you'll have to figure this out yourself but the SQL should be straightforward IMHO.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
April 25, 2013 at 9:53 am
raghuldrag (4/25/2013)
in my dd1(mode of travel) has air,bus,car,trainif choose air ===> (dd2)ll display 2 options
economy,
business
train ==>
sleeper,
semi sleeper,
II AC
car ===>
car
like dis
Drop down 1 tied to table with air, train, car, and keys to table 2
Drop down 2 tied to table with economy, business with same key (1 for example), and that ties to air that has air and the key of 1
Table for drop down 2 also has modes for train and car with keys back to table 1 for those modes
Then the rest is more application specific as you will be passing the selected value from dd1 into a query or stored proc to populate dd2
April 25, 2013 at 10:36 am
Abu Dina (4/25/2013)
Gila, you're such a pedant!
a person who is excessively concerned with minor details and rules or with displaying academic learning
?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2013 at 2:40 pm
It's okay, I'm sorry I take it back. 🙂
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
April 26, 2013 at 5:13 am
I think I could probably help you with this but would need a lot more info on where you've reached so far:-
1. Do you already have a database for this and if so what platform? (I'm assuming sql server but please confirm that)
2. Have you already designed and populated the data tables or do you need help with that? If you have already designed them, what are the names of the tables and their fields?
3. Assuming you want help with the user interface code, what language are you using/planning to use?
4. Would this be desktop or web based?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply