protected void ddlSavedQuery_SelectedIndexChanged(object sender, EventArgs e) { if (ddlSavedQuery.SelectedValue == "0") { txtQuery.Text = ""; txtQueryName.Text = ""; lblQueryDetails.Text = ""; lblCreatedBy.Text = ""; } else { DataTable dt = BLL_Infra_DaemonSettings.Get_SavedQuery(UDFLib.ConvertToInteger(ddlSavedQuery.SelectedValue), GetSessionUserID()); if (dt.Rows.Count > 0) { txtQuery.Text = dt.Rows[0]["Command_SQL"].ToString(); txtQueryName.Text = dt.Rows[0]["Query_Name"].ToString(); lblQueryDetails.Text = "Server: " + dt.Rows[0]["DBServer"].ToString() + "/ (" + dt.Rows[0]["DatabaseName"].ToString() + ")" + "<br>Query Name: " + dt.Rows[0]["Query_Name"].ToString(); lblCreatedBy.Text = "Created By: " + dt.Rows[0]["CreatedBy"].ToString() + " on " + dt.Rows[0]["Date_Of_Creation"].ToString(); if (dt.Rows[0]["ModifiedBy"].ToString() != "") { lblCreatedBy.Text += ", Modified By: " + dt.Rows[0]["ModifiedBy"].ToString() + " on " + dt.Rows[0]["Date_Of_Modification"].ToString(); } } else { txtQuery.Text = ""; txtQueryName.Text = ""; lblQueryDetails.Text = ""; lblCreatedBy.Text = ""; } } }
protected void Load_SavedQueries() { DataTable dt = BLL_Infra_DaemonSettings.Get_SavedQuery(hdnServer.Value, hdnCatalog.Value, hdnUsername.Value, 0, GetSessionUserID()); ddlSavedQuery.Items.Clear(); ddlSavedQuery.DataSource = dt; ddlSavedQuery.DataTextField = "Query_Name"; ddlSavedQuery.DataValueField = "ID"; ddlSavedQuery.DataBind(); ddlSavedQuery.Items.Insert(0, new ListItem("Select Procedure", "0")); }