首先工具栏加入FarPoint.Win.Spread.FpSpread。假如命名为fpSpread1。
,
定义一个DataTable
,,,,,,,,,,,,,,,, System.Data.DataTable pDT =, new System.Data.DataTable (“T_Sex”);
,,,,,,,,,,,,,,,//set columns 名字
,,,,,,,,,,,,,,,pDT.Columns.Add (“SexCode”, typeof system . string) ();
,,,,,,,,,,,,,,,pDT.Columns.Add(“性”,“system . string) ();
,,,,,,,,,,,,,,,pDT.Columns.Add (“SexName”, typeof system . string) ();
,,,,,,,,,,,,,,,//Add 行
,,,,,,,,,,,,,,,System.Data.DataRow mDR =, pDT.NewRow ();
,,,,,,,,,,,,,,,mDR (“SexCode”),=,“M”;
,,,,,,,,,,,,,,,mDR(“性”),=,“男”;
,,,,,,,,,,,,,,,mDR (“SexName”),=,“男”;
,,,,,,,,,,,,,,,pDT.Rows.Add (mDR);
,,,,,,,,,,,,,,,mDR =, pDT.NewRow ();
,,,,,,,,,,,,,,,mDR (“SexCode”),=,“F”;
,,,,,,,,,,,,,,,mDR(“性”),=,“女”;
,,,,,,,,,,,,,,,mDR (“SexName”),=,“女”;
,,,,,,,,,,,,,,,pDT.Rows.Add (mDR); 定义一个MultiColumnComboBoxCellType
,,,,,,,,,,,,,,,, FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mMCCBCT =, new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType ();
,,,,,,,,,,,,,,,mMCCBCT.DataSourceList =, pDT;
,,,,,,,,,,,,,,,mMCCBCT.DataMemberList =,“T_Sex”;
,,,,,,,,,,,,,,,mMCCBCT.EditorValueChanged +=, mMCCBCT_EditorValueChanged;
,,,,,,,,,,,,,,,mMCCBCT.ListWidth =, 500;
,,,,,,,,,,,,,,,mMCCBCT.ListResizeColumns =, FarPoint.Win.Spread.CellType.ListResizeColumns.ByDataType;
,,,,,,,,,,,,,,,mMCCBCT.AutoSearch =, FarPoint.Win.AutoSearch.MultipleCharacter;
,,,,,,,,,,,,,,,mMCCBCT.AcceptsArrowKeys =, FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
,,,,,,,,,,,,,,,mMCCBCT.ColumnEditName =,“SexName”;
,,,,,,,,,,,,,,,mMCCBCT.DataColumnName =,“性”;
,,,,,,,,,,,,,,,this.fpSpread1.Sheets [0] .Cells.Get (1, 1) .CellType =, mMCCBCT;
,,,,,,,,,,,,,,,this.fpSpread1.Sheets [0] .Cells (1, 1) .Value =,“男”; 组合框联动处理,添加事件fpSpread1_ComboCloseUp
,,,,,,,, private void fpSpread1_ComboCloseUp (object ,发送方,FarPoint.Win.Spread.EditorNotifyEventArgs e)
,,,,,,,{
,,,,,,,,,,,试一试
,,,,,,,,,,,{
null
null
null
null
null
null
null
