public object ExecuteScalar(string query, DBHelperConnectionState connectionState) { return ExecuteScalar(query, CommandType.Text, connectionState); }
public DbDataReader ExecuteReader(string query, DBHelperConnectionState connectionState) { return ExecuteReader(query, CommandType.Text, connectionState); }
public object ExecuteScalar(string query, CommandType commandType, DBHelperConnectionState connectionState) { objCommand.CommandText = query; objCommand.CommandType = commandType; object o = null; try { if (objConnection.State == System.Data.ConnectionState.Closed) objConnection.Open(); o = objCommand.ExecuteScalar(); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionState == DBHelperConnectionState.CloseOnExit) objConnection.Close(); } return o; }
public DbDataReader ExecuteReader(string query, CommandType commandType, DBHelperConnectionState connectionState) { objCommand.CommandText = query; objCommand.CommandType = commandType; DbDataReader reader = null; try { if (objConnection.State == System.Data.ConnectionState.Closed) objConnection.Open(); if (connectionState == DBHelperConnectionState.CloseOnExit) reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); else reader = objCommand.ExecuteReader(); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); } return reader; }
public int ExecuteNonQuery(string query, DBHelperConnectionState connectionState) { return ExecuteNonQuery(query, CommandType.Text, connectionState); }
public int ExecuteNonQuery(string query, CommandType commandType, DBHelperConnectionState connectionState) { objCommand.CommandText = query; objCommand.CommandType = commandType; int i = 0; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } i = objCommand.ExecuteNonQuery(); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionState == DBHelperConnectionState.CloseOnExit) { objConnection.Close(); } } return i; }
public DataSet ExecuteDataSet(string query, DBHelperConnectionState connectionState) { return ExecuteDataSet(query, CommandType.Text, connectionState); }
public DataSet ExecuteDataSet(string query, CommandType commandType, DBHelperConnectionState connectionState) { DbDataAdapter adapter = objFactory.CreateDataAdapter(); objCommand.CommandText = query; objCommand.CommandType = commandType; adapter.SelectCommand = objCommand; DataSet ds = new DataSet(); try { adapter.Fill(ds); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionState == DBHelperConnectionState.CloseOnExit) { if (objConnection.State == System.Data.ConnectionState.Open) { objConnection.Close(); } } } return ds; }