Ad:

ASP.NET Discussion Thread
Unsolved
Views: 6114

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jan 13th, 2006

URGENT!: Saving Database information from ASP.NET Button

Expand Post »

I am working on a seat selection page for an ASP.NET school project on movie booking system. I have created the seats using buttons (A1, A2, A3) etc.

When the user click on the button, the button colour changes and the user finalized the payment. I have an issue here. How do i save the button that has been clicked as an information into SQL Database. For instance, when the user selects Button A1 and A2, i want the information that the users have selected these 2 seats, A1 and A2 into the sql database.

URGENT!!

Similar Threads

Retrieve Information from Database & Display into ASP.NET Web Controls Textbox in ASP.NET
Disable ASP.NET Button from Listbox in ASP.NET
Saving information from .NET Listbox into SQL Server 2000 in ASP.NET

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Permalink

Jan 13th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

first of all what may be URGENT to you (ie your homework) is not urgent to us. Everyone feels their problem is #1 priority so please dont post as URGENT. My business and income is far more urgent than your homework. But we are here to help so here goes

First of all have one click handler for all the seat buttons. Secondly for each button append the seat number (A1, A2 etc) to the command argument property. On the button click handler grab the argument property and store it in a session object. Then when the whole transaction is complete save the information in the session object. I would recommend either an array or table as the session object.
I assume that:
1. You know about the commandargument property
2. You know about sessions
3. You know how to handle the same eventtype (e.g. buttonclick) from multiple instances in one handler
4. You know how to save information in a database

If you dont know any of those then shout and i will help

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Jan 13th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

One line in my last post maybe misleading:

Quote ...

Then when the whole transaction is complete save the information in the session object

Should have said

Quote ...

Then when the whole transaction is complete save the information from the session object

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Jan 15th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

You have made too much assumptions. I think it will be better if u explain with some codes. Thanks

Quote originally posted by f1 fan ...

One line in my last post maybe misleading:

Should have said

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Permalink

Jan 15th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

i will give some pointers... i am not doing homework for you.
each button needs to be setup as follows:

ASP.NET Syntax (Toggle Plain Text)
<asp:Button ID="Button1" runat="server" OnClick="SeatButton_Click" Text="A1" CommandArgument="A1" />
<asp:Button ID="Button2" runat="server" OnClick="SeatButton_Click" Text="A2" CommandArgument="A2" />
etc etc
<asp:Button ID="Button1" runat="server" OnClick="SeatButton_Click" Text="A1" CommandArgument="A1" />
<asp:Button ID="Button2" runat="server" OnClick="SeatButton_Click" Text="A2" CommandArgument="A2" />
etc etc

Then you need the one event handler which will handle all your seat buttons

ASP.NET Syntax (Toggle Plain Text)
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number
 
//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number

//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Jan 16th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

Thanks, i understood the command argument part. However, i am still having problem understanding the second hald as below.

Then you need the one event handler which will handle all your seat buttons

ASP.NET Syntax (Toggle Plain Text)
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number
 
//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number

//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}

[/QUOTE]

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Permalink

Jan 16th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

I notice that this half seems to be explained in C#, however i am writing my codes in VB.NET. Would appreciate if you help me with this..

Then you need the one event handler which will handle all your seat buttons

ASP.NET Syntax (Toggle Plain Text)
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number
 
//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}
 protected void SeatButton_Click(object sender, EventArgs e)
{
Button theButton = (Button)sender; //now you have the button that was pressed
string theSeat = theButton.CommandArgument; // now you have the seat number

//either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
}

[/QUOTE]

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Permalink

Jan 16th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

I have referred to this website,

http://www.startvbdotnet.com/aspsite...ls/button.aspx

i still can't figure out the difference between CommandArgument property and CommandName property

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Permalink

Jan 16th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

the command name property could be used in your case but it is a bad habit to get into. The command name property is used when the button is used inside something like a datalist. You can have many buttons in various templates and they will want to do various things (such as Edit, cancel, update etc). The parent control (eg the datalist) handles these controls not the page so you have to tell the parent what type of command it is (hence commandname = "edit" or commandname = "update") and you have an event handler for the parent control in your code. As there are multiple versions of this button in a datalist control you might need to pass extra info to the event handler - this is where the commandargument comes in. The concept is the same as calling a method and passing in parameters.
So stick to the rule that command name = method name and command argument = parameters. So you can pass parameters even though you dont need a method name in this case as the handler is already named in the onclick property.

As for the code my vb is very rusty but i will try

ASP.NET Syntax (Toggle Plain Text)
protected sub SeatButton_Click(object sender, EventArgs e) handles Seatbutton_click
 
Dim theButton as Button  = Ctype(sender, Button) ' now you have the button that was pressed
Dim theSeat as string  = theButton.CommandArgument; ' now you have the seat number
 
' either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
End Sub
 
protected sub SeatButton_Click(object sender, EventArgs e) handles Seatbutton_click

Dim theButton as Button  = Ctype(sender, Button) ' now you have the button that was pressed
Dim theSeat as string  = theButton.CommandArgument; ' now you have the seat number

' either store it in the session and the database on some other buttons click (such as a "Book Now" button) or straight to the database on each click.. that depends on your requirements
End Sub

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Jan 19th, 2006

Re: URGENT!: Saving Database information from ASP.NET Button

Sorry to bother you again. How can i store all the information (all the button clicks) as a session into the database

Naters_uk

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Jun 2005

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Asp.net 2.0

Next Thread in ASP.NET Forum Timeline: newby wants messenger type login options

DaniWeb Message

Cancel Changes

User Name
Password