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 →

What are the Partial Classes in C#

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.

Read More →

IIS – Understanding Virtual Directory

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.

Read More →

Normalisation – A Technique to Design a Database System

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. Read More →

SQL Server: Using Alias Name with Select Statement

The Alias name is the name that is referred to any column name or table name that is given by user. The alias name also used to represent some column or table without using its real name. As we will proceed in this article we will see that how we can use both the alias column name and alias table name in SQL Server.

Read More →

ASP.NET – Passing Multiple Values in Querystring

Using the Querystring is the another method to pass information between pages in your ASP.NET application. As we know that Querystring is the portion of the URL after a Question Mark(?). The information is always retrieved as a string that can be converted with any type.Here we get the code to pass multiple values at a single time in Querystring.

Read More →

Cookies with Multiple Values in ASP.NET

Recently we discussed various facts about a Cookie. Today we will see that how a single cookie can store multiple values. First we will create a Cookie then we will store multiple values in the same Cookie. Also the important thing is to retrieve the all values of that cookies. Whether you can retrieve the values in the same variable of multiple variables.

Read More →

ASP.NET Cookies – Creating, Retrieving and Deleting Cookies

Cookies are used to store the information when web server and web browser are not connected. This information can be about the online visitors, total visits to that particular application etc. A cookie is used to identify a user. The cookie is a small text file that is sent by web server and saved by web browser on client machine. A cookie is also knows as Http Cookie, Session Cookie, Web Cookie etc.

Read More →

Cast() Function in SQL Server

The Cast() Function is used to change the data type of a column. We can use the cast() function for various purpose.

Syntax:

Cast(Original_Expression as Desired_DataType)
 Read More →

Convert() Function in SQL Server

The convert() function is used to convert an expression of one  specific data type to another type. Also this function can be used to represent the value of date/time type variable in different different format. As we will discuss later in this post we will see how we accomplish this task.

Read More →