asp.net - Avoid duplicate data when using asp:control to insert -
i have asp.net code, use insert , view data *.mdb file.
when reload browser reload, insert same old data.
<asp:detailsview id="detailsview1" runat="server" autogeneraterows="false" datakeynames="user_id" datasourceid="accessdatasource1" height="50px" width="125px" defaultmode="insert"> <fields> <asp:boundfield datafield="user_id" headertext="user_id" insertvisible="false" readonly="true" sortexpression="user_id" /> <asp:boundfield datafield="user_name" headertext="user_name" sortexpression="user_name" /> <asp:boundfield datafield="user_pass" headertext="user_pass" sortexpression="user_pass" /> <asp:boundfield datafield="user_email" headertext="user_email" sortexpression="user_email" /> <asp:commandfield buttontype="button" showinsertbutton="true" /> </fields> </asp:detailsview> <div id="div1" runat="server"></div> <asp:accessdatasource id="accessdatasource1" runat="server" datafile="~/app_data/esn.mdb" selectcommand="select * [user]" insertcommand="insert [user] ([user_name], [user_pass], [user_email]) values (@user_name, @user_pass, @user_email)"> <insertparameters> <asp:parameter name="user_name" type="string" /> <asp:parameter name="user_pass" type="string" /> <asp:parameter name="user_email" type="string" /> </insertparameters> </asp:accessdatasource> <asp:gridview id="gridview1" runat="server" autogeneratecolumns="false" datakeynames="user_id" datasourceid="accessdatasource1"> <columns> <asp:boundfield datafield="user_id" headertext="user_id" insertvisible="false" readonly="true" sortexpression="user_id" /> <asp:boundfield datafield="user_name" headertext="user_name" sortexpression="user_name" /> <asp:boundfield datafield="user_pass" headertext="user_pass" sortexpression="user_pass" /> <asp:boundfield datafield="user_email" headertext="user_email" sortexpression="user_email" /> </columns> </asp:gridview> </form>
i think sendig user success insert page option!
try here:
or here:
asp.net - prevent duplicate(double) inserts when page refreshed
how prevent duplicate record insertion on refresh click in browser in asp.net ?
here microsoft article:
Comments
Post a Comment