protected void load_savedQuery()
{
DataTable dt = objPI.Get_SavedQuery(hdnServer.Value, hdnCatalog.Value, hdnUsername.Value, ddlCommandType.SelectedValue, "", GetSessionUserID());
pnlSavedProc.Enabled = true;
txtQuery.Enabled = true;
pnlCtl.Visible = true;
if (dt.Rows.Count > 0)
{
pnlSavedProc.Enabled = true;
ddlSavedQuery.Items.Clear();
ddlSavedQuery.DataSource = dt;
ddlSavedQuery.DataTextField = "ObjectName";
ddlSavedQuery.DataValueField = "ObjectName";
ddlSavedQuery.DataBind();
ddlSavedQuery.Items.Insert(0, new ListItem("Select Object", "0"));
}
else
{
ddlSavedQuery.Items.Clear();
ddlSavedQuery.Items.Insert(0, new ListItem("Select Object", "0"));
}
}
protected void LoadQueryList()
{
ddlListSource.DataSource = objPI.Get_SavedQuery("", "TMSA_Daemon_SP", GetSessionUserID());
ddlListSource.DataTextField = "ObjectName";
ddlListSource.DataValueField = "ObjectName";
ddlListSource.DataBind();
ddlListSource.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
