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);
}
