Bookig seats in ASP.NET

Question

0.00/5 (No votes)

See more:

I had a seats table contain (SeatsId,SeatName,SeatStatus) .... created in Microsoft SQL Server with stored procedures (Select,Update,Delete,Insert)
I create booking page in ASP.NET and i can list the seats using entity data source.....

but the Problem is:

how to list the not booked seats in the drop down list or how to add validate to drop down list to check SeatStatus . .......

for example if SeatStatus.value == booked not display this related filed

or maybe i can add Where Expression to the entity data source like:

it.[SeatStatus] == notbooked

Thanks

Posted 24-Aug-13 3:49am

Aiham85

Add a Solution

Comments

[no name] 24-Aug-13 10:10am

"maybe i can add Where Expression", well that seems like a pretty good idea to me. Why don't you try it and see what happens?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aiham85 · Accepted Answer · 2013-08-24T04:36:00

yup its work thanks a million :

XML

<asp:EntityDataSource ID="EntityDataSource4" runat="server" AutoGenerateWhereClause="True" ConnectionString="name=ARS_DBEntities2" DefaultContainerName="ARS_DBEntities2" EntitySetName="Seats" Select="it.[SeatId], it.[SeatName], it.[SeatStatus]" Where="">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DbType="Int16" Name="flighId" PropertyName="SelectedValue" />
</SelectParameters>
<WhereParameters>
<asp:ControlParameter ControlID="DropDownList1" DbType="Int16" Name="FlightId" PropertyName="SelectedValue" />
<asp:FormParameter DefaultValue="notbooked" FormField="it.[SeatStatus]" Name="SeatStatus" />
</WhereParameters>
</asp:EntityDataSource>