public void BindFilterOperators(DropDownList ddl)
{
try
{
ddl.Items.Clear();
//ddl.Items.Add(new ListItem("Equals", "="));
//ddl.Items.Add(new ListItem("GreaterThanOrEqualTo", ">="));
//ddl.Items.Add(new ListItem("LessThanOrEqualTo", "<="));
//ddl.Items.Add(new ListItem("Between", ">= and <="));
//ddl.Items.Add(new ListItem("IsGreaterThan", ">"));
//ddl.Items.Add(new ListItem("IsLessthan", "<"));
//ddl.Items.Add(new ListItem("NotEqualTo", "!="));
//ddl.Items.Add(new ListItem("IsEmpty", "IS NULL"));
//ddl.Items.Add(new ListItem("IsNotEmpty", "IS NOT NULL"));
UtilityDAL obj = new UtilityDAL();
DataSet ds = new DataSet();
ds = obj.GetFilterConditions();
if (ds.Tables.Count > 0)
{
ddl.DataSource = ds.Tables[0];
ddl.DataTextField = ds.Tables[0].Columns["CondText"].ToString();
ddl.DataValueField = ds.Tables[0].Columns["CondSymbol"].ToString();
ddl.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
