当我在做设备报修系统时,我的工作环境是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();
浙公网安备 33010602011771号