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 [...]
2013Wed10Apr
How to Normalize a DataBase Table : Step-2 Converting the UNF to 1NF
Filed in ASP.NET, SQLAs 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 [...]
The Normalisation is a data analysis technique to design a database system. The Normalisation allows the database designer to understand the current data structure within an organisation. The end result of a normalisation is a set of entity. We remove the unnecessary redudency by normalising the database table.
While working with database we need to store our information time to time. and for that purpose we take the backup for that database. Backing up a database provide many solutions for us. The main thing is if we lost our database from SQL Server then we can restore our database from our computer. Also [...]
When we are working with Tables in Database we need to perform some basic operation with Tables. These operations may be inserting records, updating records etc. The most important operation we need to know about the table is fetching records from the Table, also we can say retrieving records from tables. Sometime we need to [...]
2012Tue20Mar
How to Attach Database File with Window Application Project
Filed in ASP.NET, Desktop AppAttaching Database file inside your ASP.NET Window Application Project is not necessary but sometimes it is very useful for us. There are two ways to use database with your project. The first one is create a database in SQL server and write code in your front end to make a connection and the other one [...]
2012Thu16Feb
How to Show the Selected Item in the CheckBoxList – Fetching from the DataBase
Filed in ASP.NET, Web AppI have divided this project in two sections. In first part of the project we will bind the CheckBoxList with Database as we did earlier. Then we will select some of the items from the CheckBoxList and insert into the DataBase Table. After the completion we will proceed to the next part of the project. [...]
Our recent post about how to bind a CheckBoxList with database. I hope all you guys have got very useful information. Today i will tell you that how to insert the values that are selected from the CheckboxList. Sometimes we need to select multiple values from the checkbox and we want to save all the [...]
Images are mostely used to recognize identification of any person or firm and while developing any Window Application you need to use Images many times within you Application. And also we need to save that Images into our Database so that we can access that images and use them when required. The one way to [...]
A Combobox is a commonly used Control in WinForm. It is a combination of a List Box and a single-line TextBox, allowing the user to either type a value directly into the control or choose from the list of existing options. Sometime, We need to fetch the data from Database and bind data with Combobox Control, so [...]
Click to view/hide
Click to view/hide
Development of software is only a single phase of overall system development. Coding is an important step on system development but maintaining the quality of software is also an important part and a challenging job. Proper testing is important for the good quality assurance. At present, there are different tools available for testing products. The tools like smartbear performance testing give good facility of testing and QA products.
Development of software is only a single phase of overall system development. Coding is an important step on system development but maintaining the quality of software is also an important part and a challenging job. Proper testing is important for the good quality assurance. At present, there are different tools available for testing products. The tools like smartbear performance testing give good facility of testing and QA products.