Recent Posts

Payroll Tables in sql database

122 ViewsCommonly Used Tables: 1 – Employee Master 2 – Address Master 3 – Tax Information Master 4– Pay Code Master 5– Deduction Master 6 – Benefit Master 7 – State Tax Master 8 – Local Tax Master 9 – Employee Summary 10 – Year End Header 11– Year End Wage 12– Work Master 13– Work Master Detail …

Read More »

Calculate time difference for attendance

162 Views I have a table with the below sample output. UserID Checktime CheckStatus 3175 2013-12-22 07:02:10.000 I 3175 2013-12-22 13:01:01.000 O 3175 2013-12-22 13:49:54.000 I 3175 2013-12-22 13:49:55.000 I 3175 2013-12-22 15:58:42.000 O 3175 2013-12-23 06:02:58.000 I 3175 2013-12-23 14:00:29.000 O 3175 2013-12-24 05:17:09.000 I 3175 2013-12-24 12:34:25.000 O …

Read More »

C Sharp DataGridView Database Operations

242 ViewsThe DataGridView can display data in Bound mode, unbound mode and Virtual mode . Bound mode is suitable for managing data using automatic interaction with the data store. One very common use of the DataGridView control is binding to a table in a database. Unbound mode is suitable for …

Read More »
Skip to toolbar