Problems with jQuery Modal Dialog Inside Partial Postacks (ie: a .NET UpdatePanel)

Problems with jQuery Modal Dialogs problem can happen in a number of ways (see some of my other articles on the subject). This time, it was that I used a jQuery Modal Dialog inside of an ASP.NET UpdatePanel. After some looking around, what seems to be happening is that the dialog invisibly duplicates fields to the end of the document sent to the browser.
Continue reading “Problems with jQuery Modal Dialog Inside Partial Postacks (ie: a .NET UpdatePanel)”

Example of Encrypting and Decrypting a String into a SQL Table Using ASP.NET

I’ve put together this article because even after a lot of searching, I wasn’t able to find a simple, working example of how to encrypt and then decrypt a string that you are saving in your database in ASP.Net. Sure, there are some partial examples, but partial code usually doesn’t answer the question properly. Added to that, a lot of examples are out there that plain don’t work, confusing the issue and wasting a lot of time. So in this article I’ll give an example of a fully working test Web page that saves an encrypted string to a SQL Server database table, and that also shows the decrypted field back to the user.

Continue reading “Example of Encrypting and Decrypting a String into a SQL Table Using ASP.NET”

Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time:
  1. In simplifying your task of putting the Workbook and Worksheets together
  2. and I can’t stress enough how much time this will save you from trying to re-jig your Web server to serve Excel documents using the Microsoft.Office.Interop.Excel library.

Continue reading “Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly”