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
- Open SQL SERVER 2008.
- Open a new query window.
- 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.
Screen shots:
Fig [1]: New Student Registration
Fig [2]: Student search by Name
Fig [3]: Student search by Date of joining
Any Query!!!!