请问,为什么使用OleDbCommand.ExecuteNonQuery()插入一条记录,插入成功后,返回值还是为0?
private static void PrepareCommand(OleDbCommand cmd,CommandType cmdType,string cmdText,OleDbParameter[] cmdParms)
{
cmd.CommandType = cmdType;
cmd.CommandText = cmdText;
if (cmdParms != null)
foreach (OleDbParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
public static int ExecuteNonQueryByTransaction(String connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{
int val = 0;
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand cmd = conn.CreateCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
OleDbTransaction trans = conn.BeginTransaction();
try
{
PrepareCommand(cmd, cmdType, cmdText, commandParameters);
cmd.Transaction = trans;
val = cmd.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
cmd.Parameters.Clear();
conn.Close();
conn.Dispose();
trans.Dispose();
cmd.Dispose();
}
return val;
}
{
cmd.CommandType = cmdType;
cmd.CommandText = cmdText;
if (cmdParms != null)
foreach (OleDbParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
public static int ExecuteNonQueryByTransaction(String connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{
int val = 0;
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand cmd = conn.CreateCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
OleDbTransaction trans = conn.BeginTransaction();
try
{
PrepareCommand(cmd, cmdType, cmdText, commandParameters);
cmd.Transaction = trans;
val = cmd.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
cmd.Parameters.Clear();
conn.Close();
conn.Dispose();
trans.Dispose();
cmd.Dispose();
}
return val;
}
...全文
相关推荐
asp.net OleDbCommand 的用法
asp.net下OleDbCommand的使用代码
vs 2005 中连接access并插入记录
这是我自已试过的VS2005中连接access数据库并向其中插入一条记录的操作
详细讲解C#在向ACCESS中插入数据时判断数据是否已存在.pdf
比较详细的介绍了C#用SQL语句insert向ACCESS数据库插入数据时判断,数据是否已经在数据库中存在,如果不存在则继续插入。
使用VB.NET对ACCESS数据库进行添加,删除,插入,修改,查询等用法
使用VB.NET对ACCESS数据库进行添加,删除,插入,修改,查询等用法,有解释 实例,帮助初学者理解,可以相互交流
C连接数据库和插入、删除、更新数据库.pdf
C连接数据库和插入、删除、更新数据库.pdf


