private void FillGrid()
{
//if a sheet is selected, remember it
long selectedSheetNum = 0;
if (gridMain.GetSelectedIndex() != -1)
{
selectedSheetNum = PIn.Long(table.Rows[gridMain.GetSelectedIndex()]["SheetNum"].ToString());
}
gridMain.BeginUpdate();
gridMain.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g(this, "Date"), 70);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Time"), 42);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Kiosk"), 55, HorizontalAlignment.Center);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Description"), 210);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Image Category"), 120);
gridMain.Columns.Add(col);
gridMain.Rows.Clear();
ODGridRow row;
table = Sheets.GetPatientFormsTable(PatNum);
for (int i = 0; i < table.Rows.Count; i++)
{
row = new ODGridRow();
row.Cells.Add(table.Rows[i]["date"].ToString());
row.Cells.Add(table.Rows[i]["time"].ToString());
row.Cells.Add(table.Rows[i]["showInTerminal"].ToString());
row.Cells.Add(table.Rows[i]["description"].ToString());
row.Cells.Add(table.Rows[i]["imageCat"].ToString());
gridMain.Rows.Add(row);
}
gridMain.EndUpdate();
if (selectedSheetNum != 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i]["SheetNum"].ToString() == selectedSheetNum.ToString())
{
gridMain.SetSelected(i, true);
break;
}
}
}
}
