Reader Level:

Database operations in WPF application

By Rahul Saxena on Feb 25, 2010
In this article I demonstrated a small project report on School management System in WPF.

Hi this is my PROJECT series which I posted on this site. My previously posted projects are in .NET 2.0 and web based too. Previously my posted projects are.

1.    Social Networking web application example

2.    MyCollegeMyFriend - An Open Source Project developed using ASP.NET 2.0 

3.    Building a Friends Networking Website 

4.    On-line Address Book in ASP.NET 2.0

So now I am going to post a project on School Management system which I developed in .NET 3.5 (WPF). It's a window based project.

In this project an authorized person can Add, Delete, Update and view students and teachers records. I did all edit, delete, create, and read in this project. You can find database file in DATA folder inside application. My database file name is SMS (School Management System). To run this project just add this database and change connection string. I used here typed data set.

To run the application just add the database and change the connection string in App.config file like... 

<?xml version="1.0" encoding="utf-8" ?>





        <add name="SchoolManagementSystem.Properties.Settings.SMSConnectionString"

            connectionString="Data Source=Rahul\SQLSERVER2005;Initial Catalog=SMS;User ID=sa;Password=wintellect"

            providerName="System.Data.SqlClient" />



Now I am going to show the working of my application. When you run the application there is a login window, after login you will redirect to main window of application from where you can do all operation which are available in my application like from menu item you can add student, view all student, add new teacher and view all teacher like..


Image 1. 

After Login the main window will open.


Image 2.

From the menu item you can select Student/ Teacher.

With Student menu you can add new student.


Image 3.

You can view all student.


Image 4.

Here by double clicking on any record you can delete or update the record.


Image 5.

If you select Teacher-> Add New Teacher


Image 6. 

Teacher -> All Teacher.  You can delete and update by double clicking on any  record.


Image 7.

Rahul Saxena
Rahul Saxena

Rahul K Saxena is working as a Technical Analyst in Noida, India. He is Masters in Computers Application. Here in the IT industry for more than 6+ years and his main technical skills include SharePoint 2010, MOSS 2007, ... Read more



JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.

Trending up