Web Forms :: Redirect After Submit To Sql Database?
Apr 19, 2010
I am trying to redirect the user to another page after they submit a form which posts to a sql 2005 database. I found the response.redirect but I can't get it to work.
Here is my code behind:
Partial
Class
Default2
Inherits System.Web.UI.Page
Protected
Sub FormView1_PageIndexChanging(ByVal
sender As
Object,
ByVal e
As System.Web.UI.WebControls.FormViewPageEventArgs)
Handles FormView1.PageIndexChangingEnd
Sub
Protected
Sub SqlDataSource1_Selecting(ByVal
sender As
Object,
ByVal e
As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
Handles SqlDataSource1.SelectingEnd
Sub
End
Protected
Sub Page_Load(ByVal
sender As
Object,
ByVal e
As System.EventArgs)
Handles
Me.LoadEnd
Sub
Class
How to add code to redirect my user on successful submit to my database.
Code...
Imports System.Data Imports System.Data.SqlClient Partial Class CPD_OnlineSurvey Inherits System.Web.UI.Page Public Sub UpdateOnlineSurvey(ByVal sender As Object, ByVal e As EventArgs) Using conn As New SqlConnection() conn.ConnectionString = ConfigurationManager _ .ConnectionStrings("wincts").ConnectionString Using cmd As New SqlCommand() cmd.CommandText = "update OnlineSurvey set IsSelected = " & _ "@IsSelected where QuestionId=@QuestionId" cmd.Connection = conn conn.Open() For Each item As ListItem In ChkOnlineSurvey.Items cmd.Parameters.Clear() cmd.Parameters.AddWithValue("@IsSelected", item.Selected) cmd.Parameters.AddWithValue("@QuestionId", item.Value) cmd.ExecuteNonQuery() Next conn.Close() End Using End Using End Sub End Class
after filling the form show message to user that account has been created which is not a big deal and after that show him a message that you will be redirected in 5 second... now redirection i need to be done using javascript...not META TAG..
I'm trying to insert few values to a table, when i press the submit button the aspx page goes blank and i don't get any error message. I'm not able to find where the error is.
The code:
Protected Sub AddMInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddMInfo.Click
I need to send some parameters to an external website using the <asp:HiddenField /> controls and also at the same time, submit data to a sql server database. The part for submitting the data to the database is working, but I need to try to get the parameters from the hiddenfields to also be passed through. I thought all I had to do is create the hidden fields and in the code behind, set the values from the textboxes that the user would fill out.
My source code is below:
[code]...
What am I missing? The hidden fields are losing their value before posting to the external website. I've looked everywhere to see why this won't work.
Initially I am doing validating form by clicking on btnOK and in btn_Submit I am inserting record into table. I again want to call btn_Ok event in btn_Submit click event for re-checking validation, if it validates properly thne rest of code of btn_submit should work.
I have a webform set up in such a way that it reads in a query string from the URL and uses that to adjust its LinqDataSource to accordingly display the relevant (specific) post.
So for example if someone does:
[URL]
They'll get the full post whose ID equals 4 displayed in front of them. Here is my current setup:
Default.aspx >> All Posts Listed Here Details.aspx >> No Posts Displayed Here
Details.aspx?post={postID of type Integer} >> the post with that specific post ID will be displayed.
I want a user to click the title of a post on { Default.aspx } and be redirected to { Details.aspx?post=X } where X = the postID. Here is the code I have:
[Code]....
I am getting an error saying: The name Container does not exist in the current context.
When users submits data, I want to send an automatic e-mail acknowledging their submission. Below is the code I am running now, which basically submits data into the DB.
I need to submit all the CheckBoxList values on this page to a SQL database. It needs to submit if checked or if not checked. how I should code this in my code behind page?
used Ajax.BeginForm for form submitting.For the fields I want to show watermark if there is no data in database.But on submitting watermarks are saved in database.
I have an employee list in MSSQL. I have an online punch clock. In the DB there is a column called punch_clock. I would like to redirect a user to a different page if there is a 0 in this column. I have the code below so far. Not sure where to go from here.
I have followed a tutorial and got a shopping cart working with some products in my database.
It uses the querystring to add the items to the cart on a different page. What i would like to do is submit the items in the cart to the database, if anyone would be able to guide me into doing that it would be great.
i have this form, that the data is stored in a SQL db using Linq.
my question is, how can i add a column, that will have all the information about the sender, meaning IP address, browser, referrer etc.
the thing is is i want to store it in one field. i come from a php knowledge that has been long forgotten by me, but i still remember there was some serialize command, that you could run on an array and store it in a db, then when you want it back to an array you would just run deserialize command and it would go back to an array.
really new to the programming scene. writing a program so when i select an item from a drop down list i click the submit button and i want it to display the items selected from the database in a gridview. so in short i want to select an item click submit and i want it to display the information from the database.
I have 5 link buttons in my asp page, i want to change the text property of the each of the link button to the data retrieved from my database table in th page load. To be more specific i want to display 5 latest film news headings in my home page and if the user clicks on a particular news heading i want to show that news details in a separate page with all the details related to that news.
In ASP.NET when we have multiple input section with required field validator (Like on header for login with userid & Password is required and second on footer for subscription) when we click on subscription login section's userid required field validator activates and say userid required & i can not submit subscription.
when i submit subscription details login section should not have concern with this. how to avoid this conflicts.
if ((Request.QueryString["UbytovaniePrispevokID"].ToString()) == "")[code]......
What i want to do is.. I have one main page with new posts Each subject of the new post is the link to Another page where is Specific post and coments and user can leave a coment.
What I want is when the Request.QueryString["UbytovaniePrispevokID"].ToString()) == "" or null I want to redirect to error page ...
Cascading dropdown is works fine but i need to assign a url in Go button based on the second dropdownn selection.
I have two dropdowns. First one has product category and second one has brands. Each brand has seperate html page. So i hve added one more column urls in sql server table. but i dont know how to assign those url in GO button.
and I have Admin.aspx page in this page I have EnterBTN Button and 2 Textbox TxtBeh and TxtPass here users enter Behcode and Password and when they click on EnterBTN Button it go to other page below is EnterBTN Event code
here if users enter correct Behcode and password it go to Manager.aspx page...I want if users enter correct behcode and password if their T_name was =Store it go to Manager.aspx page And if their T_name was Estate it go to Estate.aspx page.
I am using Visual Studio 2010 C# with SQL database. I have a web form that has Textbox, CheckBoxList, and FileUpload controls. When a user click on "Submit" Button, the data is sent to a table in the SQL database.What is the code behind the "Submit" button? And how can I do it?
