您所在位置：主题：关于数据库操作中的几个参数问题
小hei
[专家分：730] 发布于 2007-07-05 16:09:00
//执行SQL语句无回返值
public override void exeSql(string strSql, string[] strParams, object [] strValues)
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = this.conn;
if (inTransaction)
cmd.Transaction = trans;
if ((strParams != null) && (strParams.Length !=strValues.Length))
throw new ParamValueNotMatchException("查询参数和值不对应!");
cmd.CommandText = this.ChangeQueryString(strSql);
if (strParams != null)
{
for (int i = 0; i < strParams.Length; i++)
cmd.Parameters.Add(strParams[i], strValues[i]);
}
cmd.ExecuteNonQuery();
}
//请问参数:string[] strParams, object [] strValues的涵义
//ParamValueNotMatchException是系统类里的吗?
//运行时提示:cmd.Parameters.Add(strParams[i], strValues[i]);已过时
public override void exeSql(string strSql, string[] strParams, object [] strValues)
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = this.conn;
if (inTransaction)
cmd.Transaction = trans;
if ((strParams != null) && (strParams.Length !=strValues.Length))
throw new ParamValueNotMatchException("查询参数和值不对应!");
cmd.CommandText = this.ChangeQueryString(strSql);
if (strParams != null)
{
for (int i = 0; i < strParams.Length; i++)
cmd.Parameters.Add(strParams[i], strValues[i]);
}
cmd.ExecuteNonQuery();
}
//请问参数:string[] strParams, object [] strValues的涵义
//ParamValueNotMatchException是系统类里的吗?
//运行时提示:cmd.Parameters.Add(strParams[i], strValues[i]);已过时
