Archive for the ‘ C#’ Category

select …,…, case result
when 1
then ‘Pass’
when 0
then ‘Fail’
end as ‘Result’


Number To English

Posted: July 28, 2009 in C#

NumberToEnglish conWord = new NumberToEnglish();

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

DataRow row2;

row2 = dt.Rows[0];

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

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

RemAmount = RemAmount – HeadTotalAmount;

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
Naming conventions
Interoperability and portability

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:

fxcop1 copy


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;

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…