private void loadGrid()
{
dataGridView1.AutoGenerateColumns = false;
DataTable dt = new DataTable();
dt.Columns.Add("Title", typeof(String));
dt.Columns.Add("Document name", typeof(String));
dt.Columns.Add("Start page", typeof(String));
dt.Columns.Add("End page", typeof(String));
DataGridViewTextBoxColumn startPage = new DataGridViewTextBoxColumn();
startPage.Width = 70;
startPage.HeaderText = "Start Page";
startPage.DataPropertyName = "Start Page";
DataGridViewTextBoxColumn endPage = new DataGridViewTextBoxColumn();
endPage.Width = 70;
endPage.HeaderText = "End Page";
endPage.DataPropertyName = "End Page";
DataGridViewComboBoxColumn documentName = new DataGridViewComboBoxColumn();
DataTable dtList = SQLiteDatabaseCommand.dataList("tblDocument");
dtList.Columns.Remove(dtList.Columns[0]);
dtList.Columns.Remove(dtList.Columns[1]);
int x = 0;
List <string> items = new List <string>();
foreach (DataRow row in dtList.Rows)
{
items.Add(dtList.Rows[x][0].ToString());
x++;
}
documentName.DataSource = items;
documentName.Width = 200;
documentName.HeaderText = "Document Name";
documentName.DataPropertyName = "DocumentName";
DataGridViewTextBoxColumn title = new DataGridViewTextBoxColumn();
title.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
title.HeaderText = "Title";
title.DataPropertyName = "Title";
dataGridView1.DataSource = dt;
dataGridView1.Columns.AddRange(title, documentName, startPage, endPage);
}
private void loadData()
{
try
{
DataTable dt = SQLiteDatabaseCommand.dataList("tblDocument");
dt.Columns.Remove(dt.Columns[0]);
dt.Columns.Remove(dt.Columns[1]);
dataGridView1.DataSource = dt;
}
finally
{
dataGridView1.Refresh();
}
}