Posts

Showing posts from September 3, 2011

ASP.NET DataTable To Excel

    EXPORT DATA FROM DATATABLE TO EXCEL IN ASP.NET VB - Code Public Sub ExportExcel(ByVal Datadt As DataTable)         Dim dt as new datatable         dt = Datadt                Dim attachment As String = "attachment; filename=" & System.DateTime.Now.[Date].ToShortDateString() & "_SalesReport.xls"         Response.ClearContent()         Response.AddHeader("content-disposition", attachment)         Response.ContentType = "application/vnd.ms-excel"         Dim tab As String = ""         For Each dc As DataColumn In dt.Columns             Response.Write(tab + dc.ColumnName)             tab = vbTab         Next         Response.Write(vbLf)         Dim i As Integer         For Each dr As DataRow In dt.Rows             tab = ""             For i = 0 To dt.Columns.Count - 1                 Response.Write(tab & dr(i).ToString())                 tab = vbTab             Next

Localizing ASP.NET Application

   Localizing an ASP.NET Application Globalization is the process of designing and developing applications that function for multiple cultures, and localization is the process of customizing your application for a given culture and locale. The topics in this section describe how to create ASP.NET Web applications that can be adapted to different languages and cultures. Example for Localization:- Imports System.Threading.Thread Imports System.Threading Public Class Globalization     Public Sub New()         ' Creating a Global Culture specific to our application.         Dim cultureInfo As New System.Globalization.CultureInfo("en-US")         ' Creating the DateTime Information specific to our application.         Dim dateTimeInfo As New System.Globalization.DateTimeFormatInfo()         ' Defining various date and time formats.         dateTimeInfo.DateSeparator = "/"         dateTimeInfo.LongDatePattern = "MM/dd/yyyy"         dateTimeInfo.S

Expression Web 4 Add-Ins

Some Expression Web 4 Add-Ins: Here are some Expression Web add-ins you can use: Insert Bing Map Add-in   by Mike Calvo ( read his overview  of this add-in) SlapShot for Expression Web 4 v1.1  by JD_MSFT Right Mouse Click prevention    by JD_MSFT Payment Buttons for PayPal   by WebAssist Search for Bing  by WebAssist Horizontal Menu Advancer for Expression Web 4   by CSSMenuTools Accordion Menu Advancer for Expression Web 4   by CSSMenuTools LightBox Advancer for Expression Web 4   by CSSMenuTools Extensibility Tester Add-In Expression Web 4 Add-Ins by fellow MVP  Ian Haynes Copyright Notice Add-In for Expression Web V4 Code Comment Add-In for Expression Web 4 Sub/Sup Text Add-in for Expression Web 4 'Close All' Add-In for Expression Web V4 Other Add-Ins Pure CSS Drop Down Menu Add-in  by  Ajatix Advanced CSS Drop Down Menu  by  Ajatix Vertical Menu Advancer for Expression Web   by CSSMenuTools