Fun With Class Libraries

Here I’m going to show how you can use class libraries so you can use the same code across multiple applications. This can save time on typing multiple lines of the same code across different types of applications. For the example I’ll use code from a class library in an ASP form along with a Windows application. Now you might run into some issues along the way. Such as formatting that I ran into going from an ASP application to a WinForm application.

You can find the source code to both the ASP and C# Winforms Downloads section.

Continue reading

Employee Database Program

EmployeeDatabase EmployeeDatabaseXSD EmployeeDatabaseMainScreen

EditEmployeeScreen ViewDeparmentsScreen

Hello again. I’ll be expanding more on using a database with C# .NET with this project. Again this program is meant for a small company since it’s using an Access Database to store the data. I’ll be putting out an SQL version at a later time for bigger companies that might have data bigger than 2GB.

I’ve been working on an employee database for a client. This is the “almost finished” version of it. I didn’t really want to wait and put the final product up on this blog because of all the little details gone into it so far. I’ll make another post later on with the finished product.

In the program you have the ability to track employee information such as employee ID, what department they’re in, first/last name, salary, address, state, zip, etc.., along with some other items you can see from the screenshots below. You can also edit employee information after it’s been entered along with a drag and drop feature for an employee photo.

You also have the ability to track the various departments in your company. The last piece I was talking about earlier is the ability to edit the departments after they’ve been entered. This is the last piece I have to get working. The client didn’t need this particular functionality, however, it’s something I will include in the final piece.

Remember you can download the source to this program or the actual program itself on my downloads page.

Cheers

Tails8

Continue reading

Bill Pay Tracker – More .NET Database Stuff

MyMoney MyMoneyDataset

MainForm CategoriesForm

CategoriesBreakdownForm ViewNotesForm

Here’s another take on using a database with C# .NET. THis is a small bill-pay program that’s used to keep track of expenses and payments. There’s a lot going on here so bear with me on the screenshots. I’ll try to explain each one as best as I can. If you prefer to skip it and go ahead to view the code or source then go on ahead. Also take note that I added a context menu not shown in the screenshots. This menu gives you the ability to do various tasks in each form.

Continue reading

Address Book – .NET Database Access Intro

Addresses AddressesInterface

AddressesDataSet

This is my first stab at using C# .NET to access a simple database. The database is a simple Microsoft Access database. However this has showed me what you can do when a program can store information in a database. Really cool stuff!!! I’ve included 3 screenshots this time. Along with the Class Designer and Interface screenshots, there’s an overview if the dataset tables. Each dataset is doing simple SELECT and FROM queries from the main database. I’m also using the default binding navigator to scroll thru, delete, and save the changed data. And I also enabled a drag and drop feature on the picture box to upload a picture. Also if you laugh at the sample employees and where they come from kudos. You share my sense of humor. Now onto the code. Or you can download the source for yourself.

Cheers
Tails8

Continue reading

Iggy Latin Translator – String Manipulation

IggyLatin

IggyLatinInterface

The following program is called an Iggy Lating translator. You’ve heard of Pig Latin right? Well think of this as an off-shoot of Pig Latin. Basically you’re adding the following “ig”, “ggy”, “iggi”, “t”, or “tt” to either the beginning of the word or the end depending on if the word has a vowel or consonant. The letter replacement is done 3 different ways for string manipulation. The 1st way is a regular string method, the 2nd way is using the StringBuilder method, and the 3rd way is using a Regular Expression to add the characters. Call me crazy I actually had more fun messing with the Regular Expressions. I can see how you can use this to make sure only certain information is entered into a WPF form. You will also notice that I used a static class for the conversions. This way I don’t don’t have to create and instance of the class. I can just call the class directly. Now onto the code. Or you can download the source.

Cheers
Wierdguy

Continue reading