www.elamparuthi.com

I got some Linq and Sliverlight Ebooks. Just download the Books below
Linq

Sliverlight

Ajax

Regards,
Elam

PHP developers can now integrate data from SQL Server now that the driver is available for download.  Also glad to see that it works with SQL Server Express edition. 

 Microsoft SQL Server 2005 Driver for PHP has released!  This release marks another step in Microsoft’s continued commitment to interoperability.  please check out this team blog.

Regards,

Elam

SQL Server Central have just launched a new series of free SQL Server training videos.

http://www.sqlservercentral.com/Training/

Regards,

Elam

Yesterday I am looking how to read the CSV, then i found that it’s good to use ODBC driver to read it.   Here is code what I used to read the Csv file in c#
string strConn = @”Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:;Extensions=csv,txt”;
try
{ 

OdbcConnection objCSV = new OdbcConnection(strConn);
objCSV.Open();
OdbcCommand oCmd = new OdbcCommand(”select * from THECSVFILE.CSV”, objCSV);
OdbcDataReader oDR = oCmd.ExecuteReader();
while (oDR.read())
{       // Do something     }
oDR.Close();
oCmd.Dispose();
objCSV.Close();
}
catch {}
Use the namespace System.Data.Odbc
In the Connection String, DBQ only points to the directory which contains the CSV files you want to work with. Use the name of the CSV file in the SQL Statement itself, as in the code above

Regards,
Elam

Hi

Yesterday when i am working on one of my ASP application in which we store the password as MD5 hash in database ..   when i trying to make the Application in C# . I felt diffuclut to convert the password string to MD5 Hash ( which is a 32-character string of hexadecimal numbers).  

Then i found a way in asp.net 2.0 we have a namespace called System.Security.Cryptography  in the we have the MD5 Hash function .. here is the code to covert string to MD5 Hash

public string CalculateMD5Hash(string input)
{
    // step 1, calculate MD5 hash from input
    MD5 md5 = System.Security.Cryptography.MD5.Create();
    byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(input);
    byte[] hash = md5.ComputeHash(inputBytes);

    // step 2, convert byte array to hex string
    StringBuilder sb = new StringBuilder();
    for (int i = 0; i < hash.Length; i++)
    {
        sb.Append(hash[i].ToString(”X2″));
    }
    return sb.ToString();
}
An example call:

string hash = CalculateMD5Hash(”abcdefghijklmnopqrstuvwxyz”);…returns a string like this:

C3FCD3D76192E4007DFB496CCA67E13BTo make the hex string use lower-case letters instead of upper-case, replace the single line inside the for loop with this line:

sb.Append(hash[i].ToString(”x2″));The difference is the ToString method parameter

Regards,
Elam

Hi
Yesterday when I am coming across the Asp.net Ajax.. I found the control UpdateProgress . It’s quite easy and good to show the progress images. To add an image like a rotating circle or moving bar to the UpdateProgress Control is super easy.  Go to: http://www.ajaxload.info/ and generate the type of image you would like to display.  Click download image and the image will then be displayed in the browser. Right click on the image and save image to your image folder.  

After that just drag the UpdateProgress to the designer view and then get the image Control and the put it inside the update progress control. Then go to image control property and then add the image URL path…  and also you can add the time to DisplayAfter. 

All done now..
Elam

Hi

Wordpress 2.1 is released , we have some of the new features like Autosave ,lossless XML import and export,tabbed editor,better upload manager …

you can download the wordpress 2.1  here

Regards,

Elam

activeCollab is a free open source project management and collaboration tool. This web-based application is very similar to 37 Signal’s Basecamp project management tool, but instead of a hosted service, activeCollab is an application you download and install on your web server. The tool requires PHP 5.1+ (required extensions: mysql, gd) and MySQL 4.1+ with InnoDB support, so should be easy to install on most hosting packages.

Regards,
Elam

Hi

Today when i was searching internet to get a regular expression to Get the URL from a hyperlink classes, I found it in the site www.regexlib.com , a cool site for regular expression, it has around 1000 expressions. If you need any regular expression, just visit the site you can find it