User Id :    Password :      New Member   Forgot Password
 
Database operations in WPF application
Description In this article I demonstrated a small project report on School management System in WPF.   No. of Views     943
  Rating     0
Author Rahul Saxena   Posted On     26 Nov 2011
Tags WPF    

Sample Code   Download Code

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

 


 

After Login the main window will open.

 

 

From the menu item you can select Student/ Teacher.

With Student menu you can add new student.


 

 

You can view all student.

 

 

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

 

 

If you select Teacher-> Add New Teacher

 

 

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

 

 

About Author

About Author Rahul shows great interests in working with Microsoft technologies. He specializes in the implementation of DataBase & Graphics. His area of expertise includes: C#, ASP.NET,ADO.NET,Windows Forms & Web Services. He hails from background , Master's in Computer Application. With programming he loves photography, traveling and reading books. Rahul Saxena
No Photo
 
Country India
Company N/A
Home Page N/A

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

     
Write your comment here.  
Comment
Verification Code   
  
    
 
Section sponsored by