久久久日本电影,色噜噜狠狠色综合网图区,亚洲高清不卡

View Post

DataGrid綁定DataSet總結

改變列寬和抬頭

DataGridTableStyle ts1 = new DataGridTableStyle();

ts1.MappingName = str_HistoryOrderTableName;

this.dg_HistoryOrder.TableStyles.Add(ts1);

this.dg_HistoryOrder.TableStyles[str_HistoryOrderTableName].GridColumnStyles["用餐開始時間"].Width = 80;

this.dg_HistoryOrder.TableStyles[str_HistoryOrderTableName].GridColumnStyles["用餐開始時間"].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;

//第一列訂單號

DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn();

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

TextCol.HeaderText = "訂單號";

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;

//第三列上車時間

TextCol = new DataGridTextBoxColumn();

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

TextCol.HeaderText = "上車時間";

TextCol.Alignment=HorizontalAlignment.Center;

TextCol.Width=120;

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

TextCol.Dispose();

TextCol=null;

//第四列上車地點

TextCol = new DataGridTextBoxColumn();

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

TextCol.HeaderText = "上車地點";

TextCol.Width=180;

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

TextCol.Dispose();

TextCol=null;

//第五列下車地點

TextCol = new DataGridTextBoxColumn();

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

TextCol.HeaderText = "下車地點";

TextCol.Width=180;

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

TextCol.Dispose();

TextCol=null;

//第六列訂單狀態

DataGridComboBoxColumn ComboTextCol = new DataGridComboBoxColumn();

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

ComboTextCol.HeaderText="訂單狀態";

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中的相應DataTable名稱

ComboTextCol.HeaderText="車輛編號";

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;

//第八列車輛狀態

ComboTextCol = new DataGridComboBoxColumn();

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

ComboTextCol.HeaderText="車輛狀態";

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); //參數指名列數，從0開始

textButtonCol.MappingName = "button"; //對應字段名稱或別名

//textButtonColStyle.HeaderText = "動作"; //列頭名稱

//與點擊按鈕后的事件關聯

textButtonCol.CellButtonClicked +=

new DataGridCellButtonClickEventHandler(HandleCellButtonClick);

textButtonCol.Alignment=HorizontalAlignment.Center;

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

//添加鼠標事件，使得按鈕可以被點擊

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 閱讀(1310) 評論(0) 編輯收藏所屬分類: 05 微軟編程

Samuel Learning

文章分類(203)

新聞分類(52)

.NET資源

Ajax

Java開源

Mobile

WEB資源

Workflow

其他連接

大牛人

開源軟件

敏捷

數據庫

未歸類

經典框架

網絡教程

著名站點

項目管理

最新評論

View Post

DataGrid綁定DataSet總結