tag:blogger.com,1999:blog-5117896821680349576Sat, 14 Sep 2024 14:49:56 +0000ErrorsAsyncFileUploadGenerate Word documentGridViewSQLDataSourceajax control toolkitexport excelformattingConnectionStringsCreate dynamic DataTableDataTableDateTimeDynamic SQL Queries in Stored ProcedureExport GridView to Microsoft WordFacebookFormViewImageImage from StreamMembershipOpenXMLPDFPassword RecoveryReportViewer Web ControlSQLSession ManagementStored ProcedureWeb.configcombo boxcreate SqlDataSource programmaticallydatedeletefree asp.net hostingmono projecpopulatesortsortinghttp://deaspdotnet.blogspot.com/noreply@blogger.com (Unknown)Blogger71125en-usnonoreply@blogger.comtag:blogger.com,1999:blog-5117896821680349576.post-3791744613992175949Mon, 06 Aug 2012 03:01:00 +00002012-08-06T11:10:33.508+08:00AsyncFileUploadErrors  I upgraded my ASP.NET framework from 3.5 to 4 recently, and encountered a host of problems. I knew the problem was due to the upgrade because I had not changed my code, and yet, there were parts of the system that went haywire with seemingly esoteric errors. Today, I got the error below when I tried to upload images on a web page that was working perfectly before.   Fortunately, the http://deaspdotnet.blogspot.com/2012/08/unhandled-exception-file-attached-is.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-2243968906566091202Thu, 02 Aug 2012 03:41:00 +00002012-08-02T22:45:43.309+08:00Generate Word document I wrote an entry sometime back in Jan 2011 to show how you can easily generate a Word document using the OpenXML SDK with font size, font color and bold formatting. Yesterday, I received a comment from Hema, who asked me how to add subscript and superscript formatting. To tell the truth, I had not dabbled in those before.  But I decided since I have already come so far, I can just spendhttp://deaspdotnet.blogspot.com/2012/08/applying-superscript-and-subscript-to.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-3965120650737364546Wed, 01 Aug 2012 03:22:00 +00002012-08-02T22:27:13.662+08:00Errors This morning, I created a ASP.NET using the default application and not touching any of the default code, I tested it successfully with the built-in web server Visual Studio 2010.  Next, I happily clicked on the “Publish Web Site” menu item and deployed it on the local IIS. Since I did not even do anything to the default code, I thought there would be no problem when I try to call this webhttp://deaspdotnet.blogspot.com/2012/08/how-to-solve-error-unrecognized-element.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-1424679711544602817Wed, 01 Aug 2012 02:37:00 +00002012-08-01T10:37:32.442+08:00Errors  I got this error after I ran a “C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319>aspnet_regiis –i” command. Apparently, it happens when you run an older version of ASP.NET application on an IIS server that has been upgraded to use the ASP.NET Framework 4.0. I found the way to solve this problem via Brad Kingsley’s tip . All you need to do is to edit your web.config and comment out the http://deaspdotnet.blogspot.com/2012/08/how-to-solve-there-is-duplicate.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-8713913230102006325Fri, 01 Jun 2012 01:35:00 +00002012-06-01T09:35:01.675+08:00Session Management  Assorted links from othershttp://www.codeproject.com/Articles/227382/Alert-Session-Time-out-in-ASP-Net http://deaspdotnet.blogspot.com/2012/06/aspnet-session-management.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-7188281002050548941Thu, 17 May 2012 07:57:00 +00002012-05-17T15:57:08.581+08:00  If you need a command-line tool that you can include in your batch files to change the NTFS permissions of files or folders, you can use the following tool from Microsoft. Download iCACLS : http://support.microsoft.com/kb/919240Article from ss64: http://ss64.com/nt/icacls.html For example, the command below gives icacls c:\inetpub\wwwroot\files\ /grant mary:(M,WDAC)NOTE: xcacls is http://deaspdotnet.blogspot.com/2012/05/how-to-change-ntfs-permissions-for.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-6653598452092822859Wed, 16 May 2012 09:25:00 +00002012-05-16T17:25:08.723+08:00  Following the instructions below solved my problem :) http://learn.iis.net/page.aspx/624/application-pool-identities/ http://deaspdotnet.blogspot.com/2012/05/login-failed-for-user.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-887427235597093395Wed, 16 May 2012 08:41:00 +00002012-05-16T16:41:48.532+08:00  I encountered the following error "The type or namespace name 'Interop' does not exist in the namespace 'Microsoft.Office' " Found a working solution in one of the posts in this thread. Here’s what I did: Download the Microsoft Office 2010: Primary Interop Assemblies Redistributable at this link. Installed the software; it would extract as a setup file named “o2010pia.msi” Navigated to http://deaspdotnet.blogspot.com/2012/05/type-or-namespace-name-does-not-exist.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-6583034665952617781Wed, 16 May 2012 08:05:00 +00002012-05-16T16:18:23.047+08:00ErrorsIf you encounter this error "The type or namespace 'Packaging' does not exist in the namespace 'System.IO', here's an easy way to solve it.Just locate the <assemblies> tag in your web.config file and add this line.  It should resolve the compilation errors straightaway.<add assembly="WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> http://deaspdotnet.blogspot.com/2012/05/how-to-solve-the-type-or-namespace.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-8019639863847972461Wed, 21 Dec 2011 14:04:00 +00002012-08-02T10:53:36.296+08:00Generate Word document I first dabbled with the OpenXML SDK 2.0 in January 2011. At that time, there was a problem which I could not solve: specifying different font sizes, font colors and bolding effects for different words on the same line. I managed to achieve different formatting effects for sentences on different lines, but never managed to get it working if the words were on the same line. Today, I finally http://deaspdotnet.blogspot.com/2011/12/new-version-of-wordxml-document-using.htmlnoreply@blogger.com (Unknown)1tag:blogger.com,1999:blog-5117896821680349576.post-8910846422198688551Mon, 24 Oct 2011 05:28:00 +00002011-10-24T13:28:13.000+08:00  This is a very short code snippet which shows you how you can create a hyperlink using a QueryString or Form parameter received from a referring page. Note that you would need to do two things in order for this to work: Step 1First, paste the code below in the HTML markup.  The code below assumes that you are using a querystring parameter called “ID” that was passed over from a http://deaspdotnet.blogspot.com/2011/10/create-hyperlink-using-querystring-or.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-1924423514284289547Fri, 25 Feb 2011 13:33:00 +00002011-02-25T21:33:35.797+08:00PDFPDF24 Javascript PDF APIhttp://deaspdotnet.blogspot.com/2011/02/pdf24-javascript-pdf-api.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-8824874947814548496Wed, 23 Feb 2011 09:13:00 +00002011-02-23T17:15:43.260+08:00Password RecoveryHow to: Enable User Password Recovery Using the ASP.NET PasswordRecovery Control How to: Install and Configure SMTP Virtual Servers in IIS 6.0 Solving exceptions when doing password recoveryhttp://deaspdotnet.blogspot.com/2011/02/how-to-enable-user-password-recovery.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-2818978750000577263Wed, 23 Feb 2011 09:11:00 +00002011-02-23T17:11:15.715+08:00asp.net - Hashed passwords and PasswordRecovery control - Stack Overflow: "UPDATE:1) For some reason it works now. Namely, if we set requiresQuestionAndAnswer to false, then PR also sends email to firstUser2) If passwords are stored in hashed form, then if:a) enablePasswordRetrieval='true' and enablePasswordReset is set to either true or false --> PR generates exceptionb) if http://deaspdotnet.blogspot.com/2011/02/aspnet-hashed-passwords-and.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-3790330194107365070Tue, 22 Feb 2011 02:11:00 +00002011-02-22T10:12:34.485+08:00ConnectionStringscreate SqlDataSource programmaticallyWeb.configusing System.Configuration; using System.Data; public static string GetUserName(string userid){ string fullname = "Unknown name"; string connString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString; string sqlString = "SELECT * FROM Users WHERE UserID=@UserID"; SqlDataSource sqldatasource = new SqlDataSource(connString, sqlString); http://deaspdotnet.blogspot.com/2011/02/how-to-read-connection-strings-from.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-5338352603894081465Mon, 14 Feb 2011 03:51:00 +00002011-02-14T11:51:25.261+08:00MembershipMembershipUser Class (System.Web.Security)http://deaspdotnet.blogspot.com/2011/02/membershipuser-class-systemwebsecurity.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-427001054779314721Mon, 14 Feb 2011 02:40:00 +00002011-02-14T10:40:15.448+08:00Step 1======Add a reference to assemblyStep 2======Add this before the class headerusing System.Configuration;Step 3======Access the configuration setting using this code:System.Configuration.ConfigurationManager.AppSettings["WebMasterEmail"]http://deaspdotnet.blogspot.com/2011/02/using-configurationmanagerappsettings.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-7006776777512855223Tue, 01 Feb 2011 18:02:00 +00002011-02-02T02:02:30.549+08:00  protected void ButtonSearch_Click(object sender, EventArgs e) { string criterias = ""; criterias = TextBoxKeyword.Text.Length > 0 ? (criterias + "Keyword") : criterias; criterias = TextBoxCourse.Text.Length > 0 ? (criterias + "Course") : criterias; criterias = TextBoxStartDate.Text.Length > 0 ? (criterias + "EventDate") : criterias; criterias http://deaspdotnet.blogspot.com/2011/02/search-form-code-behind.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-8250314491478225475Tue, 01 Feb 2011 18:01:00 +00002011-02-02T02:01:51.633+08:00  Remember to add the AjaxControlToolkit as reference first.<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="TestSearch.aspx.cs" Inherits="Track_TestSearch" %><%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %><asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">&http://deaspdotnet.blogspot.com/2011/02/search-form.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-8961168859764698058Tue, 01 Feb 2011 18:00:00 +00002011-02-02T02:00:39.662+08:00 USE [MyDB]GO/****** Object: StoredProcedure [dbo].[GetEventsByCriteria] Script Date: 02/02/2011 01:32:22 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET DATEFORMAT DMYGOcreate PROCEDURE [dbo].[GetEventsByCriteria6]( @Criteria nvarchar(255), @Keyword nvarchar(255), @Course nvarchar(255), @EventStartDate nvarchar(25), @EventEndDate nvarchar(25), @DateOfEntryStart nvarchar(http://deaspdotnet.blogspot.com/2011/02/generic-dynamically-constructed-sql.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-1185219383528801572Tue, 01 Feb 2011 09:29:00 +00002011-02-01T22:08:06.138+08:00Dynamic SQL Queries in Stored ProcedureBuilding Statements at Run Time: "EXEC sp_executesql @SQLString GO" USE [MyDB] SET DATEFORMAT DMY GO /****** Object:  StoredProcedure [dbo].[GetEventsByCriteria]    Script Date: 02/01/2011 21:01:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter PROCEDURE [dbo].[GetEventsByCriteria] (   @EventStartDate nvarchar(25) ) As DECLARE @SQLString NVARCHAR(500) http://deaspdotnet.blogspot.com/2011/02/building-statements-at-run-time.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-2585961227680011469Mon, 31 Jan 2011 15:59:00 +00002011-01-31T23:59:52.335+08:00Generate Word documentOpenXML  Step 1Install OpenXML SDK 2.0. You can download from here: Step 2Add these assemblies: OpenXML SDK (browse to the folder where you installed OpenXML SDK) Windows Base <assemblies><add assembly="DocumentFormat.OpenXml, Version=2.0.5022.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>            <add assembly="http://deaspdotnet.blogspot.com/2011/01/create-word-2007-document-using-openxml.htmlnoreply@blogger.com (Unknown)3tag:blogger.com,1999:blog-5117896821680349576.post-1327483928669137785Mon, 31 Jan 2011 12:10:00 +00002011-01-31T20:10:24.782+08:00Generating Microsoft Office Documents with the Open XML SDKhttp://deaspdotnet.blogspot.com/2011/01/generating-microsoft-office-documents_599.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-5343515302791145641Mon, 31 Jan 2011 12:06:00 +00002011-01-31T20:06:04.709+08:00Word 2010 Technical Articleshttp://deaspdotnet.blogspot.com/2011/01/word-2010-technical-articles.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-5117896821680349576.post-102565434189194991Mon, 31 Jan 2011 12:05:00 +00002011-01-31T20:05:29.362+08:00Creating Open XML WordprocessingML Tables with Vertically Merged Cellshttp://deaspdotnet.blogspot.com/2011/01/creating-open-xml-wordprocessingml.htmlnoreply@blogger.com (Unknown)0