Simple Student Information System in C# windows application using SQL SERVER 2008

This article gives the basic window application program with the SQL SERVER as the back-end for the beginners in .net programming.

The following steps are used to create the windows application in .net.

1. Open visual studio 2010.

2. Open visual studio->new->project

3. Open a new visual C# windows application.

4. Add the required forms.

Database:

The following are the steps to create database using query in SQL SERVER 2008

1.       Open SQL SERVER 2008.
2.           Open a new query window.
3.            Type the following code to create the database student.

              create database student;

               Now select the code and execute the code for database creation.

     4. After creating the database use the database to create tables.

     use student;

    Now select the code and execute the code to use the particular database.

5. Create the table info by the following code.

create table info(rollno nvarchar(20)not null primary key,sname nvarchar(50),gen nvarchar(10),dob date,addr nvarchar(100),phno bigint,cname nvarchar(100),jdt date);

Now select the code and execute the code to create the table.

C# coding :
Click here to download the coding

Screen shots:

Fig [1]:  New Student Registration

Fig [2]: Student search by Name

Fig [3]: Student search by Date of joining

Any Query!!!!