当我在做设备报修系统时,我的工作环境是vs.net2005 ,数据库采用access2000,表中有一字段state为数字类型,但我想通过在Gridview中添加一个
checkbox控件显示表中的信息0或1,具体实现办法:
1、思路:把表中的信息取出来,判断后实现true or  false
2、代码
OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["baoxiuConn"].ConnectionString);
        conn.Open();
        OleDbDataAdapter myadapter = new OleDbDataAdapter("select * from baoxiu order by ID desc", conn);
        myadapter.Fill(mydataset, "baoxiu");
        GridView1.DataSource = mydataset;
        GridView1.DataBind();
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            //以下绑定非编辑状态下拉列表
            CheckBox chk = (CheckBox)gvr.FindControl("chk_state");
            if (chk!= null)
            {
                int state = Int32.Parse(mydataset.Tables["baoxiu"].Rows[gvr.RowIndex]["State"].ToString());
                // string selectedText = ((DropDownList)gvr.FindControl("DropDownList1")).SelectedItem.Text;
                if (state  == 1)
                 chk.Checked=true;
                else
                    chk.Checked=false;

                // string selectedText = ((DropDownList)gvr.FindControl("DropDownList1")).SelectedItem.Text;

            }
        }

        conn.Close();
    

posted on 2007-04-05 14:13  sandboy  阅读(122)  评论(0)    收藏  举报