flash中DataGrid常用的使用技巧(2)

作者：xzzhangg 来源：闪吧整理日期：2007-09-28

4.将数据原中的0,1值转换成实际的文字
略
5.在DataGrid中选择,确认,删除多行复选框列表
public void CheckAll(object sender, System.EventArgs e)
    {
      CheckBox cbAll = (CheckBox)sender;
      if(cbAll.Text=="全选")
      {
        foreach(DataGridItem dgi in dgShow.Items)
        {
          CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
          cb.Checked = cbAll.Checked;
        }
      }
    }
    private void btnDelete_Click(object sender, System.EventArgs e)
    {
      foreach(DataGridItem dgi in dgShow.Items)
      {
        CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
        if(cb.Checked)
        {
          //以下执行删除操作
          int nID = int.Parse(dgi.Cells[0].Text);
          string strSql = "delete from tbStudentinfo where studentid="+nID;
          ExecuteSql(strSql);
        }
      }
      dgShow.CurrentPageIndex = 0;
      BindData();
    }
6.利用dropdownlist下拉列表框，显示数据库表中的某个字段
foreach(DataGridItem dgi in dgShow.Items)
      {
        //以下绑定非编辑状态下拉列表
        DropDownList ddI = (DropDownList)dgi.FindControl("ddlSexI");
        if(ddI!=null)
        {
          bool bSex = (bool)ds.Tables["studentinfo"].Rows[dgi.ItemIndex]["Sex"];
          if(bSex)
            ddI.SelectedIndex = 0;
          else
            ddI.SelectedIndex = 1;
        }
        //以下绑定编辑状态下拉列表
        DropDownList ddE = (DropDownList)dgi.FindControl("ddlSexE");
        if(ddE!=null)
        {
          bool bSex = (bool)ds.Tables["studentinfo"].Rows[dgi.ItemIndex]["Sex"];
          if(bSex)
            ddE.SelectedIndex = 0;
          else
            ddE.SelectedIndex = 1;
        }
      }

[1] [2] [3]