Molio bih nekog da mi pomogne ako zna ja sam TOTALNO zablokirao...
Naime, imam jedan DataGridView koji se sledecim kodom puni iz SQLite baze:
Code (vbnet):
Dim results As DataSet = New DataSet
Dim database As String = path_to_db
Dim datasource As SQLite.SQLiteConnectionStringBuilder = New SQLite.SQLiteConnectionStringBuilder()
datasource.Add("Data Source", database)
datasource.Add("Version", "3")
datasource.Add("New", "False")
datasource.Add("Compress", "False")
Dim connection As SQLite.SQLiteConnection = New SQLite.SQLiteConnection(datasource.ConnectionString)
Dim adapter As SQLite.SQLiteDataAdapter = New SQLite.SQLiteDataAdapter("SELECT * FROM Table;", connection)
adapter.Fill(results)
dgw_table.Columns.Clear()
dgw_table.DataSource = Nothing
dgw_table.DataSource = results.Tables(0).DefaultView
Dim results As DataSet = New DataSet
Dim database As String = path_to_db
Dim datasource As SQLite.SQLiteConnectionStringBuilder = New SQLite.SQLiteConnectionStringBuilder()
datasource.Add("Data Source", database)
datasource.Add("Version", "3")
datasource.Add("New", "False")
datasource.Add("Compress", "False")
Dim connection As SQLite.SQLiteConnection = New SQLite.SQLiteConnection(datasource.ConnectionString)
Dim adapter As SQLite.SQLiteDataAdapter = New SQLite.SQLiteDataAdapter("SELECT * FROM Table;", connection)
adapter.Fill(results)
dgw_table.Columns.Clear()
dgw_table.DataSource = Nothing
dgw_table.DataSource = results.Tables(0).DefaultView
E sad, ja u programu imam nekoliko TextBox-ova pomocu kojih punim nove podatke u bazu i tabelu (prvo u bazu pa onda uradim samo refrash tabele) ali sada zelim nesto drugo, sada zelim da mi se podaci negde prvo privremeno smestaju pa da se tek onda snimaju u bazu kada korisnik zavrsi unos nekoliko redova.
Ima li neko ideju kako ovo da resim?
Zaista nemam ideju.
Prvo sam mislio klasicnim dodavanjem preko .AddRow da dodajem podatke u DataGridView a da prethodno zapamtim koliko je vec redova bilo unutra i onda samo ove nove redove da sacuvam u bazu ali ne mogu to da radim jer mi se javlja greska:
Citat:
Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.
Onda sam mislio da napravim skriveni DataGridView koju cu puniti podacima ali ne znam kako da ga spojim sa prvim ni da li ce to tako raditi...