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.
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.
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.
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.
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.
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.
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.
As we check our coding page in .net application we found that at the top after the namespaces there is a call that is partially defined in every web page. The question arrives in our mind that what is this Partial and why we use the class with partial access specifier. Why we not use the class as publicly or privately? Here we are to answer all these question. First we will get the partial class definition and its need.
As you develop your web application in .Net framework you need to run the web application online. Because Visual Studio can allow you to run application only on local computer. So now what next we need to do if we want to run our application online. We need to deploy the application and also configure the application with IIS- Internet Information Services.
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. Continue reading