following query is in a textbox
SELECT [Brewery], [CP CS] FROM [Vw_QueryBuilder_27QueryBuilder1]
these two fields are using in some reports
now if some one remove any of the above column , then it will ask for confirmation to delete all related reports
I am stuck with confirmation
i Have tried like
ScriptManager.RegisterStartupScript(Page, typeof(Page), "somekey", "Confirm()", true);
// Page.ClientScript.RegisterStartupScript(this.GetType(), "Call my function", "Confirm()", true);
// Response.Write("<script>javascript:Confirm();</script>");
string confirmValue = CnfHide.Value.Trim();
if (confirmValue == "1")
javascript is
function Confirm() {
if (confirm("Some columns are being used in other reports, removing those columns from query builder will lead to remove all related reports. Dou you want to proceed?")) {
$("#ContentPlaceHolder1_CnfHide").val("1");
} else {
$("#ContentPlaceHolder1_CnfHide").val("0");
}
}
confirm window is appearing but its not storing value 1 or 0 or stop at that point, it just passed all lines in code behind function