Sunday, 27 January 2013

Dynamic Digital clock using c# and .net windows application


This post contains the way to add the dynamic digital clock to the .net windows application.

 Click here to download the coding for Dynamic digital clock

screen shot:

Hope it is useful
Thank you
If any doubt and feedback please give your comment bellow.

Wednesday, 23 January 2013

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.


Screen shots:


Fig [1]:  New Student Registration

Fig [2]: Student search by Name

Fig [3]: Student search by Date of joining

Any Query!!!!