MS Access 中的双重插入？
我以某种方式得到了双重插入；每次我提交表单时，它都会向数据库发送两条记录。我不明白发生了什么事。这是我的代码的总体思路：
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
'Data collection'
'Define Connection'
Dim myConn As New OleDbConnection
myConn.ConnectionString = adsGrandmaster.ConnectionString
myConn.Open()
'Insert command'
Dim myIns1 As New OleDbCommand("INSERT INTO tableGrandmaster (date_received, prefix, course_number, title, new, changed, inactivate, end_date, credits, description, hours_lecture, hours_lec_lab, hours_lab, hours_total, related_instruction, repeat, challengeable, in_catalog, in_printed_schedule, core_course, core_name, program_elective, program_name, prereqs, coreqs, recommended, green_course, code, dept_code, division_code, changing_depts, acti_code, grading, general_ed, writing, social_science, math, information_literacy, arts_letters, science_computer, speech_comm, cultural_literacy, date_curriculum_approval, date_state_sent, date_state_approval, date_created) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", myConn)
'Insert parameters'
'Execute command'
myIns1.ExecuteNonQuery()
'Close connection'
myConn.Close()
更新：
.aspx.vb 文件的最后一小部分：
'Execute command'
myIns1.ExecuteNonQuery()
Label1.Text = "Grandmaster submitted."
'Close connection'
myConn.Close()
End Sub
Protected Sub btnBack_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBack.Click
Response.Redirect("./index.htm")
End Sub
End Class
如果我将断点放置在 myIns1.ExecuteNonQuery() 处或之前，则不会插入任何内容。如果我将它放在 myIns1.ExecuteNonQuery() 之后，它会插入一次。如果我将它放在“End Sub”之后（在 myConn.Close() 下），它会插入两次。
I'm somehow getting a double insert; every time I submit the form, it sends two records to the database. I can't figure out what's going on. This is a general idea of what my code looks like:
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
'Data collection'
'Define Connection'
Dim myConn As New OleDbConnection
myConn.ConnectionString = adsGrandmaster.ConnectionString
myConn.Open()
'Insert command'
Dim myIns1 As New OleDbCommand("INSERT INTO tableGrandmaster (date_received, prefix, course_number, title, new, changed, inactivate, end_date, credits, description, hours_lecture, hours_lec_lab, hours_lab, hours_total, related_instruction, repeat, challengeable, in_catalog, in_printed_schedule, core_course, core_name, program_elective, program_name, prereqs, coreqs, recommended, green_course, code, dept_code, division_code, changing_depts, acti_code, grading, general_ed, writing, social_science, math, information_literacy, arts_letters, science_computer, speech_comm, cultural_literacy, date_curriculum_approval, date_state_sent, date_state_approval, date_created) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", myConn)
'Insert parameters'
'Execute command'
myIns1.ExecuteNonQuery()
'Close connection'
myConn.Close()
Update:
The last little piece of my .aspx.vb file:
'Execute command'
myIns1.ExecuteNonQuery()
Label1.Text = "Grandmaster submitted."
'Close connection'
myConn.Close()
End Sub
Protected Sub btnBack_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBack.Click
Response.Redirect("./index.htm")
End Sub
End Class
If I place my breakpoint at or before myIns1.ExecuteNonQuery(), nothing inserts. If I place it after myIns1.ExecuteNonQuery(), it inserts once. If I place it after "End Sub" (under myConn.Close()), it inserts twice.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
确保 aspx:button 声明未连接到前端代码页面以及后端代码页面上的 onclick 事件。
Make sure that the aspx:button declaration is not wired up to the onclick event on the code-in-front page as well as the code behind page.
如果您获得重复插入，则要么是程序在数据库上调用了两次插入，要么是数据库导致了重复（尽管这是值得怀疑的，因为您没有调用可能向您隐藏重复的存储过程）。
由于问题更可能是由于 c# 程序中的插入被调用两次而引起，因此在插入行上添加调试行：
然后在调试模式下运行程序（如果使用 Visual Studio，请按 F5）- 如果插入行运行两次，那么您需要找出原因，并取消其中一个调用。
If you're getting duplicate inserts either the program is calling an insert on the database twice, or the database is causing the duplicate (although this is doubtful as you are not calling a stored procedure that could be hiding the duplication from you).
As the problem is more likely to be caused by the insert in the c# program being called twice add a debug line on your insert line:
Then run your program in debug mode (press F5 in Visual Studio if you are using it) - if the insert line is run twice then you need to work out why, and take away one of the calls.