Database operations in WPF applicationI 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.