How to generate payslip in ASP.Net With Microsoft Sql Database ?

Know More : Microsoft ASP.Net  Microsoft VB.Net  Microsoft C#.Net  Microsoft Sliverlight  XMLMicrosoft WPF  Microsoft WCF Ajax Microsoft SQL Server


Let's start  in Microsoft Microsoft Visual Studio 2008 with Microsoft SQL server 2008. Open Microsoft visual studio 2008 in administrator  mode . After go to file menu select new website.



Select asp new website and click OK.

Type the name of website. if the website already exits then click OK.

Now select datalist control from toolbox data menu.
Like this...


Again drag sqldatasource  control from toolbox data menu like this..

Next ...

or use new sql connection ..

after click  new connection ' add connection form open' like this use step shown in figure.

After connection created. Now data binding with Datalist control like this ..

After binding

Click on edit templates as shown in figure..

After click on edit templates select item template .Your data binding  column (your Sql table Column Show in templates ). Shown in figure like this..

Select column and delete it . After delete item template shown like this...


Also drag label control from toolbox and rename and binding column according to you. . Or design payslip according to you.

Also drag Textbox control from toolbox and rename and binding column according to you. . Or design payslip according to you.

After complete your payslip design , binding labels and texboxes according to you . Click on end templates
of datalist control as shown in figure..

Now debug your web page or view in browser as shown in figure...

In Browser , payslip is shown in figure..like this.

Now your payslip is completed. Thanks.


Know More : Microsoft ASP.Net  Microsoft VB.Net  Microsoft C#.Net  Microsoft Sliverlight  XMLMicrosoft WPF  Microsoft WCF Ajax Microsoft SQL Server