protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GSEGC_LogConnectionString"].ConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select distinct WorkflowName from wfInfo", conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.ddlWFName.DataSource = ds;
this.ddlWFName.DataTextField = "WorkflowName";
this.ddlWFName.DataValueField = "WorkflowName";
this.ddlWFName.DataBind();
SqlDataAdapter daStatu = new SqlDataAdapter("select distinct Status from wfInfo", conn);
DataSet dsStatu = new DataSet();
daStatu.Fill(dsStatu);
this.ddlWFStatus.DataSource = dsStatu;
this.ddlWFStatus.DataTextField = "Status";
this.ddlWFStatus.DataValueField = "Status";
this.ddlWFStatus.DataBind();
/*SqlDataAdapter daWFId = new SqlDataAdapter("select distinct WorkflowId from wfInfo", conn);
DataSet dsWFId = new DataSet();
daWFId.Fill(dsWFId);*/
GetFilterStatus();
}
}
}