public DataTable ExecuteDataTable(string query, CommandType commandtype, ConnectionState connectionstate) { DbDataAdapter adapter = objFactory.CreateDataAdapter(); objCommand.CommandText = query; objCommand.CommandType = commandtype; adapter.SelectCommand = objCommand; DataTable dt = new DataTable(); try { adapter.Fill(dt); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionstate == ConnectionState.CloseOnExit) { if (objConnection.State == System.Data.ConnectionState.Open) { objConnection.Close(); } } } return(dt); }
public DbDataReader ExecuteReader(string query, CommandType commandtype, ConnectionState connectionstate) { objCommand.CommandText = query; objCommand.CommandType = commandtype; DbDataReader reader = null; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } if (connectionstate == ConnectionState.CloseOnExit) { reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); } else { reader = objCommand.ExecuteReader(); } } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); } return(reader); }
public object ExecuteScalar(string query, CommandType commandtype, ConnectionState 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 == ConnectionState.CloseOnExit) { objConnection.Close(); } } return(o); }
public int ExecuteNonQuery(string query, CommandType commandtype, ConnectionState connectionstate) { objCommand.CommandText = query; objCommand.CommandType = commandtype; int i = -1; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } i = objCommand.ExecuteNonQuery(); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionstate == ConnectionState.CloseOnExit) { objConnection.Close(); } } return(i); }
public DataTable ExecuteDataTable(string query, ConnectionState connectionstate) { return(ExecuteDataTable(query, CommandType.Text, connectionstate)); }
public DbDataReader ExecuteReader(string query, ConnectionState connectionstate) { return(ExecuteReader(query, CommandType.Text, connectionstate)); }
public object ExecuteScalar(string query, ConnectionState connectionstate) { return(ExecuteScalar(query, CommandType.Text, connectionstate)); }
public int ExecuteNonQuery(string query, ConnectionState connectionstate) { return(ExecuteNonQuery(query, CommandType.Text, connectionstate)); }