Archive for October, 2007

Some advice about maintain an email inbox clean and organized: http://blogs.msdn.com/jmeier/archive/2007/06/07/clearing-your-inbox.aspx

Essays on Lean software engineering: http://leansoftwareengineering.com/

Collection of links to patterns and practices http://blogs.msdn.com/jmeier/archive/2007/10/12/links-patterns-and-practices-resources.aspx

Read Full Post »

Microsoft will release a new MVC Framework for ASP.NET http://weblogs.asp.net/scottgu/archive/2007/10/14/asp-net-mvc-framework.aspx

Facebook.NET, an ASP.NET framework to develop application for facebook http://www.nikhilk.net/FacebookNET.aspx 

and a Visual Studio 2005 Starter Kit for Facebook http://www.stevetrefethen.com/blog/VSNETStarterKitForNikhilKotharisFacebookNET.aspx

Read Full Post »

Good Links – Oct 11, 2007

UC Berkley Courses as webcasts and podcasts: http://webcast.berkeley.edu/courses.php

About the great online resources in the .edu domain http://lifehacker.com/software/technophilia/discover-the-edu-underground-307427.php

Some Software development methodlogies (humor) : http://www.scottberkun.com/blog/2007/asshole-driven-development/

Tangible FREE modelling tools for Visual Studio.NET: http://www.tangiblearchitect.net/modellingtools.html 

Read Full Post »

A Method to return Sheets Names in an EXCEL file using C# ADO.NET

        public static List<string> GetSheetsNames(string path)
            List<string> sheets = new List<string>();

            string connectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;” +
                “Data Source=” + path + “;” +
                @”Extended Properties=””Excel 8.0;HDR=YES;”””;

            DbProviderFactory factory = DbProviderFactories.GetFactory(“System.Data.OleDb”);
            DbConnection connection = factory.CreateConnection();
            connection.ConnectionString = connectionString;
            DataTable tbl = connection.GetSchema(“Tables”);
            foreach (DataRow row in tbl.Rows)
                string sheetName = (string)row[“TABLE_NAME”];
                if (sheetName.EndsWith(“$”))
                    sheetName = sheetName.Substring(0, sheetName.Length – 1);
            return sheets;
Note that the schema has each sheet name ending with $. you must have the $ in the sheet name in order to read from or write to the excel using ADO.NET

Read Full Post »

Screen Print & Capture 32 3.5 is a very handy screen capture utility. It can be downloaded from http://www.download.com/Screen-Print-Capture-32/3000-2384_4-10188787.html?tag=pdp_prod. It is freeware.

Once configured, it can remain in the system tray and whenever you need to take a screen shot (either full screen or just the active window) simply click the print screen button and that’s it. The application will take a screen shot, save it in the folder you chose , with the format you chose and with the naming convention you chose.

For someone who needs to send screen caputres to clients, this tool can save a lot of time and make the process very easy especially if they need to crop the images( to only send the active window)

Read Full Post »

SSW Standard Rules

SSW is a Sydney based Consulting firms. They published (and frequently update) a very popular set of best practices covering various areas in software development along with other miscellaneous topics(as far as booking airline tickets).

Here find the list (copied from http://us.ssw.com.au/ssw/Standards/default.aspx )

The links point to SSW web site.

  1. Rules to Successful Projects* Popular *
  2. Rules to Successful Project Management
  3. Rules to Managing Software Consultants
  4. Rules to Better Team Members
  5. Rules to Managing Your Dead Time
  6. Rules to Better Project Manager Methodology
  7. Using SSW eXtreme Emails! to Manage Projects
  8. Rules to Better Accounting
    .NET/SQL/TFS Code & Application Design
  9. Rules to Better Code
  10. Rules to Better SQL Server Databases
  11. Rules to Better .NET Projects
  12. Rules to Better Large .NET projects
  13. Rules to Better Windows Forms
  14. Rules to Better Windows Forms – Click Once
  15. Rules to Better Unit Tests
  16. Rules to Better Source Control
  17. Rules to Better Setups
  18. Rules to Better Interfaces
  19. Rules to Better Developer Methodology
  20. Rules to Better VB6 Migration to .NET
  21. Rules to Better DotNetNuke Development
  22. Rules to Better Project Management with TFS
    Access Code & Application Design
  23. Rules to Better Access Applications (front-ends inc. queries)
  24. Rules to Better Access UI
  25. Rules to Better Access Databases (back-ends)
  26. Rules to Upsizing your Access Database to SQL Server
    Web Sites
  27. Rules to Better Websites – Navigation
  28. Rules to Better Websites – Layout & Formatting
  29. Rules to Better Websites – Development
  30. Rules to Better Websites – Branding and Marketing
  31. Rules to Better Websites – Online Transactions
  32. Rules to Better Websites – Graphics
  33. Rules to Better Websites – Tuning and Maintenance
    Operating Systems
  34. Rules to Better Windows Vista Deployment
  35. Rules to Better Email * Popular *
  36. Rules to Better Instant Messenger
    Reporting Solutions
  37. Rules to Better Business Intelligence
  38. Rules to Better MS SQL Reporting Services
  39. Rules to Better Google Rankings * Popular *
  40. Rules to Better Outbound Calls
  41. Rules to Better Inbound Calls
  42. Rules to Better Marketing
  43. Rules to Better Branding
  44. Rules to Better Windows 2003
  45. Rules to Better ISA Server
  46. Rules to Better Networks
  47. Rules to Better Virtual PCs
    Microsoft CRM
  48. Rules to Better Microsoft CRM
    The Best Third Party Tools
  49. Introduction
  50. The Best Tools for .NET (General)
  51. The Best Tools for Web Development
  52. The Best Tools for Web Development (ASP.NET Controls)
  53. The Best Tools for Windows Forms
  54. The Best Tools for Windows Forms Development
  55. The Best Tools for SQL Server
  56. The Best Tools for Access
  57. The Best Tools for Outlook
  58. The Best Tools for Internet Explorer
  59. The Best Tools for Windows
  60. The Best Tools for Network
  61. The Best Tools for Exchange Server
  62. The Best Tools for Pocket PC
  63. The Best Image Libraries
    Naming Conventions
  64. SQL Server Object Naming Conventions
  65. SQL Server Index Naming Conventions
  66. SQL Server Relationship Naming Conventions
  67. SQL Server Stored Procedure Naming Conventions
  68. SQL Server Stored Procedure Formatting Standards
  69. .NET Object Naming Conventions
  70. .NET Project Naming
  71. Rules to Better Technical Documentation
  72. Rules to booking better flights

Read Full Post »

Based on the lessons learnde from NUnit, XUnit was born to try to solve the problems encountered by NUnit as well as add many new features

There author explains the advantages of XUnit and its edge over NUnit here (http://jamesnewkirk.typepad.com/posts/2007/09/announcing-xuni.html)

Latest version can be downloaded here (http://www.codeplex.com/xunit)

Read Full Post »

Older Posts »