轉(zhuǎn)帖|其它|編輯:郝浩|2011-04-01 13:22:57.000|閱讀 2107 次
概述:本文主要講述如何給Dev ASPxGridView后臺(tái)增加列,希望對(duì)大家有幫助。
# 界面/圖表報(bào)表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
本文主要講述如何給Dev ASPxGridView后臺(tái)增加列,希望對(duì)大家有幫助。
public void BindRecordList()
{
String sqlAll=”select ID,”;
if (ASPxGridView1.Columns.Count == 0)
{
//手動(dòng)綁定數(shù)據(jù)
DevExpress.Web.ASPxGridView.GridViewDataTextColumn dl = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
dl.Caption = "顯示出來(lái)的頭部";
dl.FieldName = "AgentId";
gvRecordList.Columns.Add(dl);
//從數(shù)據(jù)庫(kù)中取的要綁定的列名與描述
DataTable dsWidth = gd.getGradeReg();
String Sqlcolumn=””;
for (int i = 0; i < dsWidth.Rows.Count; i++)
{
DevExpress.Web.ASPxGridView.GridViewDataTextColumn datacolumn = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
//綁定列的描述
datacolumn.Caption = dsWidth.Rows[i]["GrShow"].ToString();
//綁定列的字段
datacolumn.FieldName = dsWidth.Rows[i]["GrName"].ToString().Trim();
datacolumn.UnboundType = DevExpress.Data.UnboundColumnType.Bound;
ASPxGridView1.Columns.Add(datacolumn);
//取得sql語(yǔ)句中的字段
Sqlcolumn+=” , “+ dsWidth.Rows[i]["GrName"].ToString().Trim()
}
}
DataSet dsRecord = null;
try
{//取得完整的sql語(yǔ)句
sqlAll += ColonmFileds + " from Recording " + sqlQuery();
dsRecord = SQLHelper.Query(sqlAll);
//綁定數(shù)據(jù)源
ASPxGridView1.DataSource = dsRecord.Tables[0].DefaultView;
ASPxGridView1.DataBind();
}
catch
{
throw;
}
}
GridView在后臺(tái)動(dòng)態(tài)綁定列或者增加列的語(yǔ)句為:
for (int i = 0; i < dsWidth.Rows.Count; i++)
{
BoundField bf = new BoundField();
bf.DataField = dsWidth.Rows[i]["GrName"].ToString().Trim();//字段名
bf.HeaderText = dsWidth.Rows[i]["GrShow"].ToString();//列名
GridView1.Columns.Insert(i, bf);
}
本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請(qǐng)務(wù)必注明出處、不得修改原文相關(guān)鏈接,如果存在內(nèi)容上的異議請(qǐng)郵件反饋至chenjj@fc6vip.cn
文章轉(zhuǎn)載自:網(wǎng)絡(luò)轉(zhuǎn)載