public int SaveDataTable(System.Data.DataTable dt)
{
SQLiteTransaction tran = null;
try
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
string sql = string.Format(@"select * from {0} where 1=2", dt.TableName);
SQLiteCommand cmd = new SQLiteCommand(_Conn);;
SQLiteCommandBuilder comBuilder = new SQLiteCommandBuilder();
comBuilder.DataAdapter = adapter;
cmd.CommandText = sql;
cmd.Connection = _Conn;
adapter.SelectCommand = cmd;
adapter.InsertCommand = comBuilder.GetInsertCommand();
adapter.UpdateCommand = comBuilder.GetUpdateCommand();
adapter.DeleteCommand = comBuilder.GetDeleteCommand();
tran = _Conn.BeginTransaction();//transaction begin 传说中sqlite每执行一条insert语句都开启一个事务，死慢
cmd.Transaction = tran;
int result = adapter.Update(dt);
tran.Commit();//transaction end
return(result);
}
catch (Exception ex)
{
if (tran != null)
{
tran.Rollback();
}
throw ex;
}
}
/// <summary>
/// Load data from database to datagrid
/// </summary>
private void LoadData()
{
try
{
sqlDataAdapter = new SQLiteDataAdapter("Select *, 'Delete' AS [Delete] FROM " + currentTable, SqlConnection);
SqlCommandBuilder = new SQLiteCommandBuilder(sqlDataAdapter);
SqlCommandBuilder.GetInsertCommand();
SqlCommandBuilder.GetUpdateCommand();
SqlCommandBuilder.GetDeleteCommand();
dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet, currentTable);
dataGridView1.DataSource = null;
dataGridView1.DataSource = dataSet.Tables[currentTable];
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewLinkCell linkCell = new DataGridViewLinkCell();
dataGridView1[lastIndexTable, i] = linkCell;
}
dataGridView1.Refresh();
dataGridView1.Update();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void UpdateSellerInfo(int Index)
{
using (SQLiteConnection connection = new SQLiteConnection(Tools.DataTools.getConnectionString))
{
using (SQLiteCommand sqliteCommand = new SQLiteCommand("Select * From OrderedItems", connection))
{
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqliteCommand))
{
connection.Open();
DataRow dRow;
DataSet dSet = new DataSet();
adapter.Fill(dSet);
dRow = dSet.Tables[0].Rows[Form1.SelectedIndex];
dRow[25] = txtbxsellerName.Text;
dRow[26] = txtbxsellerTrackService.Text;
dRow[27] = txtbxExtraInfo.Text;
SQLiteCommandBuilder commBuild;
commBuild = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = commBuild.GetUpdateCommand(true);
adapter.Update(dSet);
}
}
}
}
public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable)
{
string sql = "SELECT * FROM {0};";
string dbSQL = string.Format(sql, table.Name);
string dbConn = ConnectionString;
using (var conn = new SQLiteConnection(dbConn))
{
conn.Open();
var cmd = new SQLiteCommand(dbSQL, conn);
var sdaDatabases = new SQLiteDataAdapter(cmd);
if (editable)
{
var scb = new SQLiteCommandBuilder(sdaDatabases);
sdaDatabases.UpdateCommand = scb.GetUpdateCommand();
sdaDatabases.InsertCommand = scb.GetInsertCommand();
sdaDatabases.DeleteCommand = scb.GetDeleteCommand();
}
var dsDatabases = new DataTable("TableContent");
sdaDatabases.Fill(dsDatabases);
var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases);
query.Adapter = sdaDatabases;
return(query);
}
}
public int Update <T>(DataTable dt)
{
int count = 0;
SQLiteConnection conn = new SQLiteConnection(ConnectionStr);
SQLiteCommand comm = new SQLiteCommand(" select * from " + typeof(T).Name + " limit 1 ", conn);
try
{
conn.Open();
SQLiteTransaction ts = conn.BeginTransaction();
SQLiteDataAdapter dadpter = new SQLiteDataAdapter(comm);
SQLiteCommandBuilder buider = new SQLiteCommandBuilder(dadpter);
dadpter.InsertCommand = buider.GetUpdateCommand();
count = dadpter.Update(dt);
ts.Commit();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(count);
}
public static void UpdateImage(int Index)
{
OrdersInfo = new DataSet();
try
{
using (connection = new SQLiteConnection(ConnectionString))
{
using (SQLiteCommand sqliteCommand = new SQLiteCommand(QueryOrdersShow, connection))
{
connection.Open();
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqliteCommand))
{
DataRow dRow;
adapter.Fill(OrdersInfo);
dRow = OrdersInfo.Tables[0].Rows[Index];
dRow[3] = convertImage(imagePath);
MessageBox.Show("Image Attached");
SQLiteCommandBuilder commBuild;
commBuild = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = commBuild.GetUpdateCommand(true);
adapter.Update(OrdersInfo);
}
}
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void LoadData()
{
SQLiteCommand command = _con.CreateCommand();
command.CommandText = "SELECT MAX(bizonylatszam) FROM befizetesek";
bizonylatszam = Convert.ToInt32(command.ExecuteScalar());
_adapTagok = new SQLiteDataAdapter("SELECT * FROM tagok", _con);
_adapBefizetesek = new SQLiteDataAdapter("SELECT * FROM befizetesek", _con);
SQLiteCommandBuilder _builderTagok = new SQLiteCommandBuilder(_adapTagok);
_adapTagok.InsertCommand = _builderTagok.GetInsertCommand();
_adapTagok.DeleteCommand = _builderTagok.GetDeleteCommand();
_adapTagok.UpdateCommand = _builderTagok.GetUpdateCommand();
SQLiteCommandBuilder _builderBefizetesek = new SQLiteCommandBuilder(_adapBefizetesek);
_adapBefizetesek.InsertCommand = _builderBefizetesek.GetInsertCommand();
_adapBefizetesek.DeleteCommand = _builderBefizetesek.GetDeleteCommand();
_adapBefizetesek.UpdateCommand = _builderBefizetesek.GetUpdateCommand();
_dataSet = new DataSet("befizetesek");
_adapTagok.Fill(_dataSet, "tagok");
_bindingSourceTagok.DataSource = _dataSet.Tables["tagok"];
_dataGridViewTagok.DataSource = _bindingSourceTagok;
_adapBefizetesek.Fill(_dataSet, "befizetesek");
_bindingSourceBefizetesek.DataSource = _dataSet.Tables["befizetesek"];
_dataGridViewBefizetesek.DataSource = _bindingSourceBefizetesek;
FormatTagokTable();
FormatBefizetesekTable();
}
private void UpdateCCInfo()
{
using (SQLiteConnection connection = new SQLiteConnection(Tools.DataTools.getConnectionString))
{
using (SQLiteCommand sqliteCommand = new SQLiteCommand("Select * From OrderedItems", connection))
{
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqliteCommand))
{
connection.Open();
DataRow dRow;
DataSet dSet = new DataSet();
adapter.Fill(dSet);
dRow = dSet.Tables[0].Rows[Form1.SelectedIndex];
dRow[16] = txtbxCCFee.Text;
dRow[17] = txtbxCCDate.Text;
SQLiteCommandBuilder commBuild;
commBuild = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = commBuild.GetUpdateCommand(true);
adapter.Update(dSet);
}
}
}
}
public SQLiteDataAdapter GetDataAdapterSql(string sqlSelect, string sqlUpdate)
{
SQLiteCommand select = new SQLiteCommand(sqlSelect, cnSQL);
SQLiteCommand selectUpdate = new SQLiteCommand(sqlUpdate, cnSQL);
//выявляем параметры в запросе и создаем их в команде
int p = 0;
while (p < sqlSelect.Length)
{
p = sqlSelect.IndexOf('@', p);
if (p < 0)
{
break;
}
int p2;
for (p2 = ++p; p2 < sqlSelect.Length; p2++) //ищем конец имени поля
{
if (!char.IsLetterOrDigit(sqlSelect[p2]))
{
break;
}
}
select.Parameters.Add(new SQLiteParameter(sqlSelect.Substring(p, p2 - p), null));
}
SQLiteDataAdapter da = new SQLiteDataAdapter(selectUpdate);
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(da);
cb.QuotePrefix = "[";
cb.QuoteSuffix = "]";
da.UpdateCommand = cb.GetUpdateCommand();
da.InsertCommand = cb.GetInsertCommand();
da.DeleteCommand = cb.GetDeleteCommand();
da.SelectCommand = select;
return(da);
}
private void button1_Click(object sender, EventArgs e) //修改产品
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("确定要修改该产品数据吗", "提示！", messButton);
if (dr == DialogResult.OK)
{
try
{
SQLiteCommandBuilder scb = new SQLiteCommandBuilder(da);
da.UpdateCommand = scb.GetUpdateCommand();
da.Update(ds, "ProductInfo");
}
catch
{
MessageBox.Show("修改错误！");
return;
}
MessageBox.Show("修改成功！");
}
else
{
return;
}
}
internal void event_CommitDataTableChanges(string tableName, DataTable dataTable)
{
try {
event_OpenConnection();
string query = "SELECT * FROM [" + tableName + "]";
SQLiteDataAdapter dataAdapter;
dataAdapter = new SQLiteDataAdapter(query, connection);
SQLiteCommandBuilder commandBuilder;
commandBuilder = new SQLiteCommandBuilder(dataAdapter);
commandBuilder.QuotePrefix = "[";
commandBuilder.QuoteSuffix = "]";
dataAdapter.DeleteCommand = commandBuilder.GetDeleteCommand();
dataAdapter.UpdateCommand = commandBuilder.GetUpdateCommand();
dataAdapter.InsertCommand = commandBuilder.GetInsertCommand();
dataAdapter.Update(dataTable);
commandBuilder.Dispose();
dataAdapter.Dispose();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public bool SaveDataGrid()
{
try
{
if (connection == null)
{
return(true);
}
dataGridView.CurrentCell = null;
comandBuilder.RefreshSchema();
dataGridView.EndEdit();
if (adapter.InsertCommand == null)
{
adapter.InsertCommand = new SQLiteCommand(" ");
}
if (adapter.UpdateCommand == null)
{
adapter.UpdateCommand = comandBuilder.GetUpdateCommand();
}
if (adapter.DeleteCommand == null)
{
adapter.DeleteCommand = comandBuilder.GetDeleteCommand();
}
adapter.Update(dataSet.Tables[NameTable]);
return(true);
}
catch (Exception e)
{
MessageBox.Show("Ошибка в процессе сохранения данных.\n" + e.Message, "Ошибка");
return(false);
}
}
private void applyButton_Click(object sender, EventArgs e)
{
SQLiteConnection mCN = ConnectionManager.connection;
SQLiteDataAdapter mDA = modulesTableAdapter.Adapter;
SQLiteCommandBuilder mCB = new SQLiteCommandBuilder(mDA);
DataSet mDS = modulesDataSet;
DataSet dsChanges = new DataSet();
if (!mDS.HasChanges())
{
return;
}
dsChanges = mDS.GetChanges(DataRowState.Modified);
if (dsChanges != null)
{
mDA.UpdateCommand = mCB.GetUpdateCommand();
mDA.Update(dsChanges, "modules");
}
dsChanges = mDS.GetChanges(DataRowState.Added);
if (dsChanges != null)
{
mDA.InsertCommand = mCB.GetInsertCommand();
mDA.Update(dsChanges, "modules");
}
dsChanges = mDS.GetChanges(DataRowState.Deleted);
if (dsChanges != null)
{
mDA.DeleteCommand = mCB.GetDeleteCommand();
mDA.Update(dsChanges, "modules");
}
mDS.AcceptChanges();
UpdateModulesDropDown();
(treeView.Model as SlowTreeModel).Root.UpdateModulesFromDbRec();
treeView.Invalidate();
}
public int?UpdateDt(DataTable Dt, string commandText)
{
//if application is exiting the don't perform DB process
if (this.isAppClosing)
{
return(null);
}
if (!DoesDBConnectionExists())
{
return(null);
}
try
{
SQLiteDataAdapter da = new SQLiteDataAdapter(commandText, _connection);
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(da);
da.UpdateCommand = cb.GetUpdateCommand();
da.InsertCommand = cb.GetInsertCommand();
da.DeleteCommand = cb.GetDeleteCommand();
da.Update(Dt);
}
catch (Exception ex)
{
LogTrace.WriteErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Error in query . " + commandText + ex.StackTrace));
throw;
}
finally
{
commandText = string.Empty;
}
return(Dt.Rows.Count);
}
public Form1()
{
InitializeComponent();
var c = Connect();
var da = new SQLiteDataAdapter("select emp_id, emp_firstname, emp_lastname from emp where 1 = 0", c);
var b = new SQLiteCommandBuilder(da);
da.InsertCommand = new SQLiteCommand(
@"insert into emp(emp_firstname, emp_lastname ) values(:_emp_firstname, :_emp_lastname);
select emp_id, emp_firstname, emp_lastname from emp where emp_id = last_insert_rowid();", c);
da.InsertCommand.Parameters.Add("_emp_firstname", DbType.String, 0, "emp_firstname");
da.InsertCommand.Parameters.Add("_emp_lastname", DbType.String, 0, "emp_lastname");
da.InsertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
da.UpdateCommand = b.GetUpdateCommand();
da.DeleteCommand = b.GetDeleteCommand();
var dt = new DataTable();
da.Fill(dt);
var nr = dt.NewRow();
nr["emp_firstname"] = "john";
nr["emp_lastname"] = "lennon";
dt.Rows.Add(nr);
da.Update(dt);
dt.AcceptChanges();
nr["emp_lastname"] = "valjean";
da.Update(dt);
}
/// <summary>
/// DataAdapterのUpdateComandを自動生成
/// </summary>
/// <remarks></remarks>
public void BuildUpdateCommand()
{
//UpdateCommandを作成
SQLiteCommandBuilder sqlCmdBuilder = new SQLiteCommandBuilder(_da);
sqlCmdBuilder.GetUpdateCommand();
}
private static void clearImage(int Index)
{
OrdersInfo = new DataSet();
try
{
using (connection = new SQLiteConnection(ConnectionString))
{
using (SQLiteCommand sqliteCommand = new SQLiteCommand(QueryOrdersShow, connection))
{
connection.Open();
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqliteCommand))
{
DataRow dRow;
adapter.Fill(OrdersInfo);
dRow = OrdersInfo.Tables[0].Rows[Index];
dRow[3] = null;
pcbxPackImage.Image = Properties.Resources.NoImageAvailable;
SQLiteCommandBuilder commBuild;
commBuild = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = commBuild.GetUpdateCommand(true);
adapter.Update(OrdersInfo);
}
}
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
} // ახალი ამანათის დამატების ფუნქცია
public static void deleteRecord(int Index)
{
OrdersInfo = new DataSet();
try
{
using (connection = new SQLiteConnection(ConnectionString))
{
using (SQLiteCommand sqliteCommand = new SQLiteCommand(QueryOrdersShow, connection))
{
connection.Open();
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqliteCommand))
{
adapter.Fill(OrdersInfo);
OrdersInfo.Tables[0].Rows[Index].Delete();
SQLiteCommandBuilder commBuild;
commBuild = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = commBuild.GetUpdateCommand(true);
adapter.Update(OrdersInfo);
MessageBox.Show("Package Removed...");
}
}
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
} // წაშლა
private void button2_Click(object sender, EventArgs e)
{
// ekle liste güncelleme
SQLiteCommandBuilder builder = new SQLiteCommandBuilder(adp);
builder.GetUpdateCommand();
sorulariSil();
adp.Update(dt);
baglanti.Open();
cmd = new SQLiteCommand("UPDATE GvnGenel SET dersGuncelleme=1, eklemeVarmi=1", baglanti);
cmd.ExecuteNonQuery();
cmd.Dispose();
baglanti.Close();
if (dersSilmeDegisiklik == true)
{
//Haftaya programla devre dışı bırakma !
baglanti.Open();
cmd = new SQLiteCommand("UPDATE GvnGenel SET HaftayaProgramlamaPA='Pasif', HPOrtaOkul='Pasif', HPLise='Pasif' WHERE id=1", baglanti);
cmd.ExecuteNonQuery();
cmd.Dispose();
baglanti.Close();
dersSilmeDegisiklik = false;
MessageBox.Show("Güncellendi. Otomatik programla pasif durumuna getirildi. Lütfen aktifleştiriniz.", "Ders Ekle", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
else
{
MessageBox.Show("Güncellendi.", "Ders Ekle", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
public void sync()
{
using (SQLiteCommandBuilder builder = new SQLiteCommandBuilder(m_dataAdapter))
{
//m_dataAdapter.DeleteCommand = builder.GetDeleteCommand(true);
m_dataAdapter.UpdateCommand = builder.GetUpdateCommand(true);
m_dataAdapter.Update(ds);
}
}
public void write()
{
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(_aSQLiteDataAdapter);
cb.QuotePrefix = "[";
cb.QuoteSuffix = "]";
_aSQLiteDataAdapter.InsertCommand = cb.GetUpdateCommand();
_aSQLiteDataAdapter.Update(dataSet);
}
static void Update(string tableName)
{
var adapter = Adapters[tableName];
var commandBuilder = new SQLiteCommandBuilder(adapter);
adapter.DeleteCommand = commandBuilder.GetDeleteCommand(true);
adapter.InsertCommand = commandBuilder.GetInsertCommand(true);
adapter.UpdateCommand = commandBuilder.GetUpdateCommand(true);
adapter.Update(Tables[tableName]);
}
public void Push()
{
var builder = new SQLiteCommandBuilder(_adapter);
_adapter.UpdateCommand = builder.GetUpdateCommand();
_adapter.InsertCommand = builder.GetInsertCommand();
_adapter.DeleteCommand = builder.GetDeleteCommand();
_adapter.Update(LocalDataTable);
}
public override DbDataAdapter CreateAdapter(Table table, TableFilter filter)
{
if (!(table is SQLiteTable))
{
throw new ArgumentException("Table must be of type SQLiteTable", "table");
}
var adapter = new SQLiteDataAdapter(table.GetBaseSelectCommandText(filter), Connection);
if (!table.IsReadOnly)
{
var builder = new SQLiteCommandBuilder(adapter)
{
ConflictOption = ConflictOption.OverwriteChanges
};
SQLiteCommand updateCommand = null;
try {
updateCommand = builder.GetUpdateCommand();
} catch (InvalidOperationException) {
var selectSql = new StringBuilder();
selectSql.Append("SELECT RowId, ");
filter.WriteColumnsProjection(selectSql);
selectSql.Append(" FROM ");
selectSql.Append(table.QuotedName);
adapter = new SQLiteDataAdapter(selectSql.ToString(), Connection);
builder = new SQLiteCommandBuilder(adapter);
updateCommand = builder.GetUpdateCommand();
}
var insertCommand = builder.GetInsertCommand();
foreach (var column in table.Columns)
{
if (column.IsIdentity)
{
insertCommand.CommandText = insertCommand.CommandText + "; SELECT @RowId = last_insert_rowid()";
insertCommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
var parameter = new SQLiteParameter {
ParameterName = "@RowId",
Direction = ParameterDirection.Output,
SourceColumn = column.Name,
SourceVersion = DataRowVersion.Current,
Value = DBNull.Value
};
insertCommand.Parameters.Add(parameter);
break;
}
}
adapter.UpdateCommand = updateCommand;
adapter.InsertCommand = insertCommand;
adapter.DeleteCommand = builder.GetDeleteCommand();
}
return(adapter);
}
private void UpdateDatabase()
{
using (var connection = GetConnection())
{
var query = "select * from features";
var adapter = new SQLiteDataAdapter(query, connection);
var builder = new SQLiteCommandBuilder(adapter);
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.Update(DataTable);
}
}
public SQLiteDataAdapter GetSQLiteAdapter(string SelectCommand)
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter(SelectCommand, this.connection);
SQLiteCommandBuilder cb = new SQLiteCommandBuilder(adapter);
adapter.InsertCommand = cb.GetInsertCommand();
adapter.UpdateCommand = cb.GetUpdateCommand();
adapter.DeleteCommand = cb.GetDeleteCommand();
return(adapter);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
_ad = new SQLiteDataAdapter("select * from students", DB.Connection);
var builder = new SQLiteCommandBuilder(_ad);
_ad.DeleteCommand = builder.GetDeleteCommand();
_ad.InsertCommand = builder.GetInsertCommand();
_ad.UpdateCommand = builder.GetUpdateCommand();
_ad.Fill(_dt);
btnEdit.Enabled = btnRemove.Enabled = _dt.Rows.Count != 0;
listBox1.DataSource = _dt;
listBox1.DisplayMember = "name";
}
private void CveDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
SQLiteCommandBuilder scb = new SQLiteCommandBuilder(mAdapter);
mAdapter.UpdateCommand = scb.GetUpdateCommand();
mAdapter.Update(ds, t_name);
//SelectAll();
//CveDataGridView.Rows[CveDataGridView.Rows.Count - 1].Selected = true;
}
catch (Exception)
{
}
}
public void Update(DataTable dataTable)
{
var query = $"select * from {TableName}";
using (SQLiteConnection connection = GetConnection())
using (var adapter = new SQLiteDataAdapter(query, connection))
using (var commandBuilder = new SQLiteCommandBuilder(adapter))
{
adapter.UpdateCommand = commandBuilder.GetUpdateCommand();
adapter.DeleteCommand = commandBuilder.GetDeleteCommand();
adapter.InsertCommand = commandBuilder.GetInsertCommand();
adapter.Update(dataTable);
}
}
private void LoadData()
{
SQLiteCommand command = _con.CreateCommand();
command.CommandText = "SELECT MAX(kolcson_id) FROM kolcsonzesek";
kolcson_id = Convert.ToInt32(command.ExecuteScalar());
_adapKolcsonzesek = new SQLiteDataAdapter("SELECT * FROM kolcsonzesek WHERE vissza is null", _con);
_adapTagok = new SQLiteDataAdapter("SELECT * FROM tagok", _con);
_adapKonyvek = new SQLiteDataAdapter("SELECT * FROM konyvek", _con);
SQLiteCommandBuilder _builderKolcsonzesek = new SQLiteCommandBuilder(_adapKolcsonzesek);
_adapKolcsonzesek.InsertCommand = _builderKolcsonzesek.GetInsertCommand();
_adapKolcsonzesek.DeleteCommand = _builderKolcsonzesek.GetDeleteCommand();
_adapKolcsonzesek.UpdateCommand = _builderKolcsonzesek.GetUpdateCommand();
SQLiteCommandBuilder _builderTagok = new SQLiteCommandBuilder(_adapTagok);
_adapTagok.InsertCommand = _builderTagok.GetInsertCommand();
_adapTagok.DeleteCommand = _builderTagok.GetDeleteCommand();
_adapTagok.UpdateCommand = _builderTagok.GetUpdateCommand();
SQLiteCommandBuilder _builderKonyvek = new SQLiteCommandBuilder(_adapKonyvek);
_adapKonyvek.InsertCommand = _builderKonyvek.GetInsertCommand();
_adapKonyvek.DeleteCommand = _builderKonyvek.GetDeleteCommand();
_adapKonyvek.UpdateCommand = _builderKonyvek.GetUpdateCommand();
_dataSet = new DataSet("kolcsonzes");
_adapKolcsonzesek.Fill(_dataSet, "kolcsonzesek");
_bindingSourceKolcsonzesek.DataSource = _dataSet.Tables["kolcsonzesek"];
_dataGridViewKolcsonzesek.DataSource = _bindingSourceKolcsonzesek;
_adapTagok.Fill(_dataSet, "tagok");
_bindingSourceTagok.DataSource = _dataSet.Tables["tagok"];
_dataGridViewTagok.DataSource = _bindingSourceTagok;
_adapKonyvek.Fill(_dataSet, "konyvek");
_bindingSourceKonyvek.DataSource = _dataSet.Tables["konyvek"];
_dataGridViewKonyvek.DataSource = _bindingSourceKonyvek;
FormatKolcsonzesekTable();
FormatTagokTable();
FormatKonyvekTable();
}
