SQL SELECT TOP N equivalent in ORACLE and MySQL

SQL SELECT TOP N equivalent in ORACLE and MySQL

Posted using ShareThis

Get Server Username and Change Password in SQl Server

Get Server Username and Change Password in SQl Server

Posted using ShareThis

Collection of Source Code

TreeView without page refresh in ASP.NET and C#

This tutorial will show you how to work with TreeView control to display folders and file names without refreshing web page by C# and ASP.NET. First, you need to import the namespace from System.IO.DirectoryInfo in the namespace System.IO.DirectoryInfo class for typical operations such as copying, moving, renaming, creating, and deleting directories. using … more

Sys.WebForms.PageRequestManagerTimeoutException The server request timed out Error

To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is called AsyncPostBackTimeOut and it can help us to define the number of seconds before the request will throw a request timeout exception*. For example if …

List All Stored Procedure Modified in Last N Days

List of all objects : I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check …

SQL SERVER–Primary Key Constraints and Unique Key Constraints

Primary Key: Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. Primary Key does not allow Nulls. Create table with Primary Key: CREATE TABLE Authors ( AuthorID INT NOT NULL PRIMARY KEY, Name VARCHAR(100) NOT NULL ) GO Alter table with Primary Key: ALTER TABLE Authors ADD CONSTRAINT …

Common Validation and Length Validation with Regular Expression in ASP.NET

Introduction Input validation is very common and important in any kind of application. In case of web application server side validation is a must and client side validation is highly anticipated. As you know ASP.NET provides you some handfull validation controls like RequiredFiledValidator, RegularExpressionValidator etc. Most of the time we have …

SQL Server 2005 Encryption types

Encryption is the key for data security. Sensitive data such as Social Security numbers, credit card numbers, passwords, etc. should be protected from hacking. In SQL Server 2000, you have to create your own user-defined functions to encrypt the data or use external DLLs to encrypt the data. In SQL Server …

CASE function in SQL Server 2005 – part II

Part I of this series illustrated how to use simple case functions in queries. In Part II of the series, I am going to discuss how to use case functions in different types of scenarios. Method 4: Usage of searched case function Let us assume that we have the following table. use tempdb go if …

CASE function in SQL Server 2005 – part I

In SQL Server, the CASE functions evaluate a list of conditions and then return one or many results. In this article, I am going to illustrate the various uses of CASE functions in SQL server, in different places. Method 1: Usage of simple case function This is the common use of a …

SQL SERVER – CASE Statement/Expression Examples and Explanation

CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions. Two basic formulations for CASE expression 1) Simple CASE expressions …

Grouping by CheckBoxList

.aspx page like this code below,…

Item1 Item2 Item3 Item4

Cobehind file .cs protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e) { int IntSelect; IntSelect = Convert.ToInt32(CheckBoxList1.SelectedItem.Value); for (int i = 0; …

ASP.Net Nested DataList Controls C#

Visit the site to get full Source Code ->

ASP.Net Nested DataList Controls C#

Validate textbox with decimal values using javascript

See this site and get for that source code ->
Validate textbox with decimal values using javascript