Tag Archives: .NET

Learning SQL

Posted by on October 4, 2010 No comments

This past week or two, I’ve been working on a small project to help me learn SQL, specifically SQL Server 2008. This application is a task management application written in C# .NET as a Winforms project. The kind of task management we’re talking about here is something a programmer might use to keep track of what they’re working on and how many hours it took.

So far I have to say SQL has been trivial. In as little as two days I’ve mastered database concepts and designs, SQL syntax, .NET System.Data.Sql interfaces, and the following features of SQL:

  • SQL commands: Select, Where, Insert, etc.
  • Table Joins (Inner, Left, Right, Full)
  • Stored Procedures
  • Table Constraints
  • Primary Keys
  • Foreign Keys

Right now the only thing I have to figure out is how to package and distribute my application so I can place it on my website under my Portfolios section. My application will need to create the appropriate tables and columns, as well as create the stored procedures and constraints required. Once I get this figured out, it most certainly will be available for downloading! For now, please admire the screenshots of this very simple application below.

Password Generator

Posted by on March 7, 2010 No comments

I’ve added a new section of pages under the My Work page dedicated to my C# projects and portfolios. The newest (and currently only) addition to my C# portfolio collection is the Password Generator.

The password generator here is just a simple project and really doesn’t display much proficiency in C# or .NET. I simply wanted to share it with the world because it is for better or worse my first C# project. The tool itself is actually pretty useful. It allows you to choose the length of the generated password as well as control what symbols are included in it, such as capitalization and non-alphanumeric characters.

Pretty soon I’m going to have to host pre-compiled versions of my portfolios on my website so visitors won’t have to compile the sources to get the tools. Up until this point I’ve simply assumed people are more interested in the source code, but I could be wrong!

Stay tuned because I’m going to have more “advanced” C# portfolios on the way.