.Net使用XtraGrid控件绑定数据_基础应用_

DataTable dataTable = new DataTable(); dataTable.Columns.Add("Name", System.Type.GetType("System.String")); dataTable.Columns.Add("Sex", System.Type.GetType("System.String")); dataTable.Columns.Add("Age", System.Type.GetType("System.String")); DataRow row = dt.NewRow(); ; row["Name"] = "mathilda"; row["Sex"] = "loli"; row["Age"] = "12"; dataTable.Rows.Add(row); // 绑定字段 gridView1.Columns[1].FieldName = "Sex"; gridView1.Columns[2].FieldName = "Age"; gridView1.Columns[0].FieldName = "Name"; gridControl1.DataSource = dataTable;

gridView2.PopulateColumns();

/// 
 /// 更改 /// 
 ///  ///  private void btEdit_Click(object sender, EventArgs e) { Person p = (Person)gridView1.GetRow(gridView1.FocusedRowHandle); } /// 
 /// 删除 /// 
 ///  ///  private void btDelete_Click(object sender, EventArgs e) { if (gridView1.SelectedRowsCount != 0) gridView1.DeleteSelectedRows(); MessageBox.Show(people.Count.ToString()); }

if (gridView1.SelectedRowsCount > 0) { gridView1.DeleteSelectedRows(); gridView.UpdateCurrentRow() }

public override object GetRowCellValue(int rowHandle, GridColumn column);

public void SetRowCellValue(int rowHandle, GridColumn column, object _value);

int englishS=Convert.ToDouble(0,gridView1.Columns["English"])+60; SetRowCellValue(0,gridView1.Columns["English"],englishS);

if (gridView1.IsValidRowHandle(gridView1.FocusedRowHandle))

DataRow Row = gridView1.GetFocusedDataRow();

**Entity entity = gridView1.GetFocusedRow() as **Entity;

string Code = gridView1.GetFocusedRowCellValue("Code").ToString(); string Code = gridView1.GetRowCellValue(e.FocusedRowHandle, "Code")

if (bandedGridView1.GetFocusedDataRow() == null) return;//判断当前选中行是否为null //返回值 var columnValue= bandedGridView1.GetFocusedRowCellValue("绑定列字段名称").ToString();

// 动态添加列 DevExpress.XtraGrid.Columns.GridColumn Col1 = new DevExpress.XtraGrid.Columns.GridColumn(); Col1.FieldName = "Name"; Col1.Caption = "名字"; Col1.Visible = false; Col1.VisibleIndex = gvCountry.Columns.Count; gvCountry.Columns.Add(Col1);

private void Form1_Load(object sender, System.EventArgs e) { // ... gridControl1.ForceInitialize(); // Create an unbound column. GridColumn unbColumn = gridView1.Columns.AddField("Total"); unbColumn.VisibleIndex = gridView1.Columns.Count; unbColumn.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // Disable editing. unbColumn.OptionsColumn.AllowEdit = false; // Specify format settings. unbColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; unbColumn.DisplayFormat.FormatString = "c"; // Customize the appearance settings. unbColumn.AppearanceCell.BackColor = Color.LemonChiffon; } // Returns the total amount for a specific row. decimal getTotalValue(int listSourceRowIndex) { DataRow row = nwindDataSet.Tables["Order Details"].Rows[listSourceRowIndex]; decimal unitPrice = Convert.ToDecimal(row["UnitPrice"]); decimal quantity = Convert.ToDecimal(row["Quantity"]); decimal discount = Convert.ToDecimal(row["Discount"]); return unitPrice * quantity * (1 - discount); } // Provides data for the Total column. private void gridView1_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e) { if (e.Column.FieldName == "Total" && e.IsGetData) e.Value = getTotalValue(e.ListSourceRowIndex); }

RepositoryItemComboBox repositoryItemComboBox_abc=new RepositoryItemComboBox(); // // 对编辑器进行设置 // this.gridColumn1.ColumnEdit = repositoryItemComboBox_abc; //在需要的列里使用定义好的编辑器