原創(chuàng)|其它|編輯:郝浩|2012-10-19 17:42:28.000|閱讀 421 次
概述:在本示例中,假設XtraGrid網(wǎng)格已被綁定到NWIND數(shù)據(jù)庫的[Order Details]表中。grid 網(wǎng)格中包含 "Quantity", "UnitPrice" 和 "Discount" 列,并且這幾列已被綁定到數(shù)據(jù)庫表的相應字段中。下面的例子主要演示如何為gird網(wǎng)格添加一個非綁定列,從而顯示根據(jù)Quantity*UnitPrice*(1-Discount)公式計算出來的每個訂單的金額。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
在本示例中,假設XtraGrid網(wǎng)格已被綁定到NWIND數(shù)據(jù)庫的[Order Details]表中。grid 網(wǎng)格中包含 "Quantity", "UnitPrice" 和 "Discount" 列,并且這幾列已被綁定到數(shù)據(jù)庫表的相應字段中。下面的例子主要演示如何為gird網(wǎng)格添加一個非綁定列,從而顯示根據(jù)Quantity*UnitPrice*(1-Discount)公式計算出來的每個訂單的金額。
代碼如下:
using DevExpress.XtraGrid.Views.Base; using DevExpress.XtraGrid.Columns; 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); }
Imports DevExpress.XtraGrid.Views.Base Imports DevExpress.XtraGrid.Columns Private Sub Form1_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load ' ... gridControl1.ForceInitialize() ' Create an unbound column. Dim unbColumn As GridColumn = 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 End Sub ' Returns the total amount for a specific row. Private Function getTotalValue(ByVal listSourceRowIndex As Integer) As Decimal Dim row As DataRow = NwindDataSet.Tables("Order Details").Rows(listSourceRowIndex) Dim unitPrice As Decimal = Convert.ToDecimal(row("UnitPrice")) Dim quantity As Decimal = Convert.ToDecimal(row("Quantity")) Dim discount As Decimal = Convert.ToDecimal(row("Discount")) Return unitPrice * quantity * (1 - discount) End Function ' Provides data for the Total column. Private Sub GridView1_CustomUnboundColumnData(ByVal sender As Object, _ ByVal e As CustomColumnDataEventArgs) Handles GridView1.CustomUnboundColumnData If e.Column.FieldName = "Total" And e.IsGetData Then e.Value = _ getTotalValue(e.ListSourceRowIndex) End Sub
結(jié)果顯示如下:
本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請務必注明出處、不得修改原文相關鏈接,如果存在內(nèi)容上的異議請郵件反饋至chenjj@fc6vip.cn
文章轉(zhuǎn)載自:DevExpress中文網(wǎng)