private void LoadSchoolRecord() { //그리드속성 SchoolGrid.AutoGenerateColumns = false; SchoolGrid.AllowUserToAddRows = false; SchoolGrid.MultiSelect = true; SchoolGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect; SchoolGrid.RowHeadersWidth = 15; SchoolGrid.ColumnHeadersHeight = 20; SchoolGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); SchoolGrid.RowsDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "학년", "grade", true, 60); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "국어", "sch_korean", true, 60); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "영어", "sch_english", true, 60); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "수학", "sch_math", true, 60); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "평균", "total_avg", true, 60); UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "등급컷", "cut", true, 70); SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC(); DataSet ds = DAC.GetSchoolRecordAvg(lblStudentID.Text); SchoolGrid.DataSource = ds.Tables[0]; SchoolGrid.ClearSelection(); DAC.Dispose(); }
/// <summary> /// 数据绑定 /// </summary> private void BindGrid() { string sortField = SchoolGrid.Columns[SchoolGrid.SortColumnIndex].SortField; string sortDirection = SchoolGrid.SortDirection; DataTable table = GetSchoolInfoDateTable(); DataView TableView = table.DefaultView; TableView.Sort = String.Format("{0} {1}", sortField, sortDirection); SchoolGrid.DataSource = TableView; SchoolGrid.DataBind(); }
/// <summary> /// 行绑定事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SchoolGrid_OnPreRowDataBound(object sender, FineUI.GridPreRowEventArgs e) { LinkButtonField lbf = SchoolGrid.FindColumn("Schooledit") as LinkButtonField; DataRowView row = e.DataItem as DataRowView; string schoolno = row[0].ToString(); lbf.OnClientClick = WindowEdit.GetShowReference("SchoolEdit.aspx?flag=edit&id=" + schoolno + "", "校区编辑"); LinkButtonField lbfx = SchoolGrid.FindColumn("Schooldelete") as LinkButtonField; DataRowView rowx = e.DataItem as DataRowView; string schoolnox = rowx[0].ToString(); lbfx.OnClientClick = WindowDelete.GetShowReference("../SystemSet/DeletePassword.aspx?Type=School&id=" + schoolnox + "", "校区删除"); }