亚洲视频无码高清在线,亚洲处破女AV日韩精品,亚洲av成人无码久久精品

View Post

DataGrid綁定DataSet總結(jié)

改變列寬和抬頭

DataGridTableStyle ts1 = new DataGridTableStyle();

ts1.MappingName = str_HistoryOrderTableName;

this.dg_HistoryOrder.TableStyles.Add(ts1);

this.dg_HistoryOrder.TableStyles[str_HistoryOrderTableName].GridColumnStyles["用餐開(kāi)始時(shí)間"].Width = 80;

this.dg_HistoryOrder.TableStyles[str_HistoryOrderTableName].GridColumnStyles["用餐開(kāi)始時(shí)間"].HeaderText = "wori";

隱藏某一列

ds_Customer.Tables[c_str_CUSTOMERINFOTABLE].Columns[CustomerData.c_str_InitPKID_FILED].ColumnMapping = MappingType.Hidden;

獲取某一列的值

DataView dv_Tmp = (DataView) this.dg_Content.DataSource;

int i_PKID=Convert.ToInt32(dv_Tmp[this.dg_Content.CurrentRowIndex].Row[0]);

我的綁定代碼

if (dsOrder==null)

{ dsOrder=wsOrderService.QueryOrdersForDisp("","","","",""); }

if (dsCar==null)

{ dsCar=wsCarService.GetAllAvailableCars();}

dgOrders.DataSource=dsOrder.Tables[0].DefaultView;

dgOrders.ReadOnly=true;

dgOrders.CaptionVisible=false;

DataGridTableStyle tableStyle = new DataGridTableStyle();

tableStyle.MappingName = dsOrder.Tables[0].TableName;

//第一列訂單號(hào)

DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn();

TextCol.MappingName = "order_no"; //列名

TextCol.HeaderText = "訂單號(hào)";

TextCol.Alignment=HorizontalAlignment.Center;

TextCol.Width=90;

tableStyle.GridColumnStyles.Add(TextCol); //為TableStyle添加列

TextCol.Dispose();

TextCol=null;

//第二列乘客姓名

TextCol = new DataGridTextBoxColumn();

TextCol.MappingName = "name"; //列名

TextCol.HeaderText = "乘客姓名";

TextCol.Alignment=HorizontalAlignment.Center;

tableStyle.GridColumnStyles.Add(TextCol); //為TableStyle添加列

TextCol.Dispose();

TextCol=null;

//第三列上車時(shí)間

TextCol = new DataGridTextBoxColumn();

TextCol.MappingName = "pu_date_time"; //列名

TextCol.HeaderText = "上車時(shí)間";

TextCol.Alignment=HorizontalAlignment.Center;

TextCol.Width=120;

tableStyle.GridColumnStyles.Add(TextCol); //為TableStyle添加列

TextCol.Dispose();

TextCol=null;

//第四列上車地點(diǎn)

TextCol = new DataGridTextBoxColumn();

TextCol.MappingName = "pu_address"; //列名

TextCol.HeaderText = "上車地點(diǎn)";

TextCol.Width=180;

tableStyle.GridColumnStyles.Add(TextCol); //為TableStyle添加列

TextCol.Dispose();

TextCol=null;

//第五列下車地點(diǎn)

TextCol = new DataGridTextBoxColumn();

TextCol.MappingName = "dest_address"; //列名

TextCol.HeaderText = "下車地點(diǎn)";

TextCol.Width=180;

tableStyle.GridColumnStyles.Add(TextCol); //為TableStyle添加列

TextCol.Dispose();

TextCol=null;

//第六列訂單狀態(tài)

DataGridComboBoxColumn ComboTextCol = new DataGridComboBoxColumn();

ComboTextCol.MappingName ="o_status";// dsOrderStatus.Tables[0].TableName; //DataSet中的相應(yīng)DataTable名稱

ComboTextCol.HeaderText="訂單狀態(tài)";

ComboTextCol.Alignment=HorizontalAlignment.Center;

ComboTextCol.Width = 100;

ComboTextCol.ColumnComboBox.DataSource =dsOrderStatus.Tables[0].DefaultView;//必須用DataView

ComboTextCol.ColumnComboBox.DisplayMember = "status_descr";//要顯示的字段名

ComboTextCol.ColumnComboBox.ValueMember = "status_id";//值的字段名

//tableStyle.PreferredRowHeight = ComboTextCol.ColumnComboBox.Height + 2;

ComboTextCol.Alignment=HorizontalAlignment.Center;

tableStyle.GridColumnStyles.Add(ComboTextCol); //為TableStyle添加列

ComboTextCol.Dispose();

ComboTextCol=null;

//第七列車輛列表

ComboTextCol = new DataGridComboBoxColumn();

ComboTextCol.MappingName ="car_no"; //dsCar.Tables[0].TableName; //DataSet中的相應(yīng)DataTable名稱

ComboTextCol.HeaderText="車輛編號(hào)";

ComboTextCol.Alignment=HorizontalAlignment.Center;

ComboTextCol.Width = 70;

DataTable dt=dsCar.Tables[0];

ComboTextCol.ColumnComboBox.DataSource =dt.DefaultView;//必須用DataView

ComboTextCol.ColumnComboBox.DisplayMember = "car_no";//要顯示的字段名

ComboTextCol.ColumnComboBox.ValueMember = "car_no";//值的字段名

//ComboTextCol.ColumnComboBox.Items.Insert(0,"-");

ComboTextCol.NullText="";

//tableStyle.PreferredRowHeight = ComboTextCol.ColumnComboBox.Height + 2;

ComboTextCol.Alignment=HorizontalAlignment.Center;

tableStyle.GridColumnStyles.Add(ComboTextCol); //為TableStyle添加列

ComboTextCol.Dispose();

ComboTextCol=null;

//第八列車輛狀態(tài)

ComboTextCol = new DataGridComboBoxColumn();

ComboTextCol.MappingName ="c_status"; //dsCar.Tables[0].TableName; //DataSet中的相應(yīng)DataTable名稱

ComboTextCol.HeaderText="車輛狀態(tài)";

ComboTextCol.Alignment=HorizontalAlignment.Center;

ComboTextCol.Width = 70;

ComboTextCol.ColumnComboBox.DataSource =dsCarStatus.Tables[0].DefaultView;//必須用DataView

ComboTextCol.ColumnComboBox.DisplayMember = "status_descr";//要顯示的字段名

ComboTextCol.ColumnComboBox.ValueMember = "status_id";//值的字段名

//ComboTextCol.ColumnComboBox.Items.Insert(0,"-");

ComboTextCol.NullText="";

//tableStyle.PreferredRowHeight = ComboTextCol.ColumnComboBox.Height + 2;

ComboTextCol.Alignment=HorizontalAlignment.Center;

tableStyle.GridColumnStyles.Add(ComboTextCol); //為TableStyle添加列

ComboTextCol.Dispose();

ComboTextCol=null;

//第九列提交按鈕

DataGridButtonColumn textButtonCol= new DataGridButtonColumn(8); //參數(shù)指名列數(shù)，從0開(kāi)始

textButtonCol.MappingName = "button"; //對(duì)應(yīng)字段名稱或別名

//textButtonColStyle.HeaderText = "動(dòng)作"; //列頭名稱

//與點(diǎn)擊按鈕后的事件關(guān)聯(lián)

textButtonCol.CellButtonClicked +=

new DataGridCellButtonClickEventHandler(HandleCellButtonClick);

textButtonCol.Alignment=HorizontalAlignment.Center;

tableStyle.GridColumnStyles.Add(textButtonCol); //為TableStyle添加列

//添加鼠標(biāo)事件，使得按鈕可以被點(diǎn)擊

if(!isDefinedEvent)

{

dgOrders.MouseDown += new MouseEventHandler(textButtonCol.HandleMouseDown);

dgOrders.MouseUp += new MouseEventHandler(textButtonCol.HandleMouseUp);

isDefinedEvent=true;

}

textButtonCol.Dispose();

textButtonCol=null;

//為DataGrid指定TableStyle

dgOrders.TableStyles.Clear();

dgOrders.TableStyles.Add(tableStyle);

posted on 2006-03-26 23:55 MingIsMe 閱讀(1306) 評(píng)論(0) 編輯收藏所屬分類: 05 微軟編程

Samuel Learning

文章分類(203)

新聞分類(52)

.NET資源

Ajax

Java開(kāi)源

Mobile

WEB資源

Workflow

其他連接

大牛人

開(kāi)源軟件

敏捷

數(shù)據(jù)庫(kù)

未歸類

經(jīng)典框架

網(wǎng)絡(luò)教程

著名站點(diǎn)

項(xiàng)目管理

最新評(píng)論

View Post

DataGrid綁定DataSet總結(jié)