private void BindAimName(string strSkey) { DataSet ds = new DataSet(); TbgmsParams tbGmsParamsBL = new TbgmsParams(); ds = tbGmsParamsBL.GetActionType(strSkey); //从数据库中取出数据 if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataView dv = new DataView(ds.Tables[0]); dv.RowFilter = string.Format("sID=='1'&&sID=='2'");//除ID为1和2的都排除掉 //以下绑定DDL DataTable dt = new DataTable(); dt = dv.ToTable(); this.ddlAimName.DataSource = dt; this.ddlAimName.DataTextField = "sName"; this.ddlAimName.DataValueField = "sID"; this.ddlAimName.DataBind(); } } dv.RowFilter = string.Format("sID=='1'&&sID=='2'");//除ID为1和2的都排除掉 这里相当于SQL中的where,在括号里添加想要的条件就可以了
只选择Table中特定的几条数据
最新推荐文章于 2021-01-03 11:02:10 发布