private void LoadData() { int index = 0; foreach (DataColumn dataCol in dataTable.Columns) { DevExpress.XtraGrid.Columns.GridColumn column = new DevExpress.XtraGrid.Columns.GridColumn(); column.AppearanceCell.Options.UseTextOptions = true; if (dataCol.DataType.Name.IndexOf("STRING", StringComparison.OrdinalIgnoreCase) != -1) { column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None; } else { column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; } column.Caption = dataCol.Caption; column.FieldName = dataCol.ColumnName; column.Name = "datacol" + index.ToString(); column.Visible = true; column.VisibleIndex = index; this.grdView.Columns.Add(column); index++; } grItems.DataSource = dataTable; if (selectedDataRow != null) { grdView.FocusedRowHandle = grdView.GetRowHandle(dataTable.Rows.IndexOf(selectedDataRow)); } }
private void setParentFormtxx(DbOpt.InFoDlg info_dlg) { if (info_dlg.dlgObj == null || info_dlg.dlgSqlMainWindow == null || info_dlg.dlgSqlMainWindow.Trim() == "") { return; //主窗口未传入的sql为空不操作 } DevExpress.XtraGrid.Views.Grid.GridView gridview = (DevExpress.XtraGrid.Views.Grid.GridView)info_dlg.dlgObj; DataTable dtParentTmp = (DataTable)gridview.GridControl.DataSource; DataRow datarow = null; if (info_dlg.dlgKind == DbOpt.OpenWindowKind.Open) { #region 找记录 dtParentTmp.PrimaryKey = new DataColumn[] { dtParentTmp.Columns["PATHWAY_ID"] }; datarow = dtParentTmp.Rows.Find(lbl_id.Text); if (datarow == null) { return; } else { info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow); } #endregion } else { datarow = dtParentTmp.NewRow(); } if (datarow != null) { DataRow drCur = null; DataTable dtTmp = DbOpt.GetDataTable(info_dlg.dlgSqlMainWindow + " and PATHWAY_ID='" + info_dlg.pKey1 + "'"); if (dtTmp.Rows.Count > 0) { drCur = dtTmp.Rows[0]; } for (int i = 0; i < dtTmp.Columns.Count; i++) { datarow[i] = drCur[i]; } if (info_dlg.dlgKind != DbOpt.OpenWindowKind.Open) { dtParentTmp.Rows.Add(datarow); info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow); //dtParentTmp.Rows.Count - 1; //this.BindingContext[dtParentTmp].Position = info_dlg.dlgdtPosition; } int rowhandle = gridview.GetRowHandle(info_dlg.dlgdtPosition); if (gridview.GetRowExpanded(rowhandle) == false) { gridview.ExpandAllGroups(); } gridview.FocusedRowHandle = rowhandle; } }
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle) { if (view == null) { return; } view.DeleteRow(view.GetRowHandle(rowhandle)); view.RefreshData(); }
private void gridItemListView_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { GridView view = sender as GridView; //int rowIndex = e.RowHandle; if (e.Column.Name == "colRowNo") { int rowIndex = view.GetRowHandle(e.ListSourceRowIndex); e.DisplayText = (rowIndex + 1).ToString(); } }
private bool SelectRowByColumnValue(int columnNumber, string value) { if (value == null) { return(false); } var column = grdView.Columns[columnNumber]; for (int i = 0; i < grdView.RowCount; i++) { if (String.Equals(grdView.GetRowCellValue(i, column).ToString(), value, StringComparison.OrdinalIgnoreCase)) { grdView.FocusedRowHandle = grdView.GetRowHandle(i); const int pageSize = 17; // 17 is page size. // If select item from very first half of the page then do not do anything. // if selected item is on the last page bottom half of the page then put last item at the bottom of the grid to make it full. // Show selected item in the middle of the grid in mid pages. if (grdView.FocusedRowHandle > (pageSize / 2) && grdView.RowCount > pageSize) { // Is last page bottom half? if ((grdView.RowCount - (pageSize - 1) / 2) < grdView.FocusedRowHandle) { // fill last page. grdView.TopRowIndex = grdView.RowCount - pageSize; } else { // show selected item in the middle. grdView.TopRowIndex = grdView.FocusedRowHandle - pageSize / 2; } } return(true); } } return(false); }
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle) { if (view == null) { return; } view.DeleteRow(view.GetRowHandle(rowhandle)); ////int[] rows = gridView1.GetSelectedRows(); //int[] g = view.GetSelectedRows(); //DataRow[] rows = new DataRow[view.SelectedRowsCount]; //for (int i = 0; i < view.SelectedRowsCount; i++) // rows[i] = view.GetDataRow(view.GetSelectedRows()[i]); //view.BeginSort(); //try //{ // foreach (DataRow row in rows) // row.Delete(); //} //finally //{ // view.EndSort(); //} view.RefreshData(); }
private void btnMemberCard_Print_Click(object sender, System.EventArgs e) { if (gridViewMemberCard.SelectedRowsCount != 0) { openFileDialog1.Filter = "Access Files ( *.mdb )| *.mdb"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { string s = openFileDialog1.FileName; OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + s); OleDbCommand aCommand = new OleDbCommand("Insert Into tblMemberCard(Membership_ID,Member_Name,Branch_ID) values (@Membership_ID,@Member_Name,@Branch_ID)", aConnection); aCommand.Connection = aConnection; aConnection.Open(); DataRow row = gridViewMemberCard.GetDataRow(gridViewMemberCard.FocusedRowHandle); string MembershipId; string MembershipName; string BranchId; int Id; for (int i = 0; i < gridViewMemberCard.SelectedRowsCount; i++) { Id = Convert.ToInt32(gridViewMemberCard.GetSelectedRows().GetValue(i)); row = gridViewMemberCard.GetDataRow(gridViewMemberCard.GetRowHandle(Id)); MembershipId = (row["strMembershipId"]).ToString(); MembershipName = (row["strMemberName"]).ToString(); BranchId = (row["strBranchCode"]).ToString(); aCommand.Parameters.Add(new OleDbParameter("@Membership_ID", MembershipId)); aCommand.Parameters.Add(new OleDbParameter("@Member_Name", MembershipName)); aCommand.Parameters.Add(new OleDbParameter("@Branch_ID", BranchId)); aCommand.ExecuteNonQuery(); aCommand.Parameters.Clear(); int output; output = 0; SqlHelper.ExecuteNonQuery(connection, "up_tblCardRequest", new SqlParameter("@retval", output), new SqlParameter("@nStatusID", 1), new SqlParameter("@dtLastEditDate", DateTime.Now), new SqlParameter("@nEmployeeID", ((row["nEmployeeID"]).ToString()) == "" ? DBNull.Value.ToString() : (row["nEmployeeID"]).ToString()), new SqlParameter("@nRequestID", (row["nRequestID"]).ToString()) ); // cmdToExecute.Parameters.Add(new SqlParameter("@" + column[i], (value[i]==null) ? DBNull.Value : value[i])); SqlHelper.ExecuteNonQuery(connection, "up_tblMember", new SqlParameter("@retval", output), new SqlParameter("@nCardStatusID", 1), new SqlParameter("@strCardBranchCode", "HQ"), new SqlParameter("@strMembershipID", MembershipId) ); } MessageBox.Show("Print Successfully!", "Print Message"); MemberCardInit(); aConnection.Close(); } } else { MessageBox.Show("Please select at least one member!", "Print Message"); } }