Tag Archives: Smart Solution

OUTER JOIN Filter by WHERE or ON Clauses ?!

If you would like to filter a RIGHT OUTER JOIN, e.g. then you have to put Table_1 columns in ON clause and Table_2 in WHERE clause, e.g. If you swapped it or put all conditions in WHERE clause then it … Continue reading

Posted in Databases, Programming, SQL-Server, T-SQL | Tagged , | Leave a comment

Black Box

We have a black box application (closed code) which sends data to a white box application (open code). The data that had been sent changed, and after investigation I discovered that the data is hard coded inside the application’s code … Continue reading

Posted in Design, Programming, SQL-Server, T-SQL | Tagged , | Leave a comment

One page PDF don’t open in IE8

Very weired !!! I can open 2 or more PDF pages in IE8, but one page or less IE8 can’t and gives me this error message: The file is damaged and could not be repaired. By the way, Chrome can. … Continue reading

Posted in ASP.NET, Error Message, Programming, VB.NET | Tagged , , , , | Leave a comment

Read PDF from a Database and Open it into a Frame

IHttpHandler is aowsome. You read your file in the buffer and just send it to src as if it is a named file, so no need to read and save a temporary file in client’s PC. iframePDF1.Attributes.Add(“src”, “ShowPDF.ashx?pID=” & Request.QueryString(“pID”)) … Continue reading

Posted in Databases, Programming, SQL-Server, VB.NET | Tagged , , , , , | Leave a comment

How to open a new page/window and send parameters by clicking a button?

Because neither Server.Transfer nor Response.Redirect has an option to open a new page/window , this is a workaround: Failed Solutions: I thought this is a Smart solution <asp:Button ID=”OpenNewPage” runat=”server” Text=”Open New Page” OnClientClick =”document.forms [0].target = ‘_blank’;“/> But it … Continue reading

Posted in JavaScript, Programming | Tagged , , | Leave a comment