(1) Use of DEV control GridControl
1. Confirm the input of the cell currently editing this.gridView1.closeEditor ();
2, save the value of the current row to the data source this.gridView1.Updatecurrentrow ();
3. Update the modification to the database SqlDataAdapter1.Update (MyDataSet, "MyTable") / / can be executed directly by DataAPter.
Follow the steps performed 1,2,3; may be achieved by steps 1 and 2 initialize and (2) DataGrid by Sql gridView1.OptionsView.EnableAppearanceEvenRow = true; gridView1.OptionsView.EnableAppearanceOddRow = true; gridView1.OptionsView.ShowFilterPanel = false ; gridView1.OptionsView.ShowGroupPanel = false; gridView1.OptionsView.ShowGroupPanel = false; gridView1.OptionsSelection.EnableAppearanceFocusedCell = false; gridView1.OptionsBehavior.Editable = false; gridView1.OptionsCustomization.AllowColumnMoving = false; gridView1.OptionsCustomization.AllowColumnResizing = false; gridView1 .Optionscustomization.allowgroup = false; gridowfilter = false; GridView1.OptionScustomization.allowsort = true; (3) Get the contents of the selected row and the selected line
int
[] A
=
THIS
.gridview1.getSelectedRows ();
//
Pass the entity class to get the selected line
Laa.assetguid
=
THIS
.gridview1.getrowcellvalue (a [
0
],
"
AskGUID
"
.Tostring ();
//
Get the contents of the selected line
(4) The mutual calls of the Button control are button1_click (null, evenetargs.empty); DEV control is simpleButton1_Click (New Object (), New Eventargs ()); (5) How to XTRID Verify that the value of the cell We verify if the value of each cell is correct in the case of XtraGrid directly entering the data. There are two ways to implement a cell-based verification: 1. "Sender" using the repositoryItem.validating event event must be converted to the BaseEdit type, use EditValue to get the current input value and check, if the verification is not passed, E.CANCEL Setting true. This method is generally used to perform data verification of the cells of the built-in control 2. Use the "Sender" of the GridView.validAnGeditor event event to be converted to a GridView type, and the current column can be obtained from the GridView.FocusedColumn property, the value can be obtained from E.Value If the verification is not passed, you need to set the E.valid to false.. This approach is generally used to verify the text box within the entire grid. You need to write a GridView.INValidValueException event devices after setting the event: for example: Private
Void
GridView1_INValidValueException
Object
Sender, defexpress.xtragrid.views.base.invalidValueExceptionEventArgs e)
{E.THROWEXCEPTION = false; E.WindowText = "The new value is invalid. Please correct it or press esc to abandon your change."; E.displayerror = true;}
(6) Barmanager's specific settings After adding the Barmanager control, select [Click Here to Tool Bar] in [Click Here to Tool Bar] [Click Here to Tool Bar] to fill in the toolbar button that needs to be added. Designer into the inside, select ToolBars -> Custom 1-> OptionsBar inside the following settings: AllowQuickCustomization = falseDrawDragBorder = falseRotateWhenVertical = falseUseWholeRow = True 4 above initial setting items (7) which increase the status bar DataGrid StaticText first increases in the new inside BarManager The additional BarstaticItem's AutoSize is set to Spring and then write the following code:
Private
Void
STATECOTE ()
{IF (GridView1.Rowcount! = 0) {INT A = this.gridview1.rowcount; barstaticItem1.caption = "Current a total of records:" a.tostring (); int [] b = this.gridView1.getSelectedRows (); B [0] = 1; BarsTaticItem2.caption = "Currently:" b [0] .tostring ();} else {barStaticItem1.caption = "Current record:"; barstaticItem2.caption = "Current:" }} Private
Void
GridControl1_click
Object
Sender, System.EventArgs E)
{Statecote ();
Private
Void
GridView1_focusedrowChanged (
Object
Sender, deVexpress.xtragrid.views.base.focusedrowChangeDeventargs E)
{Statecote ();
(8) DateTable fills DataGrid References here:
Using
DevexPress.Utils;
/ ** /
///
Private
Void
DisposedDataGrid (DataTable DT)
{// center the title gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = HorzAlignment.Center; this.gridControl1.DataSource = dt; gridView1.Columns [0] .Visible = false; // exception log GUID gridView1.Columns [1]. Visible = false; // Passage GridView1.columns [2] .visible = false; // Channel number GridView1.Columns [3] .caption = "channel name"; GridView1.columns [3] .width = 100; GridView1. Column [4] .caption = "card number"; GridView1.columns [4] .width = 100; GridView1.columns [5] .caption = "cardholder name"; GridView1.columns [5] .width = 60; GridView1 .Columns [6] .caption = "Master card number"; GridView1.columns [6] .width = 100; GridView1.columns [7] .caption = "Main Cardroom"; GridView1.columns [7] .width = 60; GridView1.columns [8] .caption = "Pass Time"; GridView1.Columns [8] .width = 100; GridView1.columns [9] .caption = "license plate number"; Gridview1.columns [9] .width = 60; GridView1.columns [// Image Guid GridView1.columns [11] .caption = "Abnormal Description"; GridView1.columns [11] .width = 100; GridView1.Columns [12] .caption = "Processing Results"; GridView1.Columns [12] .width = 100; GridView1.columns [13] .visible = false; // ImageID // can be sorted by GridView1.OptionScustomization.Allowsort = True;} where there is a collection time type
GridView1.columns [
3
] .Caption
=
"
Operating time
"
GridView1.columns [
3
] .Width
=
200
GridView1.columns [
3
] .Unboundtype
=
Devexpress.Data.UnboundColumnType.Datetime; GridView1.columns [
3
] .DisplayFormat.FormatString
=
"
Fly
"
GridView1.columns [
3
] .DisplayFormat.FormatType
=
Formattype.datetime;
(9) Double-click DataGrid pop-up details
Private
Void
GridControl1_doubleclick
Object
Sender, System.EventArgs E)
{// Double-click the pop-up exception log description IF (this.gridView1.rowcount> 0) {int [] a = this.gridView1.getSelectedRows (); string str_guid = this.gridView1.GetrowcellValue (a [0], "EX_no") .Tostring (); // Get an exception number messagebox.show (str_guid); frMexceptionLogDesc DLG = new fmExceptionLogDesc (); DLG.Text = "Exception log view"; dlg.showdialog ();}}