Forms Data Controls :: Stop FormView Inserting SQL Data Again On Page Refresh?
Jun 15, 2010
I am using an ObjectDataSource in my FormView for INSERT.
Data inserts correctly to my backend SQL table, however as i am posting back a success/fail message to the same page, i have noticed that after a successful INSERT if it hit the Refresh button the INSERT is doubled up.
How can i stop a user pressing the Refresh button and doubling the INSERT?
Is there a setting somewhere or can i stop this programmatically within my ObjectDataSource_Inserting method perhaps?
View 3 Replies
Similar Messages:
Jun 14, 2010
I have created a simple dataset with my ObjcetDataSource to my SQL table named Invoices and a new FormView. My form inserts are working 100% correctly, however after some testing i noticed the insert happens again if i hit the refresh button on my browser after an initial insert. I am currently submitting the form back to itself with a success/fail message returned on the page so that the user can keep inserting more records if they choose. This is done in my Inserted behaviour.
In my ObjectDataSource_Inserting code i am setting the values of a date prior to my insert. How do i stop a second INSERT from happening when the user refreshes the browser? I thought it was what IsPostBack was used for? Here is my code:
[Code]....
View 2 Replies
Jun 30, 2010
I am using an application called "SAFE" from ASP. This application using for enter the aircraft and personal injury accident.
Once we enter all the details and click the submit button. The next page will open and show the message details like report number.
Report Number will generate depend on sequence.
If you press F5 or refresh in the same page, get the pop up message "Retry" or "Cancel".
If click the retry button, the same input details is saving and generating the next sequence report number.
View 2 Replies
Jul 29, 2010
i want my gridView to be refreshed so i can vies the new records when i insert to formview.
Now i have to go to another address and back to se the updated record.
i cant even press f5 because then it just duplicates the record with the same text from the formview even if the fields in the formview are empty.
There is got to be a code for this!?
View 2 Replies
May 21, 2010
I have a strange issue with the FormView. After working through some issues getting the update to work (as this is my first experience with FormViews) I now have a new issue. After I perform an update, and the FormView updates and returns to read mode, if I hit F5 (refresh) the FormView performs another update to the datasource, despite the fact it is read-only mode and none of the fields on the screen are editable.
I would think that a refresh in read mode for the FormView after an edit would simply refresh the data from the database, not perform another update. Again, the FormView is in Read Only Mode, but a refresh is creating another Update event (which I can debug and see if I break in the ItemUpdating event). This only happens after I perform an edit, not when the page initially loads.
View 2 Replies
Jun 24, 2010
I Am working on payment gateway integration, i am storing whole information about the transaction on page load event. so when i press refresh button then Duplicate data is again inserting in database So i want to stop this.
I want to do like
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Here I Am Using My Function For Insert Or Update Database
}
}
View 6 Replies
Nov 16, 2010
The subject says it all really. I have a DetailsView which inserts records into a SQL database. It works fine.
When I refresh the page (F5 for instance), I get a dialogue saying such action will resend the data. If I click OK here, the daa does indeed get sent again resilting in duplicate records in my database.
How can I stop data being resent if the page is refreshed?
View 8 Replies
Aug 12, 2010
Here is the scenerio:I have a radtabstrip (with 2 tabs) at the top of my page followed by radMultiPage control Tab 1 displays pageview 1 which has a gridview showing data from our database and allows for selection or deletion of data tab 2 displays a detailsview when gridview_selectedindexchanged(from tab 1) is fired.Problem... If you select an entry in the gridview it switech the page and the detailsview into editmode (works fine) but if you then click on tab 1 without clicking update or cancel in the detailsview, the data is updated. This is what i don't want as the user has basically abandoned the changes.So what i need is a what to say ... if the detailsview is in edit or insert when the tabstrip is clicked then cancel the insert or update. I tried switching it back to readonly mode but that did not seem to work.
View 2 Replies
Jun 2, 2010
I have a web page with a gridview & formview (master/detail relationship) combo. On page load the gridview shows all records from a SQL table. On my page I have a button that when clicked shows the formview in Insert mode to allow users to add a new record to the data. I have also added a column to my gridview that has a link. When a user clicks this link it hides the gridview and shows the formview in edit mode with the detail from the record selected from the gridview.
In my formview I am using a listbox control to allow users to select multiple values. The choices in the listbox are populated by a SQL data table. I have successfully written code to post the selected listbox values to my SQL data field during Insert. When the user selects a record to edit I have code in the databound event to select values in the listbox from the choices based on the value in the sql data field. This works as well. My problem is that I cannot figure out the correct code to update my SqL data when a user is editing the record and makes changes to the selected listbox value. I have included my design code for my listbox in my formview edittemplate and also my behind code that I have attempted.
<td
style="width: 454px">
<asp:ListBox
ID="lbox_ConstructionType"
runat="server"
DataSourceID="SqlDataConstructionTypes"
DataTextField="Construction_Type"
DataValueField="Construction_Type"
SelectionMode="Multiple"
Width="144px"></asp:ListBox>
<asp:TextBox
ID="tbox_Ctype"
runat="server"
Text='<%# Bind("ConstructionTypeID") %>'></asp:TextBox></td>
[Code]....
View 9 Replies
Sep 20, 2010
I am using a formview to show data, with edit, insert and delete enabled. My problem is with the insert.When i click the insert, the formview changes fine to the template for inserting new data, the problem is it was allowing the user to insert the ID themselves, I have made this readonly, but how would i go about ensuring the ID key is made the next number in line? and that it is printed to this textbox?
View 1 Replies
Sep 12, 2010
This FormView is inserting two records instead of just one.
[Code]....
[Code]....
View 1 Replies
Feb 10, 2010
I have a FormView in default insert mode.
When I inserted item to database, the Form refresh and return to all blank or standard selection.
What can I do if I want it keeps the last entered value after inserting record ?
I need this because there are many items to insert and only partial fields need changes from last entered records.
View 3 Replies
Mar 11, 2011
I'm joining 2 tables and using the formview. When I insert a record, I need to place the value of the max id + 1 of the second table in a field in the first table so that the tables are linked. I'm not sure where to put the value. I try to put it in the insert command and I've tried the select command but that doesn't work.
Table 1 - Product: ID, ProductNum, Brand, Description
Table2 - Brand: ID, BrandName
(Brand from Table1 is linked to ID from Table 2)
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [Product] ..."
InsertCommand="INSERT INTO [Product] ([productNum], [Brand] VALUES (@productNum, @Brand)"
SelectCommand="SELECT Product.ID, Product.Brand, Product.Description, Brand.ID, Brand.BrandName From Product INNER JOIN Brand ON Product.Brand= Brand.ID"
UpdateCommand="UPDATE [Product] SET [productNum] = @productNum, [Brand] = @Brand ......"
I've Tried InsertCommand="INSERT INTO [Product] ([productNum], [Brand] VALUES (@productNum, MAX(@Brand.ID) +1)"
or setting BrandID =Max(@Brand)
View 2 Replies
Oct 11, 2010
When page load it is invisible. I have a button1 onclick make it visible and people can input data the press insert. I set it invisible right in Formview Insert eventhandler code.
When people click that button1 again to add 2nd record the form appear again as desired. However, the data from 1st record is still there.
What code I can make in eventhandler to make sure when button1 is clicked the Formview does not contain any data from last entry ?
The formview clear the data from 1st record if I did not set visible/invisible.
View 2 Replies
Nov 7, 2010
I have a formview and inside it there are two textboxes taking integer as input.I put a condition that if both textboxes are empty then user should be notified that "Please put value in any one of the textbox".It is working very fine.From database side DBA checked that if user input any integer value in any one of the two textboxes and if it is already found in database then there is no insertion.The problem is that everything is working fine and i checked in the database that the record is also not inerting due to duplicate check but user is getting message that "Record inserted successfully."How to stop this message and how to notify user that you have entered duplicate value and transaction should also not been done. Means all inputs should be there rather than clearing textboxes that could be done when "Record Inserted."
[Code]....
View 1 Replies
Apr 20, 2010
I am trying to add a validation of the textbox.text.length in a FormView and prevent the insertion of being made in case the text length is not compliant (less than four characters).
In the scenario when clicking the submit button an Alert should appear with xxxx warinig text. and the Insert command being prevented.
This is my FormView Insert Template:
[Code]....
View 5 Replies
Jan 22, 2011
I'm having a problem with a FormView control that I have bound to an ObjectDataSource. The problem is that the FormView control is not automatically filled in with the public properties of the object linked by an ObjectDataSource control when I select refresh schema. Everything compiles and I can add fields manually, but there are a lot of properties in the class and I do not want to deal with adding all the fields by hand. It's not the end of the world of course if I have to add them manually, but I'm bothered more by the fact that it doesn't act the other formviews.
Has anyone ever experienced a problem like this? I have other objectdatasource controls with other formviews that properly refresh their schemas. I noticed that in the objectdatasource control that is giving me problems, the DataObjectTypeName field is not automatically set as it is in the others. However, after adding it manually it still doesn't refresh the schema. I'm using Visual Studio 2010. Defined in .aspx page:
[Code]....
The SPFModuleBLL class contains the GetModule2() method which is shown here:
[Code]....
View 3 Replies
Jul 13, 2010
I am doing a management system . What i am trying to accomplish is that when a user fill form relevant to management system the data should go into respective tables.How to accomplish this.I am using primary keys and foreign keys
View 3 Replies
Apr 7, 2010
I have a data grid and i click the data grid button the page refresh.I dont use Update Panal.I m working a shopping Cart website and i have a datagrid. Data grid has a Add to cart Button.When i click this button the page is Refresh. i want the page is not refresh
View 5 Replies
Nov 3, 2010
I have a table on my page. I need to scroll down a little to get to that table. In that table i have som data that i edit and save to database. When the save is done i need to refresh the page( Response.Redirect(Request.RawUrl )) so it loads the new data to that table. When the refresh is done the page is on top again so that i need to scroll down again to see the table. This makes it very unusable for the user.
How can i refresh the page without it going back to top again? I tryed wrapping an updatepanel around the table but it didnt
View 1 Replies
Jun 8, 2010
Up till the moment I can not understand why the "SqlDataSource_NewAccount_Inserting" event of the formview's SqlDataSource is not firing!
The code inside the event handler is not executed, even the debugger does not stop on break points inside the "SqlDataSource_NewAccount_Inserting" function!
Here is my code:
[Code]....
[Code]....
I am using VS2010 and target .NET Framework 3.5.
View 2 Replies
May 14, 2010
I have a page with a series of Gridviews to display summarised information. There a three Gridviews which need to be selected as criteria and then a Go Button is clicked to retrieve the info.
At the moment the information is retreived as the dropdowns are selected. Can this be stopped until the user clicks GO?
View 1 Replies
Jan 11, 2010
How can i refresh(Asych) the contents of my Datalist on the parent page from a data change in a page that is displayed in an iFrame on the parent page.
I have movie names with image in the data list that is on parent page.
there another page is openend in the parent pages in an iFrame control.
in that sub page i upload image and other data related to a new movie.
What i want is that when i submit that information in an iFrame page, the DataList should update(Asych) itself on the parent page showing new updated info.
the structure is like;
[code]...
View 1 Replies
Oct 28, 2012
I've a function named fillgrid() which fills the grid with data.This function works correctly on pageload,but after inserting into database i've called this function again, which is not getting executed.This issue happens only in real time server not in my local system,I'm not getting any error and i cannot recognize why fillgrid() function is not getting called??I've used update panel.This is the code for insert function which inserts over 500records.
DataTable dtMob = new DataTable();
dtMob = dtMobilizn.Copy();
DataSet dsMobilizn=new DataSet("dsMobilization");
[code]....
View 1 Replies
Feb 15, 2011
I have a gridview that has allowPaging and AllowSorting set to true. It is bound to a sqldatasource with the selectCommand firing a sql query. The sqldatasource has EnableCaching = true, and caching duration = "60". The idea is to run the paging, sorting, etc from the cache.
A separate dataUpdate event updates the data that is being loaded in the grid view, but I am not able to see the change in the gridview data till 30 seconds (caching duration) .
What is the best way to force refresh the gridview data by the dataUpdate event?
I came across this artice that tells to use CacheKeyDependency, but when I implemented it, the gridview gets refreshed at every dataUpdate event, but also the paging and sorting fires the sqldatasource Selectcommand sql query. I want this query to be fired only on dataUpdate.
View 1 Replies
