http://www.keylimetie.com KeyLimeTie RSS Feed en-us http://www.keylimetie.com http://www.keylimetie.com/Common/Images/custom/RSSFeedLogo.jpg 150 100 http://www.keylimetie.com/Blog/2008/4/15/Disable-PDB-File-Generation-in-Release-Mode/ Wed, 16 Apr 2008 01:52:06 GMT http://www.keylimetie.com/~/Blog/2008/4/15/Disable-PDB-File-Generation-in-Release-Mode/Default\.aspx http://www.keylimetie.com/Blog/2008/3/28/How-to-check-for-hexidecimal-characters/ tilde) see: http://www.asciitable.com 11 if (value 126) 12 return false; 13 } 14 } 15 catch 16 { 17 return false; 18 } 19 return true; 20}]]> Sat, 29 Mar 2008 01:45:19 GMT http://www.keylimetie.com/~/Blog/2008/3/28/How-to-check-for-hexidecimal-characters/Default\.aspx http://www.keylimetie.com/Blog/2008/3/16/KeyLimeTie-Log-Cleaner-FREE/ Profiles> Profile> !-- Keep this application's logs pruned to 15 days --> Description>KeyLimeTie Log CleanerDescription> FolderPath>D:\Projects\KeyLimeTie\KeyLimeTie.LogCleaner\Logs\FolderPath> Extension>txtExtension> DelOlderThanDays>15DelOlderThanDays> Recursive>falseRecursive> Profile> Profile> !-- Example: Keep IIS Logs pruned to 15 days --> !-- Setting Recursive true prunes all ftp and website logs --> !-- As new websites are added, no need to update profiles --> Description>All IIS LogsDescription> FolderPath>C:\Windows\system32\LogFiles\FolderPath> Extension>logExtension> DelOlderThanDays>15DelOlderThanDays> Recursive>trueRecursive> Profile> Profile> !-- Example: Keep SQL Server backups pruned to 1 week --> !-- Setting Recursive true prunes all database backups --> !-- As new databases are added, no need to update profiles --> Description>All Database BackupsDescription> FolderPath>D:\Databases\Backups\FolderPath> Extension>bakExtension> DelOlderThanDays>7DelOlderThanDays> Recursive>trueRecursive> Profile> Profiles> Fields: - Description: Profile description - Folder Path: Location of files to be deleted - Extension: Extension of files to be deleted - DelOlderThanDays: Number of days to delete files older than today - Recursive: Tells application to look for files in subdirectories Schedule Application: I installed the software on a few servers and simply created a Scheduled Task through Windows. I have it set to run every day at 4am (after the SQL Server backups are run). Some ideas... - Change "Extension" option to be "MatchPattern". Right now, the code searches for all files by the extension. You can put "*" in there and it'll prune all files, but it could be made to be more powerful. - Create as Windows Service. I have created similar applications as Windows Services...and it's very easy to change this to a Windows Service. But I wanted this first version to be very simple and simple to install. I have seen people have issues with installing Windows Services. - Create an interface to manage the profiles. It's so easy to update this really isn't necessary. ]]> Sun, 16 Mar 2008 18:54:19 GMT http://www.keylimetie.com/~/Blog/2008/3/16/KeyLimeTie-Log-Cleaner-FREE/Default\.aspx http://www.keylimetie.com/Blog/2008/3/6/Internet-Explorer-8-Has-Arrived/ Fri, 07 Mar 2008 01:23:50 GMT http://www.keylimetie.com/~/Blog/2008/3/6/Internet-Explorer-8-Has-Arrived/Default\.aspx http://www.keylimetie.com/Blog/2008/2/12/Safely-restart-an-ASPNET-remotely/ 2 3"-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 4 5"server"> 6 protected void Page_Load(object sender, EventArgs e) 7 { 8 lblMessage.Text = ""; 9 } 10 11 protected void btnRestart_Click(object sender, EventArgs e) 12 { 13 if (txtPassword.Text.Trim().ToUpper() == 14 System.Configuration.ConfigurationManager.AppSettings["ResetSitePassword"].ToString().Trim().ToUpper()) 15 { 16 string webConfigPath = Server.MapPath("Web.config"); 17 System.IO.File.SetLastWriteTime(webConfigPath, DateTime.Now); 18 Session.Abandon(); 19 Response.Redirect("/"); 20 } 21 else 22 lblMessage.Text = "Invalid password"; 23 } 24 25 26"http://www.w3.org/1999/xhtml"> 27"server"> 28 Restart Website 29 30 31 "aspnetForm" runat="server"> 32 Password: 33 "txtPassword" runat="server" TextMode="Password"> 34 "btnRestart" runat="server" Text="Restart" OnClick="btnRestart_Click"> 35 36 "lblMessage" runat="server" ForeColor="Red"> 37 38 39]]> Tue, 12 Feb 2008 21:15:04 GMT http://www.keylimetie.com/~/Blog/2008/2/12/Safely-restart-an-ASPNET-remotely/Default\.aspx http://www.keylimetie.com/Blog/2008/2/9/Dont-Search-For-Domain-Names-on-Network-Solutions/ Sun, 10 Feb 2008 05:06:51 GMT http://www.keylimetie.com/~/Blog/2008/2/9/Dont-Search-For-Domain-Names-on-Network-Solutions/Default\.aspx http://www.keylimetie.com/Blog/2008/1/17/Using-VS7-in-Vista/ User Accounts. b.       Select “Change your account type”. c.        Select “Administrator” (if not already Administrator). d.       Press “Change Account Type”. e.       Select “Turn User Account Control on or off”. f.         Uncheck “Use User Account Control (UAC) to help protect your computer”. g.        Press “OK”. 2.        Ensure your user account is included in the Debugger User group. a.        Note: It appears this is not possible in certain versions of Vista, such as Home Premium.  Click the following link for more information:   http://windowshelp.microsoft.com/Windows/en-US/Help/0faddcfc-e2a9-4297-a429-3f7e83fe6e361033.mspx . 3.        Ensure that .NET 1.1 **SP1** is properly installed. ·          Vista does not include .NET v1.1 by default. ·          Because .NET 1.1 is not included by default, .NET v1.1 *SP1* is also not included. ·          Without SP1, W3WP.exe will crash when running an appPool under v1.1 due to DEP ·          To check this, make sure that "c:\Windows\Microsoft.NET\Framework\v1.1.4322\mscorsvr.dll" is version "1.1.4322.2032" or higher. ·          Unless you are 100% sure that SP1 for .NET is installed, you *really* should double-check this. ·          If you need to install .NET 1.1 SP1, you can download the upgrade here: http://www.microsoft.com/downloads/details.aspx?familyid=A8F5654F-088E-40B2-BBDB-A83353618B38&displaylang=en. 4.        Enable IIS 6.0 compatiblity. a.        Open "Control Panel". b.       Double-click "Programs and Features". c.        Expand "Internet Information Services". d.       Click on “Turn Windows Features On and Off”. e.       Expand "Web Management Tools". f.         Check “IIS 6 Management Compatibility”. 5.        Enable ASP.NET Application Development Features, if not already done so. a.        Open "Control Panel". b.       Double-click "Programs and Features". c.        Expand "Internet Information Services". d.       Click on “Turn Windows Features On and Off”. e.       Expand “World Wide Web Services”. f.         Expand “Application Development Features”. g.        Check “ASP.NET”.                                                   Note:   “.NET Extensibility”, “ISAPI Extensions”, and “ISAPI Filters” are dependencies, so they become automatically checked. 6.        Register v1.1 with IIS. a.        Open a CMD prompt. b.       Change your directory to c:\Windows\MIcrosoft.net\Framework\v1.1.4322. c.        Run "aspnet_regiis -ir -enable". ·    "ir" registers v1.1 with IIS but doesn't change any existing script mappings. ·    "enable" marks aspnet_isapi.dll as "Allowed" under "ISAPI and CGI Restrictions". ·    aspnet_regiis should also create a new AppPool under "Application Pools" called "ASP.NET 1.1" that is configured with the "Classic" pipline, and "Enable32BitAppOnWin64" set to true if a 64-bit OS. 7.        Make the new "ASP.NET 1.1" appPool the default. a.        Open the IIS manager. b.       Select the "Web Sites" folder. c.        Under "Actions" on the upper right, click "Set Web Site Defaults...". d.       Change the "Application Pool" setting to "ASP.NET 1.1". 8.        **Alternative step to 7** - Change the AppPool to "ASP.NET 1.1" after creating the ASP.NET project instead of making it the default a.        Create the v1.1 ASP.NET project via Visual Studio. Attempting to run the project at this point will fail if the 1.1 appPool is not the default. b.       Open the IIS manager. c.        Right-click the newly create application directory and choose "Advanced Settings". d.       Change the "Application Pool" to "ASP.NET 1.1". e.       Go back to Visual Studio and attempt to run/debug project. 9.        Adjust ISAPI and CGI restrictions in IIS. a.        Go into IIS 7.0 manager and select your server. b.       Select ISAPI and CGI restrictions. c.        Ensure ASP v1.1 has the restriction set to Allowed. 10.    Launch Visual Studio 2003 as Administrator. 11.    Create a simple web application with some event handling to test debugging (a button that displays text in a label control is what I used to test). 12.    Attach to the w3wp.exe process.   13.    Set breakpoints where appropriate. 14.    Launch the website in a browser (eg. http://localhost/YourWebApp/YourPage.aspx ). 15.    Ensure your breakpoints are being hit. 16.    That’s it!  Happy coding.   ]]> Thu, 17 Jan 2008 23:14:48 GMT http://www.keylimetie.com/~/Blog/2008/1/17/Using-VS7-in-Vista/Default\.aspx http://www.keylimetie.com/Blog/2008/1/2/KeyLimeTie-Mass-Emailer-Free/ Thu, 03 Jan 2008 02:42:02 GMT http://www.keylimetie.com/~/Blog/2008/1/2/KeyLimeTie-Mass-Emailer-Free/Default\.aspx http://www.keylimetie.com/Blog/2007/12/18/How-to-Communicate-between-ASPNET-and-Flash/ 2 var so = new SWFObject("/flash/map_client.swf", "map_client", "775", "650", "6", "#ececec"); 3 so.addParam("menu", "false"); 4 so.addParam("quality", "high"); 5 so.addParam("wmode", "transparent"); 6 so.addParam("allowScriptAccess", "sameDomain"); 7 so.addParam("movie", "/flash/map_client.swf"); 8 so.addParam("bgcolor", "#ffffff"); 9 so.addParam("FlashVars", "FloorPlanGUID="); 10 so.write("flashcontent1"); 11FlashGetData.aspxThis page is used by the Flash application to get data. The ASPX portion of this web page has no HTML or controls. When processing the Flash application's request, we output the data it needs in the HTML in a name-value pair. A little explanation...this page is called for the floor plan XML or an individual booth's details (name, address, etc.). After calling the database to get the data, it's written to the output HTML as field=value.1public partial class FlashGetData : System.Web.UI.Page 2{ 3protected void Page_Load(object sender, EventArgs e) 4 { 5 if (Request.QueryString["Mode"] != null) 6 { 7 try8 { 9 //Extract mode10 Enums.ModeEnum mode = (Enums.ModeEnum)int.Parse(Request.QueryString["Mode"].ToString()); 1112 //Process based on mode13 DataSet ds = null; 14 DataRow row; 15 if (mode == Enums.ModeEnum.RequestFloorPlan) 16 { 17 //Extract Querystring parameters18 string floorPlanGUID = Request.QueryString["FloorPlanGUID"].ToString(); 1920 //Get the data21 ds = FloorPlans_BLL.SelectFloorPlansByFloorPlanGUID(new Guid(floorPlanGUID)); 22 row = ds.Tables[0].Rows[0]; 23 Response.Write("FloorPlanXML=" + row["FloorPlanXML"].ToString()); 24 } 25 else if (mode == Enums.ModeEnum.RequestCompanyDetails) 26 { 27 //Extract Querystring parameters28 string floorPlanGUID = Request.QueryString["FloorPlanGUID"].ToString(); 29 string boothID = Request.QueryString["BoothID"].ToString(); 3031 //Get the data32 ds = Companies_BLL.SelectCompaniesByFloorPlanIDBoothID( new Guid(floorPlanGUID), boothID); 33 Response.Write("CompanyDetails=" + BuildCompanyDetails(boothID, ds)); 34 } 35 } 36 catch (Exception ex) 37 { 38 Helpers.ProcessException(ex); 39 } 40 } 41 } 42}FlashSaveData.aspxThis page is used in the administration area. Again, the ASPX portion of this web page has no HTML or controls.The Flash movie executes a command like: xmlDoc.sendAndLoad("FlashSaveData.aspx?FloorPlanGUID=xxx-xxx-xxx-xxx", returnXML, "POST");The important point of this code is Line 19. The Flash application posts data in the Request stream.1public partial class FlashSaveData : System.Web.UI.Page 2{ 3protected void Page_Load(object sender, EventArgs e) 4 { 5 //The Flash movie executes a command like:6 //xmlDoc.sendAndLoad("FlashSaveData.aspx?FloorPlanGUID=xxx-xxx-xxx-xxx", returnXML, "POST");78 XmlDocument doc = null; 9 FloorPlans floorplans = null; 10 FloorPlanCompanies fpc = null; 11 DataSet ds = null; 12 try13 { 14 if (Request.QueryString["FloorPlanGUID"] != null) 15 { 16 //Extract GUID and XML17 string floorPlanGUID = Request.QueryString["FloorPlanGUID"].ToString(); 18 doc = new XmlDocument(); 19 doc.Load(Request.InputStream); 2021 //Get the FloorPlan row22 ds = FloorPlans_BLL.SelectFloorPlansByFloorPlanGUID(new Guid(floorPlanGUID)); 23 DataRow row = ds.Tables[0].Rows[0]; 2425 //Build FloorPlans object26 floorplans = new FloorPlans(); 27 floorplans.FloorPlanID = Int32.Parse(row["FloorPlanID"].ToString()); 28 floorplans.FloorPlanGUID = new Guid(row["FloorPlanGUID"].ToString()); 29 floorplans.UserID = Int32.Parse(row["UserID"].ToString()); 30 floorplans.Title = row["Title"].ToString(); 31 floorplans.URL = row["URL"].ToString(); 32 floorplans.FloorPlanXML = doc.InnerXml; 33 floorplans.Active = (bool)row["Active"]; 34 floorplans.RewriterID = Int32.Parse(row["RewriterID"].ToString()); 3536 //Make sure all booths are now in the database37 XmlNodeList objNodes = doc.SelectNodes("./floorplan/booths/boothtxt"); 38 foreach (XmlNode objNode in objNodes) 39 { 40 fpc = new FloorPlanCompanies(); 41 fpc.FloorPlanID = Int32.Parse(row["FloorPlanID"].ToString()); 42 fpc.BoothID = objNode.InnerXml; 43 fpc.CompanyID = 0; 44 FloorPlanCompanies_BLL.SaveFloorPlanCompanies(fpc, false, null); 45 } 4647 //Save to database48 FloorPlans_BLL.UpdateFloorPlans(floorplans); 49 } 50 else51 throw new Exception("FloorPlanGUID missing"); 52 } 53 catch (Exception ex) 54 { 55 Helpers.ProcessException(ex); 56 } 57 finally58 { 59 if (ds != null) 60 { 61 ds.Dispose(); 62 ds = null; 63 } 64 fpc = null; 65 floorplans = null; 66 doc = null; 67 } 68 } 69}]]> Wed, 19 Dec 2007 05:29:46 GMT http://www.keylimetie.com/~/Blog/2007/12/18/How-to-Communicate-between-ASPNET-and-Flash/Default\.aspx http://www.keylimetie.com/Blog/2007/12/3/How-to-make-an-AJAX-Postback-with-JavaScript/ 2 3 "100%" border="0" cellpadding="0" cellspacing="4"> 4 5 6 class="agentbox" onmouseover="style.backgroundColor='#e0e8f3';"                              onmouseout="style.backgroundColor='#f1f1f1';"7 onclick="makeAJAXPostback('ID")%>')"> 8 "DisplayName")%> 9 10 "Address1")%> 11 12 "City")%> 13 14 "StateIDCode")%> 15 "Zip")%> 16 17 "Phone")%> 18 19 20 21 22 23At the bottom of the page, we added a the "makeAJAXPostback" function.We also added a hidden field and a hidden HTML submit button:1 "submit" id="btnTDClicked" name="btnTDClicked" style="display: none" /> 2 "hidden" id="hidTDClickID" name="hidTDClickID" /> 3 4 5 "text/javascript"> 6 function makeAJAXPostback(TDClickID) 7 { 8 document.forms[0].hidTDClickID.value = TDClickID; 9 document.forms[0].btnTDClicked.click(); 10 } 11 12 13When the TD cell is clicked, the "makeAJAXPostback" function is called, the ID is put in the hidden field and the hidden button is clicked. Because the AJAX Toolkit handles all form postbacks, the button click is automatically made via AJAX.All that's left is to handle the postback on the server. In Page_Load, we simply check if the hidden field is populated and process accordingly:1//Handle TD Clicked Event when user clicks search results2if (Request.Form["hidTDClickID"] != null && 3 Request.Form["hidTDClickID"].ToString() != "") 4 TDClicked(int.Parse(Request.Form["hidTDClickID"].ToString()));]]> Mon, 03 Dec 2007 22:00:21 GMT http://www.keylimetie.com/~/Blog/2007/12/3/How-to-make-an-AJAX-Postback-with-JavaScript/Default\.aspx http://www.keylimetie.com/Blog/2007/11/20/Convert-Plain-Text-to-MD5-Hash/ ]]> Wed, 21 Nov 2007 04:08:32 GMT http://www.keylimetie.com/~/Blog/2007/11/20/Convert-Plain-Text-to-MD5-Hash/Default\.aspx http://www.keylimetie.com/Blog/2007/11/8/Enable-File-Upload-on-an-AJAX-Webpage/ Fri, 09 Nov 2007 03:51:35 GMT http://www.keylimetie.com/~/Blog/2007/11/8/Enable-File-Upload-on-an-AJAX-Webpage/Default\.aspx http://www.keylimetie.com/Blog/2007/10/11/Speed-Up-Your-Site-8-ASPNET-Performance-Tips/ Thu, 11 Oct 2007 17:17:50 GMT http://www.keylimetie.com/~/Blog/2007/10/11/Speed-Up-Your-Site-8-ASPNET-Performance-Tips/Default\.aspx http://www.keylimetie.com/Blog/2007/9/4/PayPal-Payment-Data-Transfer-PDT-WebControls-Fix/ Tue, 04 Sep 2007 17:16:52 GMT http://www.keylimetie.com/~/Blog/2007/9/4/PayPal-Payment-Data-Transfer-PDT-WebControls-Fix/Default\.aspx http://www.keylimetie.com/Blog/2007/8/1/PayPal-PDT-Sandbox-Setup/ add key="RootURL" value="http://localhost:xxxxx/ProjectName/"/> !-- Sandbox Settings --> add key="PayPalServer" value="https://www.sandbox.paypal.com/cgi-bin/webscr"/> add key="UseSandbox" value="true"/> add key="PayPalEmailAddress" value="Seller email address used to login to Sandbox"/> add key="PayPalPDTID" value="Identity Token from the Website Payment Preferences"/> appSettings> You are finally ready to run the project and make a purchase. When it redirects to PayPal, make sure it goes to https://www.sandbox.paypal.com/cgi-bin/webscr and login using the Buyer Test Account credentials. Complete the purchase and wait for it to redirect back to the project. You should have a message page advising that the transaction failed or was completed. Finally, you can go back to https://developer.paypal.com/, enter Sandbox, login using the Seller credentials, and under My Account - History, see a report of all the transactions posted.]]> Wed, 01 Aug 2007 23:16:08 GMT http://www.keylimetie.com/~/Blog/2007/8/1/PayPal-PDT-Sandbox-Setup/Default\.aspx http://www.keylimetie.com/Blog/2007/7/24/Some-Design-Principles-To-Consider/ Tue, 24 Jul 2007 17:17:11 GMT http://www.keylimetie.com/~/Blog/2007/7/24/Some-Design-Principles-To-Consider/Default\.aspx http://www.keylimetie.com/Blog/2007/7/14/Build-an-iPhone-friendly-webpage/ Sat, 14 Jul 2007 23:21:06 GMT http://www.keylimetie.com/~/Blog/2007/7/14/Build-an-iPhone-friendly-webpage/Default\.aspx http://www.keylimetie.com/Blog/2007/7/12/I-Forgot-The-sa-Account-Password/ Thu, 12 Jul 2007 16:47:12 GMT http://www.keylimetie.com/~/Blog/2007/7/12/I-Forgot-The-sa-Account-Password/Default\.aspx http://www.keylimetie.com/Blog/2007/7/4/Dynamic-Connection-Strings-Microsoft-DAAB/ Wed, 04 Jul 2007 16:00:24 GMT http://www.keylimetie.com/~/Blog/2007/7/4/Dynamic-Connection-Strings-Microsoft-DAAB/Default\.aspx http://www.keylimetie.com/Blog/2007/6/27/Re-Enable-A-Disabled-SQL-Server-2005-Service-Broker/ Wed, 27 Jun 2007 23:56:53 GMT http://www.keylimetie.com/~/Blog/2007/6/27/Re-Enable-A-Disabled-SQL-Server-2005-Service-Broker/Default\.aspx