Subhash Pande
(2 comments, 11 posts)
Home page: http://www.stechnosoft.com
Yahoo Messenger: pandesubhash@yahoo.com
Jabber/GTalk: subhashpande1
Posts by Subhash Pande
How to convert datatypes in SQL
1
Output of the query
Sometimes we face the difficulty to convert data types in SQL. There are some default functions available in SQL to convert data types. Today We will see how to use them.
Regular Expressions in ASP.NET
2
Today we sill see the the “Regular Expressions” in ASP.net. Some people are using this in day to day applications. A regular expression is written in a formal language that can be interpreted by a regular expression processor. A regular expression, often called a pattern, is an expression that describes a set of strings.
Custom Order By in MS SQL Server
3
In MS SQL we cannot achieve sorting by using Order By on Varchar data type. We can do sorting on Int data type. To resolve this problem I suggest following solution. E.g. There is table in which AcadLevel is column having datatype varchar. Stored values are ‘Diploma’,'Graduate’, ‘PostGraduate’, ‘M.Phill’, ‘Ph.D’. I want to display Higher AcademicLevel first followed by remaining.
Three-tier architecture in .Net
42
Three-tier architecture in .net :-
The three-tier architecture was comes into existence to improve management of code and contents and to improve the performance of the web based applications.There are mainly three layers in three-tier architecture.
These are define as follows…
