Convert Image to Icon in .Net

1. ///
2. /// Converts an image into an icon.
3. ///
4. /// The image that shall become an icon
5. /// The width and height of the icon. Standard
6. /// sizes are 16x16, 32x32, 48x48, 64x64.
7. /// Whether the image should be squashed into a
8. /// square or whether whitespace should be put around it.
9. /// An icon!!
10. private Icon MakeIcon(Image img, int size, bool keepAspectRatio) {
11. Bitmap square = new Bitmap(size, size); // create new bitmap
12. Graphics g = Graphics.FromImage(square); // allow drawing to it
14. int x, y, w, h; // dimensions for new image
16. if(!keepAspectRatio || img.Height == img.Width) {
17. // just fill the square
18. x = y = 0; // set x and y to 0
19. w = h = size; // set width and height to size
20. } else {
21. // work out the aspect ratio
22. float r = (float)img.Width / (float)img.Height;
24. // set dimensions accordingly to fit inside size^2 square
25. if(r > 1) { // w is bigger, so divide h by r
26. w = size;
27. h = (int)((float)size / r);
28. x = 0; y = (size - h) / 2; // center the image
29. } else { // h is bigger, so multiply w by r
30. w = (int)((float)size * r);
31. h = size;
32. y = 0; x = (size - w) / 2; // center the image
33. }
34. }
36. // make the image shrink nicely by using HighQualityBicubic mode
37. g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
38. g.DrawImage(img, x, y, w, h); // draw image with specified dimensions
39. g.Flush(); // make sure all drawing operations complete before we get the icon
41. // following line would work directly on any image, but then
42. // it wouldn't look as nice.
43. return Icon.FromHandle(square.GetHicon());
44. }

Creating CSV file using Oledb object in C#.net

OleDbConnection OleDbCon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strCSVPath + ";Extended Properties=\"text;HDR=Yes;FMT=Delimited(,)\"");
OleDbCmd = new OleDbCommand("Create table BundlesTable.csv(ProjectName varchar(250),BundleName varchar(250),BundleItems varchar(250))", OleDbCon);
OleDbCmd.ExecuteNonQuery();

Visual Studio Windows Application Setup Project

http://www.codeproject.com/KB/dotnet/Win_App_Setup_Project.aspx

Converting numbers into formatted strings in VB.NET

http://articles.techrepublic.com.com/5100-10878_11-6103431.html