Update Database and Redirect to new page

[jenileo]

Hello!

I'm fairly new to asp.net and I am struggling with getting my form to
post to the database and transfer the user to a new page. I am using
the FormView control. After the user completes the form, they click the
insert button. The insertbutton has command="insert " which is auto
generated when you use the formcontrol. I tried to add an onclick event
as well that does a server.transfer and it seems the onclick event
overrides the command event. I am redirected to a new page but the
database is not updated. I also tried the onunload event, while it
worked for both redirection and database update, it also put page2 on
page1. So I added an if ispostback to the transfer event and it worked
beautifully! However, I have another button that shows a calendar and
puts the date in textbox and what does that do, it fires a postback, so
I get an error on the page. Hopefully this can be understood. The goal
here is to have the user push a button that will insert data into the
database as well as take the user to a new page. I think the key also
is this should be done using the formview control, from my experience
things work a little differently with in the formview control. Let me
know if I can post more info. Thanks!!

[brians[MCSD]]

Hello Jenileo,

I'm not sure I exactly understand your situation but my guess would be that
you want to handle the FormView.ItemIn serted event. It occurs when an Insert
button within a FormView control is clicked, but after the insert operation.
In the event you could redirect the user to the new page.

--
enjoy - brians
http://www.limbertech.com
"jenileo" wrote:

Hello!

I'm fairly new to asp.net and I am struggling with getting my form to
post to the database and transfer the user to a new page. I am using
the FormView control. After the user completes the form, they click the
insert button. The insertbutton has command="insert " which is auto
generated when you use the formcontrol. I tried to add an onclick event
as well that does a server.transfer and it seems the onclick event
overrides the command event. I am redirected to a new page but the
database is not updated. I also tried the onunload event, while it
worked for both redirection and database update, it also put page2 on
page1. So I added an if ispostback to the transfer event and it worked
beautifully! However, I have another button that shows a calendar and
puts the date in textbox and what does that do, it fires a postback, so
I get an error on the page. Hopefully this can be understood. The goal
here is to have the user push a button that will insert data into the
database as well as take the user to a new page. I think the key also
is this should be done using the formview control, from my experience
things work a little differently with in the formview control. Let me
know if I can post more info. Thanks!!

[jenileo]

That is exactly what I want to do! Any suggestions?

[Jeff Dillon]

Um, he just gave you the suggestion? Your redirect code goes in the
FormView.ItemIn serted event

"jenileo" <je*****@yahoo. com> wrote in message
news:11******** *************@u 72g2000cwu.goog legroups.com...

That is exactly what I want to do! Any suggestions?

[jenileo]

Um, I did not realize that? I thought he was reiterating what I was
saying. Must-talk-slowley, I-am-newbie.
I did do the redirect using the formview control and it did not insert
into the database, it only redirected. Here is a snippit, just a
snippit. Maybe I'm not accessing the control correctly? I can post more
code if needed. Thanks in advance for any help that can be offered.
_______________ _______________ _______________ _______________ _______________ _______________ _______________ ____

<%@ Page Language="VB" MasterPageFile= "~/MasterPage.mast er"
EnableViewState ="false" %>

<script language="VB" runat="server">

Sub doSubmit(ByVal Source As Object, ByVal E As
EventArgs)
If IsPostBack Then

Server.Transfer ("newissueconf. aspx")
End If
End Sub

</script>

<asp:Button ID="InsertButto n" runat="server"
CommandName="In sert" onclick="dosubm it" Text="Log Issue" Width="82px"
/>
</InsertItemTempl ate>

</asp:FormView>

</asp:Content>

[Jeff Dillon]

FormView.ItemIn serted is an actual event handler! Like Onclick.

Jeff

"jenileo" <je*****@yahoo. com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. .

Um, I did not realize that? I thought he was reiterating what I was
saying. Must-talk-slowley, I-am-newbie.
I did do the redirect using the formview control and it did not insert
into the database, it only redirected. Here is a snippit, just a
snippit. Maybe I'm not accessing the control correctly? I can post more
code if needed. Thanks in advance for any help that can be offered.
_______________ _______________ _______________ _______________ _______________ _______________ _______________ ____

<%@ Page Language="VB" MasterPageFile= "~/MasterPage.mast er"
EnableViewState ="false" %>

<script language="VB" runat="server">

Sub doSubmit(ByVal Source As Object, ByVal E As
EventArgs)
If IsPostBack Then

Server.Transfer ("newissueconf. aspx")
End If
End Sub

</script>

<asp:Button ID="InsertButto n" runat="server"
CommandName="In sert" onclick="dosubm it" Text="Log Issue" Width="82px"
/>
</InsertItemTempl ate>

</asp:FormView>

</asp:Content>

[jenileo]

Hi Jeff,

Sounds like you are frustrated with me and I really apologize. I can't
stress enough how new I am to this and I am turning to this group for
support. I appreciate your lead and I will do some reading up on
FormView.itemin serted and see if I can figure this out, (that should
tell you how new I am.) Meanwhile, maybe someone else in the group can
offer some pointers and possible sample code. I am a visual learner and
if I see it in the code, I may better understand what Jeff is trying to
explain.

Thanks again Jeff for your help,

[Jeff Dillon]

If you are using Visual Studio, create a new page and drop a FormView on it.
Then double click on it to get to the code behind, and locate ItemInserted
from the function dropdowns

Jeff

"jenileo" <je*****@yahoo. com> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Hi Jeff,

Sounds like you are frustrated with me and I really apologize. I can't
stress enough how new I am to this and I am turning to this group for
support. I appreciate your lead and I will do some reading up on
FormView.itemin serted and see if I can figure this out, (that should
tell you how new I am.) Meanwhile, maybe someone else in the group can
offer some pointers and possible sample code. I am a visual learner and
if I see it in the code, I may better understand what Jeff is trying to
explain.

Thanks again Jeff for your help,

[jenileo]

Thanks for the further explanation. After looking up the information
you provided this solution worked beautifully. I can't believe how much
there is to learn! Thanks again, I greatly appreciate it.