检查INSERT INTO语句是否成功

本文介绍了检查INSERT INTO语句是否成功的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我使用MS Access数据库作为我的VB.NET应用程序的后端。我使用INSERT INTO语句将用户详细信息输入数据库：

cn = New OleDbConnection（Provider = Microsoft.Jet。 OLEDB.4.0; Data Source =& config（DatabasePath）&;） cn.Open（） cmd = New OleDbCommand（INSERT INTO blah blah blah ... ，cn） dr = cmd.ExecuteReader

一切正常，但我想检查数据实际上已输入到数据库中。我尝试使用：

cn = New OleDbConnection（Provider = Microsoft.Jet.OLEDB.4.0; Data Source =& ; config（DatabasePath）&;） cn.Open（） cmd = New OleDbCommand（INSERT INTO blah blah blah ...，cn） dr = cmd.ExecuteReader 如果dr.Read（）then 'Blah 结束如果

但显然insert语句不返回任何东西，所以这不工作。任何建议？

解决方案

如果您拥有的是INSERT语句，您可以使用 ExecuteNonQuery（）

$

cmd = New OleDbCommand（INSERT INTO blah blah ...，cn） rowCount = cmd.ExecuteNonQuery（）如果rowCount < 1 Then 'Blah

如果VB不正确，我没有测试，但我希望你能得到这个想法。

I am using a MS Access database as the backend of my VB.NET application. I am entering users details into the database using an INSERT INTO statement:

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";") cn.Open() cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn) dr = cmd.ExecuteReader

Everything works, but I wanted to check if the data has actually been entered into the database. I have tried using:

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";") cn.Open() cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn) dr = cmd.ExecuteReader If dr.Read() Then ' Blah End If

but obviously the insert statement doesn't return anything so this doesn't work. Any suggestions?

解决方案

If all you have is the INSERT statement you can use the ExecuteNonQuery() method which returns how many rows were affected.

Like this:

cmd = New OleDbCommand("INSERT INTO blah blah...", cn) rowCount = cmd.ExecuteNonQuery() If rowCount < 1 Then ' Blah

You have to excuse me if the VB isn't correct, I didn't test it, but I hope you get the idea.