Number To English

NumberToEnglish conWord = new NumberToEnglish();

dt.Columns.Add(“AmountInWord”, Type.GetType(“System.String”));

DataRow row2;

row2 = dt.Rows[0];

row2["AmountInWord"] = conWord.changeCurrencyToWords(sTHeadAmount.ToString());

Compute Function for data table

int TotalAmount = Convert.ToInt32(dtTotalAmt.Compute(“SUM(amount_pay)”, “amount_pay > 0″));

RemAmount = RemAmount – HeadTotalAmount;

FxCop – code analysis tool

FxCop is a code analysis tool that checks .NET managed code assemblies for conformance to the Microsoft .NET Framework Design Guidelines. It uses MSIL parsing, and callgraph analysis to inspect assemblies for more than 200 defects in the following areas:

Library design
Globalization
Naming conventions
Performance
Interoperability and portability
Security
Usage

FxCop includes both GUI and command line versions of the tool and supports analyzing .NET 1.x, .NET 2.0 and .NET 3.x components.

This version provides support for .NET 3.5 SP1.

More Information visit and download:

http://msdn.microsoft.com/en-us/library/bb429476(VS.80).aspx

http://www.microsoft.com/downloads/details.aspx?familyid=9AEAA970-F281-4FB0-ABA1-D59D7ED09772&displaylang=en#QuickInfoContainer

Date Difference in Asp.net

string startDate = “4/24/2007″;

string endDate = “3/24/2007″;

DateTime sDate = Convert.ToDateTime(startDate);

DateTime eDate = Convert.ToDateTime(endDate);

TimeSpan dateDiff = eDate.Subtract(sDate);

int days = dateDifference.Days;

Dynamic Crystal report in Asp.net Export Data to Excel

In this example two tasks are covered

1. Crystal Report with dynamic column

2. Export data table

Download Here Dynamic Report and Export to Excel

Allow editing in debugging mode

Allow editing in debugging mode

Uncheck this check box, YES UNCHECK and see…