Monthly Archives: March 2012

Autosuggest TextBox from database column in Windows Forms

In this article we will see how to create an autosuggest TextBox that will suggest data from a SQL Server database column Introduction In this article we will create a TextBox that will suggest names from a SQL Server database column FirstName. Typing first few characters will show matching names from the FirstName column as… Read More »

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 create an installer for a WinForm application using Setup Project

In this article I will explain the process of creating an installer for a Windows Form application using Setup Project Introduction In this article we will create a Setup Project to build an installer of a Windows Application. We will create setup for Windows Application created in my last article. Step 1: Create a Setup… 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 »