public DataSet GetCategory(string Category, string TableName) { DataSet DS = new DataSet(); DBParameterCollection paramcollection = new DataAcess.DBParameterCollection(); paramcollection.Add(new DBParameter("@Category", Category)); paramcollection.Add(new DBParameter("@TableName", TableName)); return(_DBHelper.ExecuteDataSet("GetCategory", paramcollection, CommandType.StoredProcedure)); }
public DataSet GetIncentiveTariff(string QCat, string TableName) { DataSet DS = new DataSet(); DBParameterCollection paramcollection = new DataAcess.DBParameterCollection(); paramcollection.Add(new DBParameter("@Category", QCat)); //paramcollection.Add(new DBParameter("@ID", ID)); paramcollection.Add(new DBParameter("@TableName", TableName)); return(_DBHelper.ExecuteDataSet("GetIncentiveTariff", paramcollection, CommandType.StoredProcedure)); }
/// <summary> /// Executes the Sql Command and returns the DataReader. /// </summary> /// <param name="commandText">Sql Command</param> /// <param name="con">Database Connection object (DBHelper.GetConnObject() may be used)</param> /// <param name="paramCollection">Parameter to be associated with the Sql Command or Stored Procedure.</param> /// <returns>DataReader</returns> public IDataReader ExecuteDataReader(string commandText, IDbConnection con, DBParameterCollection paramCollection) { return(ExecuteDataReader(commandText, con, paramCollection, CommandType.Text)); }
/// <summary> /// Executes the Sql Command and return resultset in the form of DataTable. /// </summary> /// <param name="commandText">Sql Command</param> /// <param name="paramCollection">Parameter collection to be associated with the Command.</param> /// <returns>Result in the form of DataTable</returns> public DataTable ExecuteDataTable(string commandText, DBParameterCollection paramCollection) { return(ExecuteDataTable(commandText, string.Empty, paramCollection, CommandType.Text)); }
/// <summary> /// Executes the Sql Command and return resultset in the form of DataSet. /// </summary> /// <param name="commandText">Sql Command </param> /// <param name="paramCollection">Parameter collection to be associated with the command</param> /// <returns>Result in the form of DataSet</returns> public DataSet ExecuteDataSet(string commandText, DBParameterCollection paramCollection) { return(ExecuteDataSet(commandText, paramCollection, CommandType.Text)); }
/// <summary> /// Executes Sql Command and returns number of rows effected. /// </summary> /// <param name="commandText">Sql Command</param> /// <param name="paramCollection">Parameter Collection to be associated with the command</param> /// <returns>Number of rows effected.</returns> public int ExecuteNonQuery(string commandText, DBParameterCollection paramCollection) { return(ExecuteNonQuery(commandText, paramCollection, CommandType.Text)); }
/// <summary> /// Executes the Sql Command and returns result. /// </summary> /// <param name="commandText">Sql Command</param> /// <param name="paramCollection">Parameter collection to be associated.</param> /// <returns>A single value. (First row's first cell value, if more than one row and column is returned.)</returns> public object ExecuteScalar(string commandText, DBParameterCollection paramCollection) { return(ExecuteScalar(commandText, paramCollection, CommandType.Text)); }