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