Reader Level:
ARTICLE

Database operations in WPF application

Posted by Rahul Kumar Saxena Articles | WPF February 25, 2010
In this article I demonstrated a small project report on School management System in WPF.
  • 1
  • 0
  • 43010
Download Files:
 

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" ?>

<configuration>

    <configSections>

    </configSections>

    <connectionStrings>

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

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

            providerName="System.Data.SqlClient" />

    </connectionStrings>

</configuration>

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..

Login.png

Image 1. 

After Login the main window will open.

SMSMain.png 

Image 2.

From the menu item you can select Student/ Teacher.

With Student menu you can add new student.

AddStudent.png

Image 3.

You can view all student.

AllStudent.png

Image 4.

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

EditDeleteStudent.png 

Image 5.

If you select Teacher-> Add New Teacher

AddTeacher.png

Image 6. 

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

EditDeleteteacher.png

Image 7.

Article Extensions
Contents added by arthur gitau on Jan 30, 2013
cant find sorce code download ?
COMMENT USING

Trending up