避免在ASP.net中重复插入数据 [英] Avoid Duplication of Data insertion in ASP.net

问题描述

你好帮手，

我正在做ASP.net应用程序.

我有一页要从用户收集数据并将数据保存到数据库中.

当我单击保存按钮时，所有数据都被成功保存，但是当我刷新该页面时，条目被保存了两次.

如何避免在页面刷新上插入重复项.

谢谢.

Hello helpers,

I am Doing ASP.net application.

I have one page on which I am collecting data from user and saving data into database.

When I click on save button all data is successfully saved but when I Refresh that Page the entries are saved twice.

How could I avoid insertion of Duplicate entries on Page Refresh.

Thanks.

推荐答案

最好的方法是在插入数据之前检查数据是否已经在数据库中.

另外，您可以在插入数据后(例如在sessionvariable中)设置标志，并在保存之前(再次)检查该标志.

Best way would be to check if the Data is already in your database before you insert it.

Also you could set a Flag after inserting your data (for example in a sessionvariable) and check for this flag before you save (again).

好问题！得到我的5.

有一种代码为此处的解决方案 [ ^ ]-我还没有尝试过，但是这个主意听起来不错.

Good question! Get''s my 5.

There is a solution with code here[^] - I haven''t tried it, but the idea seems sound.

嗨尼丁·布瓦特:rose :,

:thumbsdown:

1.只要您要插入数据，就可以验证输入数据" a. (脚本通过..(JavaScript或其他任何语言.))

2.每当您要插入数据时，请清除值.

注意:验证是最好的解决方案...

Hi nitin bhoyate :rose:,

:thumbsdown:

1. whenever u will insert the data, then you validate the input data''a. (Script via..(javascript or anything..))

2. whenever u will insert the data then, Clear the values.

Note: validation is the best solution...

这篇关于避免在ASP.net中重复插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！