Spread8.0 for asp.net 中的ComboBox如何添加数据。
单元格的类型是动态设置的，该如何给ComboBox添加数据呢?DetailSpread.Cells(x, 1).CellType = New FarPoint.Web.Spread.ComboBoxCellType
您好，参考一下以下demo:
FpSpread1 = new FarPoint.Web.Spread.FpSpread();
FpSpread1.ID = "FpSpread1";
FpSpread1.Style["Position"] = "Absolute";
FpSpread1.Height = 400;
FpSpread1.Width = 800;
FpSpread1.Style["Top"] = "25px";
FpSpread1.Style["Left"] = "100px";
FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
FpSpread1.Sheets.Add(sv);
form1.Controls.Add(FpSpread1);
DataSet ds = new System.Data.DataSet();
DataTable name;
DataTable city;
name = ds.Tables.Add("Customers");
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),
new DataColumn("ID", typeof(Int32))});
name.Rows.Add(new object[] { "Fielding", "William", 0 });
name.Rows.Add(new object[] { "Williams", "Arthur", 1 });
name.Rows.Add(new object[] { "Zuchini", "Theodore", 2 });
city = ds.Tables.Add("City/State");
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new
DataColumn("State", typeof(string))});
city.Rows.Add(new object[] { "Atlanta", 0, "Georgia" });
city.Rows.Add(new object[] { "Boston", 1, "Mass." });
city.Rows.Add(new object[] { "Tampa", 2, "Fla." });
FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType();
cb.DataSource = ds;
cb.ShowButton = true;
cb.DataMember = "City/State";
cb.DataTextField = "city";
cb.DataValueField = "city";
cb.UseValue = true;
FpSpread1.ActiveSheetView.Cells.CellType = cb;
那么如何后台设置下拉框的被选中项呢？ FpSpread1.ActiveSheetView.Cells.Value = "xxxx";
页:
[1]