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,在括号里添加想要的条件就可以了*/
浙公网安备 33010602011771号