/// <summary> /// 执行返回查询第一行第一列内容命令 /// </summary> /// <param name="strSql">sql语句</param> /// <param name="cmdType">命令字符串类型,如text,StoredProcedure</param> /// <param name="cmdParms">命令执行参数</param> /// <returns>返回查询结果中的第一行第一列</returns> public object ExecuteScalar(String strSql, CommandType cmdType, SqlParameter[] cmdParms) { SqlCommand cmd = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms); object oReturn = null; try { oReturn = cmd.ExecuteScalar(); } catch (SqlException e) { throw e; } finally { } return(oReturn); }
/// <summary> /// 执行 非查询 sql语句(插入,删除,修改等) /// </summary> /// <param name="strSql">sql语句</param> /// <param name="cmdType">命令字符串类型,如text,StoredProcedure</param> /// <param name="cmdParms">命令执行参数</param> /// <returns>返回命令影响行数 返回-1时命令出错</returns> public int ExecuteNonQuery(String strSql, CommandType cmdType, SqlParameter[] cmdParms) { SqlCommand cmd = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms); int nReturn = -1; try { nReturn = cmd.ExecuteNonQuery(); } catch (SqlException e) { throw e; } finally { } return(nReturn); }
/// <summary> /// 执行查询命令 根据Select SQL语句填充DataSet /// </summary> /// <param name="strSql">sql语句</param> /// <param name="cmdType">命令字符串类型,如text,StoredProcedure</param> /// <param name="cmdParms">命令执行参数</param> /// <param name="table">需填充的DataSet</param> /// <returns>返回DataSet中数据行数; 返回-1时查询命令出错</returns> public int FillDataSet(String strSql, CommandType cmdType, SqlParameter[] cmdParms, DataSet dataset) { SqlDataAdapter da = new SqlDataAdapter(); int nRow = -1; try { da.SelectCommand = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms); nRow = da.Fill(dataset); } catch (SqlException e) { throw e; } finally { da.Dispose(); } return(nRow); }