Tag Archives: SQL Server

How to store Date and Time in separate columns in SQL Server 2005

In this article I will explain how to store Date and Time in SQL Server 2005 using User Defined Type Introduction In SQL Server 2008 four new data types were added. Two of them are Date and Time for storing date and time as separate data types. But if you need to deal with separate… Read More »

How to show progress of fetching database records using a ProgressBar control in WinForm

In this article we will learn how to show progress of fetching database records using a ProgressBar control in WinForm Introduction: In this article we will use ProgressBar control to show progress of fetching database records in a WinForm. In my last article I used a BackgroundWorker control to fetch database records. I will be… Read More »

How to show asynchronous processing of database records on a WinForm UI using Multithreading

In this article you will learn to show current row on a WinForm User Interface that is being accessed from a SQL Server database Introduction: We have an Employee table of 50000 records in a SQL Server database. We want to load all employees in a ComboBox on a WinForm. By default Windows Form works… Read More »

How to return a DataTable from WCF service

In this article we will see how to return data from a SQL Server table as a DataTable object using WCF service and consume it in a Console application Introduction: In this article first we will create a simple WCF service that will return data of the Employees table as a DataTable object. Then we… Read More »