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.
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 the rest of this entry »
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.
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.
The Cast() Function is used to change the data type of a column. We can use the cast() function for various purpose.
Cast(Original_Expression as Desired_DataType) Read the rest of this entry »
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.
Reference type are important features of the C# language. They enable us to write complex and powerful application and effectively use the run-time framework. If we define the reference type variables in C# then the Reference type variables contain a reference to the data not the value. The value is stored in a separate memory area. for example in C# we used several reference type variables such as Classes, Structures, Array, Enumeration etc.