private DbDataSet.BOOK_MASTERDataTable SelectBookMaster() { string path = @"../../../Library.db"; using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + path)) { DbDataSet.BOOK_MASTERDataTable table = new DbDataSet.BOOK_MASTERDataTable(); try { SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = "SELECT * FROM BOOK_MASTER"; cmd.CommandType = CommandType.Text; cmd.Connection = conn; SQLiteDataAdapter adapter = new SQLiteDataAdapter(cmd); adapter.Fill(table); } catch (SQLiteException ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(table); } }
/// <summary> /// データソースを設定します /// </summary> /// <param name="source"></param> public void SetDataSource(DbDataSet.BOOK_MASTERDataTable source) { dataSource = Mapping(source); binding.DataSource = dataSource; binding.DataMember = string.Empty; dataGridView1.DataSource = binding; binding.ResetBindings(false); }
private ViewDataSet.ViewDataTableDataTable Mapping(DbDataSet.BOOK_MASTERDataTable source) { ViewDataSet viewSource = new ViewDataSet(); var viewTable = viewSource.ViewDataTable; foreach (var row in source) { var viewRow = viewTable.NewViewDataTableRow(); viewRow.BOOK_ID = row.BOOK_ID; viewRow.BOOK_NAME = row.BOOK_NAME; viewRow.ARRIVAL_USER_ID = row.ARRIVAL_USER_ID; viewRow.ARRIVAL_DATE = row.ARRIVAL_DATE; viewRow.DIVISION_ID1 = row.DIVISION_ID1; viewRow.DIVISION_ID2 = row.DIVISION_ID2; viewRow.DIVISION_ID3 = row.DIVISION_ID3; viewRow.MODIFY_FLAG = "0"; viewTable.AddViewDataTableRow(viewRow); } return(viewTable); }