Insertion to DB while page refreshing

Question

0.00/5 (No votes)

See more:

Hi all

In my asp.net project i use following code after Insert statement to avoid the problem of re insertion of values to DB while refreshing the page

C#

Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);

is there any other method , because this method is not suitable in some pages.

Posted 13-Dec-13 0:07am

Praveen_P

Add a Solution

2 solutions

Solution 2

Hi Praveen,

If you want to do it in asp.net then you can refer here[^]
If you want to check it in DB side then you can use EXISTS function like this

SQL

IF NOT EXISTS(SELECT ID FROM InsertTableName WHERE ID = 'ID you want to insert')
BEGIN
INSERT INTO InsertTableName VALUES(101,'Name');
ELSE
Print 'Record already exist'

Hope this helps you a bit.

Regards,
RK

Posted 13-Dec-13 0:16am

♥…ЯҠ…♥

Comments

thatraja 13-Dec-13 8:12am

Agree this alternative but OP should implement this with solution 1, that way could reduce headaches.
5!

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)

Tom Marvolo Riddle · Accepted Answer · 2013-12-13T00:15:00

Yes there are few options.please see this links:

http://csharpdotnetfreak.blogspot.com/2008/12/detect-browser-refresh-to-avoid-events.html[^]
Detecting Refresh or Postback in ASP.NET[^]
http://www.aspdotnet-suresh.com/2010/04/detect-browser-refresh-to-avoid-events.html[^]
http://forums.asp.net/t/1885490.aspx[^]
Refresh Page Issue in ASP.Net[^]

and see previous answers of this sort of question

Detect Browser Refresh and avoid Events fire in ASP.Net[^]
Avoid button click event on page refresh[^]
problem form click refresh button of browser than again btn click event fire[^]