下拉菜单取值

收藏

在下拉菜单如何取取到选择项的值：
见下面代码：
  FarPoint.Web.Spread.ComboBoxCellType cmb = new FarPoint.Web.Spread.ComboBoxCellType();
      cmb.Items = new string[] { "上班", "下基层"};
      cmb.Values = new string[] { "1","2"};
      this.FpSpread1.ActiveSheetView.Columns[4].CellType = cmb;
      this.FpSpread1.ActiveSheetView.Columns[4].Editor = cmb;

用户选择下拉菜单后，点击更新按钮：见代码：

  protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
      //更新动作
      int currentRow = (int)e.CommandArgument;
      System.Collections.ArrayList array = e.EditValues;
      for (int i = 0; i < array.Count; i++)
      {
         //e.SheetView.Cells[Convert.ToInt32(e.CommandArgument),4].Value
         if (array.ToString() != "System.Object")
         {
            int id = int.Parse(e.SheetView.Cells[Convert.ToInt32(e.CommandArgument), 0].Text);
            FarPoint.Web.Spread.ComboBoxCellType cmb = this.FpSpread1.Sheets[0].Cells[currentRow, 4].CellType as FarPoint.Web.Spread.ComboBoxCellType;

            int values = Convert.ToInt32(e.SheetView.Cells[Convert.ToInt32(e.CommandArgument), 4].Value);

//other coder.....
         }
      }

}

iceman · iceman

elwin 你好：
请使用下面代码取值：

protected void Page_Load(object sender, EventArgs e)
{
FarPoint.Web.Spread.ComboBoxCellType cmb = new FarPoint.Web.Spread.ComboBoxCellType();
cmb.Items = new string[] { "上班", "下基层" };
cmb.Values = new string[] { "1", "2" };
this.FpSpread1.ActiveSheetView.Columns[0].CellType = cmb;
}
protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
int index;
string myvalue;
FarPoint.Web.Spread.ICellType ct;
if (!(object.ReferenceEquals(e.EditValues[0], FarPoint.Web.Spread.FpSpread.Unchanged)))
{
ct = e.SheetView.Columns[0].CellType;
index = Array.IndexOf(((FarPoint.Web.Spread.ComboBoxCellType)ct).Items, e.EditValues[0]);
myvalue = ((FarPoint.Web.Spread.ComboBoxCellType)ct).Values[index];
}
}

复制代码

elwin · elwin

非常感谢。

iceman · iceman

:share:

		自动登录	找回密码
密码			立即注册

[已处理] 下拉菜单取值

3 个回复

回复 1# elwin 的帖子

回复 3# elwin 的帖子

活字格认证

微信认证勋章

元老葡萄