How to Print a Document without using Crystal Report

Desktop Application provide various features that keep it more strong then other applications. When we talking about printing any document then the first question arrives in our mind is how can we print in .net application. The first solution comes in our mind ‘Using Crystal Report’. As we discussed in past that how to use crystal report today we will go for another method. When we are talking about printing and need to database access inside the form then I will prefer this method.

Read More →

Manage the Desktop Swiftly with DataGrid Applications

Good news for all software developers in the country. Now you can easily manage the applications from the desktop and work on different projects. The application will not only help you to manage your work better, but will also assist in completing the task soon. Now, you can save time by editing all essential facts and figures from the desktop of the system. To get introduced to this unique system, just come to the http://www.dotnetaid.com. Download the software, install and edit all your essential tasks from the desktop application.

Read More →

How to Customize DataGridView Control in .Net Desktop Application

DataGridView control is used in desktop application to show the record values in tabular format, As we used GridView in web application. But the difference is the GridView is easy to customize. We can easily use the paging in gridview. But when we use DataGridView we need to do so manually. There are some functionality that we can apply on datagridview control. We can hide any particular column after fetching the data from the table, we can change the width of the column as well as we can change the header text that we want to put manually.

Read More →

Creating Class file for AutoFill Combobox From Database

A Combobox control in window application is used to show the field values in list as we use DropDown List control in Web Application. And when we fill this combo box control there are two methods. First we fill the field values by adding items manually and in the second method we fill the combo box using Databse table. We need to create a connection with database and then we fill the combo box using data reader or data adapter. But what should the better solution if we have to fill the combobox in multiple pages or form.

Read More →

Transact-SQL : Aggregate Functions

Aggregate function is T-SQL are sued to perform some calculations on multiple records or values in SQL table. Generally we use these function with Group By clause in Select statements. The aggregate functions are performed on a set of value and returns a single value. Also most of these function returns numeric values. In this article you can see that what are the aggregate functions that we can used in SQL.

Read More →

Transact-SQL – Using Try-Catch in Stored Procedure and Error Functions

Try-Catch is used to handling exception in C#. Today we will see that how this is also useful to handle errors in SQL also. The Try-Catch consists of two blocks Try block and Catch block. We just write our statements inside the Try block and when the error generate in the Try block the control is passed to Catch block and there we handle the error by writing statements.

Read More →

How to Normalize a DataBase Table : Step-4 Converting the 2NF to 3NF

The final step for most of databases to be normalized is converting the 2NF to 3NF. After converting the databse into the 3rd normalization form or 3NF most of database are normalized. While converting the 2NF to 3NF we remeber a rule that remove any non-key attributes to a new table that are more dependent on other non-key attributes than a table key.

Read More →

How to Normalize a DataBase Table : Step-3 Converting the 1NF to 2NF

The Next process of normalization is convert the first normalization form 1NF to second normalization form 2NF. In this process we will remove any non-key attributes that only depend on path of the table key to a new table. Enen many data sources normalized after the 2NF but some time we need to proceed for the next step also. But in this article w will see only to convert the 1NF to 2NF.

Read More →

How to Normalize a DataBase Table : Step-2 Converting the UNF to 1NF

As we have seen previously how to convert the data source to Un-Normalized Form also called UNF. Today we will proceed for the next step. In this step we transform the UNF into the first Normalization Form that is called 1NF. To accomplish this we need to remember a rule: we need to remove repeating attributes to a new table. here we will discuss the process to do this.

Read More →

How to Normalize a DataBase Table : Step-1 Converting the Data Source to UNF

Recently we have discusses about normalization and the procedure to normalize the data source. Today we will discuss about for this process. As you know that the first step in normalization is to convert the data source to Unnormalized Form that is also called UNF. If you will follow the process accurately then there will be no errors in the first step of normalization.

Read More →