public void FillCombo(dynamic cbo) { try { using (var state = new Connection_SQLite()) { state.OpenConnection = true; var list = new Dictionary <string, string>(); var command = new SQLiteCommand(Query, (SQLiteConnection)state.GetConnex); var result = command.ExecuteReader(); if (result.HasRows) { list["0"] = "<Pilih Satu>"; while (result.Read()) { list[result.GetValue(0).ToString()] = result.GetString(1); } } else { list["0"] = "<Pilih Satu>"; } state.CloseConnection = (SQLiteConnection)state.GetConnex; cbo.ItemsSource = null; cbo.Items.Clear(); cbo.ItemsSource = list; cbo.DisplayMemberPath = "Value"; cbo.SelectedValuePath = "Key"; cbo.SelectedIndex = 0; } } catch (Exception e) { Console.WriteLine("ERROR: CBO.FillComboRecord at " + e.StackTrace); } }
public bool ExecuteUpdate() { using (var state = new Connection_SQLite()) { state.OpenConnection = true; Console.WriteLine(Query); var command = new SQLiteCommand(Query, (SQLiteConnection)state.GetConnex); command.ExecuteNonQuery(); state.CloseConnection = (SQLiteConnection)state.GetConnex; } return(true); }
public void Report(string srctable, out DataSet dataset) { using (var state = new Connection_SQLite()) { state.OpenConnection = true; var data = new DataSet(); var command = new SQLiteCommand(Query, (SQLiteConnection)state.GetConnex); var adapter = new SQLiteDataAdapter() { SelectCommand = command }; adapter.Fill(data, srctable); dataset = data; state.CloseConnection = (SQLiteConnection)state.GetConnex; } }
public object Report(string srctable) { var data = new DataSet(); using (var state = new Connection_SQLite()) { state.OpenConnection = true; var command = new SQLiteCommand(Query, (SQLiteConnection)state.GetConnex); var adapter = new SQLiteDataAdapter() { SelectCommand = command }; adapter.Fill(data, srctable); state.CloseConnection = (SQLiteConnection)state.GetConnex; } return(data); }
public List <T> ExecuteQuery <T>(Func <dynamic, T> Entity) where T : class { var datalist = new List <T>(); try { using (var state = new Connection_SQLite()) { state.OpenConnection = true; var command = new SQLiteCommand(Query, (SQLiteConnection)state.GetConnex); var result = command.ExecuteReader(); if (result.HasRows) { while (result.Read()) { datalist.Add(Entity(result)); } } state.CloseConnection = (SQLiteConnection)state.GetConnex; } } catch (Exception e) { Console.WriteLine("ERROR: RDBMS.RetrievingData at " + e.StackTrace); } return(datalist); }