My experiences in .NET

Exception handling difference between .NET Framework 1.1 and 2.0

2012-01-20T03:33:00.000-08:00

What happens if there is an application exception thrown and is not caught by application.

In .NET framework 1.1, it impacts the current application (web or windows)

In .NET Framework 2.0, it goes upto worker process (beyond our current application), and after a couple of uncaught exceptions, the Website will be stopped automatically (Dangerous !!).

Serialize a class to XML

2011-03-15T03:03:00.001-07:00

public string GetXML()
{
XmlSerializer objXMLSerializer = null;
StringWriter objStrW = null; // String writer to serialize the object to xml
String strXML; // Stores the serialized XML string
try
{
//Initilize the serializer
objXMLSerializer = new XmlSerializer(this.GetType()); // The serializer object
// Serialize the object
objStrW = new StringWriter();
objXMLSerializer.Serialize(objStrW, this);
// Retrieve the XML
strXML = objStrW.ToString().Replace(CommonConstants.CONST_UTF16, CommonConstants.CONST_UTF8);
return strXML;
}
catch (Exception ex)
{
//throw the exception to the calling function
throw ex;
}
finally
{
//Release the objects
objStrW.Close();
objXMLSerializer = null;
}
}

Stored Procedures Performance Tuning

2010-07-28T10:30:00.001-07:00

Recently I was given to optimize an SQL Query & would like to post my experience on that.

Indexes : Indexes are the only best way to improve the performance of select query.

Even though we have indexes, we might not be using them properly. For example, if the select statement has a where condition, we have to check if all the columns in where clause have an index.

Even if one column doesn't have an index, that causes lot of performance degradation. We can even have index on more than one column. Even this helps some times... (covered index - when all the columns in select query have an index, its called covered index)

SQL server has an option even to specify which index we can use when one column has more than one index on it, one for the column alone , one could be on a group of columns.

2. In the where clause if there is any aggregation - for ex: if you have convert(varchar,date1,101) in where clause - then the Index on date1 field doesn't work even though there is an index on it.

Never use functions in the where clause - this causes lot of performance degradation.

Regular Expressions

2009-03-20T02:04:00.000-07:00

Regular Expressions
Character	Definition
^	Start of a string.
$	End of a string.
.	Any character (except \n newline)
\|	Alternation.
{...}	Explicit quantifier notation.
[...]	Explicit set of characters to match.
(...)	Logical grouping of part of an expression.
*	0 or more of previous expression.
+	1 or more of previous expression.
?	0 or 1 of previous expression; also forces minimal matching when an expression might match several strings within a search string.
\	Preceding one of the above, it makes it a literal instead of a special character. Preceding a special matching character, see below.

Character Classes http://tinyurl.com/5ck4ll
Char Class	Description
.	Matches any character except \n. If modified by the Singleline option, a period character matches any character. For more information, see Regular Expression Options.
[aeiou]	Matches any single character included in the specified set of characters.
[^aeiou]	Matches any single character not in the specified set of characters.
[0-9a-fA-F]	Use of a hyphen (–) allows specification of contiguous character ranges.
\p{name}	Matches any character in the named character class specified by {name}. Supported names are Unicode groups and block ranges. For example, Ll, Nd, Z, IsGreek, IsBoxDrawing.
\P{name}	Matches text not included in groups and block ranges specified in {name}.
\w	Matches any word character. Equivalent to the Unicode character categories [\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \w is equivalent to [a-zA-Z_0-9].
\W	Matches any nonword character. Equivalent to the Unicode categories [^\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \W is equivalent to [^a-zA-Z_0-9].
\s	Matches any white-space character. Equivalent to the Unicode character categories [\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \s is equivalent to [ \f\n\r\t\v].
\S	Matches any non-white-space character. Equivalent to the Unicode character categories [^\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \S is equivalent to [^ \f\n\r\t\v].
\d	Matches any decimal digit. Equivalent to \p{Nd} for Unicode and [0-9] for non-Unicode, ECMAScript behavior.
\D	Matches any nondigit. Equivalent to \P{Nd} for Unicode and [^0-9] for non-Unicode, ECMAScript behavior.

Custom Validator to validate Date

2009-02-23T08:34:00.000-08:00

This is a custom validation that tests if the given date is in 30 days from today. (This validator throws error when the date is less than today or when the date is greater than 30 days from today)

--------------------------------------------------------------------------------------
This post is purely for my personal reference. :-)
-----------------------------------------------------------------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function datevalidate(sender, args)
{
var dd = document.getElementById("<%=TextBox1.ClientID%>").value;
var mm = document.getElementById("<%=TextBox2.ClientID%>").value;
var yy = document.getElementById("<%=TextBox3.ClientID%>").value;
//Why can't I take date from Javascript ? (I want server's date as per my requirement)
var ddnow = document.getElementById("<%=hdnDay.ClientID%>").value;
var mmnow = document.getElementById("<%=hdnMonth.ClientID%>").value;
var yynow = document.getElementById("<%=hdnYear.ClientID%>").value;
mm = mm-1; // javascript month range 0 - 11
mmnow = mmnow-1; //Month ranges from 0-11 in Javascript
var tempDate = new Date(yy,mm,dd);
var today = new Date(2009,1,23);
var d = new Date();
d.setFullYear(yynow,mmnow,ddnow+30);
//First check if the given date is valid.
if ( (yy == tempDate.getFullYear()) && (mm == tempDate.getMonth()) && (dd == tempDate.getDate()) )
{
if(tempDate < today)
{
args.IsValid = false;
}
else
{
if(tempDate < d)
args.IsValid = true;
else
args.IsValid = false;
}
}
// if ( (yy == tempDate.getFullYear()) && (mm == tempDate.getMonth()) && (dd == tempDate.getDate()) )
// {
// args.IsValid=true;
// } else
// {
// args.IsValid=false;
// }
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="TextBox1" runat="server"></asp:TextBox>
<asp:textbox id="TextBox2" runat="server"></asp:TextBox>
<asp:textbox id="TextBox3" runat="server"></asp:TextBox>
<asp:customvalidator id="custdate" runat="server" controltovalidate="TextBox3" clientvalidationfunction="datevalidate" errormessage="Invalid date"></asp:CustomValidator>
<br />
<asp:button id="Button1" runat="server" text="Button">
<input type="hidden" id="hdnDay" runat="server">
<input type="hidden" id="hdnMonth" runat="server">
<input type="hidden" id="hdnYear" runat="server">
</div>
</form>
</body>
</html>

-----------------------------------------------------------------
Code-behind
-----------------------------------------------------------------

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
hdnDay.Value = DateTime.Now.ToString("dd");
hdnMonth.Value = DateTime.Now.ToString("MM"); //m is for minutes. M is for month.
hdnYear.Value = DateTime.Now.ToString("yyyy");
}
}

Printing Date in different formats

2008-11-27T23:05:00.000-08:00

DateTime.ToString()
Assume dt is a datetime object.
dt.ToString("MM/dd/yyyy") prints 05/05/2005
In the same way, try out the following options.

0 MM/dd/yyyy 05/05/2005
1 dddd, dd MMMM yyyy Thursday, 05 May 2005
2 dddd, dd MMMM yyyy HH:mm Thursday, 05 May 2005 06:30
3 dddd, dd MMMM yyyy hh:mm tt Thursday, 05 May 2005 06:30 AM
4 dddd, dd MMMM yyyy H:mm Thursday, 05 May 2005 6:30
5 dddd, dd MMMM yyyy h:mm tt Thursday, 05 May 2005 6:30 AM
6 dddd, dd MMMM yyyy HH:mm:ss Thursday, 05 May 2005 06:30:07
7 MM/dd/yyyy HH:mm 05/05/2005 06:30
8 MM/dd/yyyy hh:mm tt 05/05/2005 06:30 AM
9 MM/dd/yyyy H:mm 05/05/2005 6:30
10 MM/dd/yyyy h:mm tt 05/05/2005 6:30 AM
10 MM/dd/yyyy h:mm tt 05/05/2005 6:30 AM
10 MM/dd/yyyy h:mm tt 05/05/2005 6:30 AM
11 MM/dd/yyyy HH:mm:ss 05/05/2005 06:30:07
12 MMMM dd May 05
13 MMMM dd May 05
14 yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2005-05-05T06:30:07.7199222-04:00
15 yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2005-05-05T06:30:07.7199222-04:00
16 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Thu, 05 May 2005 06:30:07 GMT
17 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Thu, 05 May 2005 06:30:07 GMT
18 yyyy'-'MM'-'dd'T'HH':'mm':'ss 2005-05-05T06:30:07
19 HH:mm 06:30
20 hh:mm tt 06:30 AM
21 H:mm 6:30
22 h:mm tt 6:30 AM
23 HH:mm:ss 06:30:07
24 yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2005-05-05 06:30:07Z
25 dddd, dd MMMM yyyy HH:mm:ss Thursday, 05 May 2005 06:30:07
26 yyyy MMMM 2005 May
27 yyyy MMMM 2005 May

The patterns for DateTime.ToString ( 'd' ) :
0 MM/dd/yyyy 05/05/2005

The patterns for DateTime.ToString ( 'D' ) :
0 dddd, dd MMMM yyyy Thursday, 05 May 2005

The patterns for DateTime.ToString ( 'f' ) :
0 dddd, dd MMMM yyyy HH:mm Thursday, 05 May 2005 06:30
1 dddd, dd MMMM yyyy hh:mm tt Thursday, 05 May 2005 06:30 AM
2 dddd, dd MMMM yyyy H:mm Thursday, 05 May 2005 6:30
3 dddd, dd MMMM yyyy h:mm tt Thursday, 05 May 2005 6:30 AM

The patterns for DateTime.ToString ( 'F' ) :
0 dddd, dd MMMM yyyy HH:mm:ss Thursday, 05 May 2005 06:30:07

The patterns for DateTime.ToString ( 'g' ) :
0 MM/dd/yyyy HH:mm 05/05/2005 06:30
1 MM/dd/yyyy hh:mm tt 05/05/2005 06:30 AM
2 MM/dd/yyyy H:mm 05/05/2005 6:30
3 MM/dd/yyyy h:mm tt 05/05/2005 6:30 AM

The patterns for DateTime.ToString ( 'G' ) :
0 MM/dd/yyyy HH:mm:ss 05/05/2005 06:30:07

The patterns for DateTime.ToString ( 'm' ) :
0 MMMM dd May 05

The patterns for DateTime.ToString ( 'r' ) :
0 ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Thu, 05 May 2005 06:30:07 GMT

The patterns for DateTime.ToString ( 's' ) :
0 yyyy'-'MM'-'dd'T'HH':'mm':'ss 2005-05-05T06:30:07

The patterns for DateTime.ToString ( 'u' ) :
0 yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2005-05-05 06:30:07Z

The patterns for DateTime.ToString ( 'U' ) :
0 dddd, dd MMMM yyyy HH:mm:ss Thursday, 05 May 2005 06:30:07

The patterns for DateTime.ToString ( 'y' ) :
0 yyyy MMMM 2005 May

Building a custom DateTime.ToString Patterns
The following details the meaning of each pattern character. Not the K and z character.

d Represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero
dd Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero
ddd Represents the abbreviated name of the day of the week (Mon, Tues, Wed etc)
dddd Represents the full name of the day of the week (Monday, Tuesday etc)
h 12-hour clock hour (e.g. 7)
hh 12-hour clock, with a leading 0 (e.g. 07)
H 24-hour clock hour (e.g. 19)
HH 24-hour clock hour, with a leading 0 (e.g. 19)
m Minutes
mm Minutes with a leading zero
M Month number
MM Month number with leading zero
MMM Abbreviated Month Name (e.g. Dec)
MMMM Full month name (e.g. December)
s Seconds
ss Seconds with leading zero
t Abbreviated AM / PM (e.g. A or P)
tt AM / PM (e.g. AM or PM
y Year, no leading zero (e.g. 2001 would be 1)
yy Year, leadin zero (e.g. 2001 would be 01)
yyy Year, (e.g. 2001 would be 2001)
yyyy Year, (e.g. 2001 would be 2001)
K Represents the time zone information of a date and time value (e.g. +05:00)
z With DateTime values, represents the signed offset of the local operating system's time zone from Coordinated Universal Time (UTC), measured in hours. (e.g. +6)
zz As z but with leadin zero (e.g. +06)
zzz With DateTime values, represents the signed offset of the local operating system's time zone from UTC, measured in hours and minutes. (e.g. +06:00)
f Represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value.
ff Represents the two most significant digits of the seconds fraction; that is, it represents the hundredths of a second in a date and time value.
fff Represents the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value.
ffff Represents the four most significant digits of the seconds fraction; that is, it represents the ten thousandths of a second in a date and time value. While it is possible to display the ten thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.
fffff Represents the five most significant digits of the seconds fraction; that is, it represents the hundred thousandths of a second in a date and time value. While it is possible to display the hundred thousandths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.
ffffff Represents the six most significant digits of the seconds fraction; that is, it represents the millionths of a second in a date and time value. While it is possible to display the millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.
fffffff Represents the seven most significant digits of the seconds fraction; that is, it represents the ten millionths of a second in a date and time value. While it is possible to display the ten millionths of a second component of a time value, that value may not be meaningful. The precision of date and time values depends on the resolution of the system clock. On Windows NT 3.5 and later, and Windows Vista operating systems, the clock's resolution is approximately 10-15 milliseconds.
F Represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value. Nothing is displayed if the digit is zero.
: Represents the time separator defined in the current DateTimeFormatInfo..::.TimeSeparator property. This separator is used to differentiate hours, minutes, and seconds.
/ Represents the date separator defined in the current DateTimeFormatInfo..::.DateSeparator property. This separator is used to differentiate years, months, and days.
" Represents a quoted string (quotation mark). Displays the literal value of any string between two quotation marks ("). Your application should precede each quotation mark with an escape character (\).
' Represents a quoted string (apostrophe). Displays the literal value of any string between two apostrophe (') characters.
%c Represents the result associated with a c custom format specifier, when the custom date and time format string consists solely of that custom format specifier. That is, to use the d, f, F, h, m, s, t, y, z, H, or M custom format specifier by itself, the application should specify %d, %f, %F, %h, %m, %s, %t, %y, %z, %H, or %M. For more information about using a single format specifier, see Using Single Custom Format Specifiers.

Regular Expression that accepts 0-9,space,/,+,- only

2008-05-30T04:58:00.000-07:00

^([0-9][\ ][\/][\+][\-])*$

The below link can be used to test your regular expressions:
http://www.dotnetcoders.com/web/Learning/Regex/RegexTester.aspx

Calling a web-service

2008-05-30T02:09:00.000-07:00

Here I am not concerned about creating a web-service & consuming it. I hope you know this already. But sometimes when you consume the web-service in .NET it throws an exception like 'The request failed with HTTP status 401 : unauthorized'. When you try to run the web-service directly, it runs without fail.

Resolution:

Dim obj As New basicops.operations
obj.Credentials = System.Net.CredentialCache.DefaultCredentials

lblResult.Text = "Result: " & obj.Subtract(Convert.ToInt32(TextBox1.Text), Convert.ToInt32(TextBox2.Text)).ToString()

What happens when an asp.net page is requested from the browser

2008-04-24T08:24:00.000-07:00

From the browser the request is sent to IIS. There is an aspnet_isapi.dll in IIS that takes care of serving the request. From this it sends the request to .net framework's worker process. (aspnet_wp.exe)

From IIS there is a mapping that specifies the which isapi is going to process that page. From the website properties, From virtual directory tab, click on 'configuration' button. This shows the application configuration window.

At its core, the ASP.NET execution engine compiles the page into a class, which derives from the code behind class (which in turn derives directly or indirectly from the Page class). Then it injects the newly created class into the execution environment, instantiates it, and executes it.

Crystal Reports in ASP.NET

2008-04-20T19:51:00.000-07:00

using CrystalDecisions.CrystalReports.Engine;
-----------------------------------------------------------------------------

ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath("rptOne.rpt"));

for (int index = 0; index < rptDoc.Database.Tables.Count; index++)
{
rptDoc.Database.Tables[index].LogOnInfo.ConnectionInfo.ServerName = "BHARATIKUMAR";
rptDoc.Database.Tables[index].LogOnInfo.ConnectionInfo.DatabaseName = "Employee";
rptDoc.Database.Tables[index].LogOnInfo.ConnectionInfo.UserID = "kumar";
rptDoc.Database.Tables[index].LogOnInfo.ConnectionInfo.Password = "kumar";
rptDoc.Database.Tables[index].ApplyLogOnInfo(rptDoc.Database.Tables[index].LogOnInfo);
}

crvOne.ReportSource = rptDoc;

crvOne.DataBind();

Posting to my blog after a very long time

2008-04-10T18:37:00.000-07:00

Hi everyone,

In my office, firewall do blocks blogger.com website. Hence couldnt login & couldnt paste to my blog. After 8 months this is the first time I am logging into my blogger.

I am into a production support & enhancement project now. Going to work on MCMS 2002 (Microsoft Content Management Server 2002). I hope MCMS is interesting.

:-) Will keep posting stuff on MCMS from now onwards.

Upload a file in Window application

2007-09-07T05:11:00.000-07:00

if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
FileInfo f = new FileInfo(openFileDialog1.FileName);
string[] fName;
fName = openFileDialog1.FileName.Split(new char[] {'\\'} );

f.CopyTo("C:\\Bharathi\\" + fName[fName.Length-1]);

FileStream fs = new FileStream("C:\\Bharathi\\" + fName[fName.Length - 1], FileMode.Open);
StreamReader sr = new StreamReader(fs);

MessageBox.Show(sr.ReadToEnd());

//System.IO.File.ReadAllBytes(openFileDialog1.FileName);
}

VB.NET + ASP.NET + Data Grid + V1.x

2007-09-07T01:09:00.000-07:00

<asp:datagrid id="dgUserCampaigns" DataKeyField="UserCampaignId" runat="server" CssClass="bordergrid"
AllowSorting="True" GridLines="Horizontal" ShowHeader="False" AutoGenerateColumns="False"
CellPadding="3" AllowPaging="False" Width="100%">

<ItemStyle Height="20px" CssClass="GridItem"></ItemStyle>

<HeaderStyle HorizontalAlign="Left" Height="22px" CssClass="GridHeader" Font-Bold="True" VerticalAlign="Middle"></HeaderStyle>

<FooterStyle Height="18px"></FooterStyle>

<Columns>
<asp:BoundColumn Visible="False"></asp:BoundColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
<asp:linkbutton Runat="server" ID="lnkCreatedDate" CssClass="gridheaderlink" Font-Bold="True" CommandName="sort"
CommandArgument="CreatedDate">Created</asp:linkbutton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="lblCreatedDate" text='<%# GenValidations.GetDateValue(Databinder.Eval(container.Dataitem,"CreatedDate"))%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="left"></ItemStyle>
<HeaderTemplate>
Type
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="lblType" text='<%# Databinder.Eval(container.Dataitem,"TemplateType")%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Draft
</HeaderTemplate>
<ItemTemplate>
<asp:Image ID="imgDraft" ImageUrl="../Images/status.gif" BorderWidth="0" Runat="server" Visible='false'></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="false">
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Scheduled
</HeaderTemplate>
<ItemTemplate>
<asp:Image ID="imgScheduled" ImageUrl="../Images/status.gif" BorderWidth="0" Runat="server"
Visible=''></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Send
</HeaderTemplate>
<ItemTemplate>
<asp:Image ID="imgSent" ImageUrl="../Images/status.gif" BorderWidth="0" Runat="server" Visible='false'></asp:Image>
<asp:Label id="lblSend" Runat="server" visible="False" text=''></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Delivered
</HeaderTemplate>
<ItemTemplate>
<asp:Image ID="imgDelivered" ImageUrl="../Images/status.gif" BorderWidth="0" Runat="server"
Visible='false'></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%"></ItemStyle>
<HeaderTemplate>
<asp:linkbutton Runat="server" ID="lnkDeliveryDate" CssClass="gridheaderlink" Font-Bold="True" CommandName="sort"
CommandArgument="DeliveryDate">Delivery Date</asp:linkbutton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="lblDeliveryDate" text='<%# Databinder.Eval(container.Dataitem,"DeliveryDate","{0:MM/dd/yyyy}")%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Mail
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton Runat="server" ID="lnkEditMail" CommandName="Email">
<img src="../Images/mail.gif" border="0">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
<asp:linkbutton Runat="server" ID="lnkCampaignStatus" CssClass="gridheaderlink" Font-Bold="True"
CommandName="sort" CommandArgument="CampaignStatus">Status</asp:linkbutton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="lblCampaignStatus" ForeColor='<%# GenValidations.GetCampaignStatusColor(Databinder.Eval(container.Dataitem,"CampaignStatus"))%>' text='<%# GenValidations.GetCampaignStatus(Databinder.Eval(container.Dataitem,"CampaignStatus"))%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn Visible="False">
<ItemStyle Width="0%" HorizontalAlign="left"></ItemStyle>
<HeaderTemplate>
Campaign Description
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="lblCampaignDescription" Visible=False text='<%# Databinder.Eval(container.Dataitem,"CampaignDescription")%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="9%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
<asp:CheckBox Runat="server" ID="chkCheckAll" CssClass="font1"></asp:CheckBox>
</HeaderTemplate>
<ItemTemplate>
  
<asp:CheckBox Runat="server" ID="chk1" CssClass="font1"></asp:CheckBox>
<asp:TextBox ID="txtUserCampaignId" CssClass="gridlink" Runat=server text='<%# Databinder.Eval(container.Dataitem,"UserCampaignId")%>' style="Width:0;Height:0;visibility:hidden">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle></HeaderStyle>
<ItemStyle Width="28%"></ItemStyle>
<HeaderTemplate>
<asp:linkbutton Runat="server" ID="lnkCampaignSort" CssClass="gridheaderlink" Font-Bold="True" CommandName="sort"
CommandArgument="CampaignName">Campaigns <img src="../Images/arrdown.gif" border="0"></asp:linkbutton>
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton id="lnkCampaignName" CssClass="gridlink" tooltip='<%# Databinder.Eval(container.Dataitem,"CampaignName")%>' text='<%# Genvalidations.GetStringValueWithwrap(Databinder.Eval(container.Dataitem,"CampaignName"),18)%>' Runat="server" CommandName="Summary">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<ItemStyle Width="10%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
<asp:linkbutton Runat="server" ID="Linkbutton1" CssClass="gridheaderlink" Font-Bold="True" CommandName="sort"
CommandArgument="CampaignStatus">Status</asp:linkbutton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label Runat="server" CssClass="fontblue" ID="Label1" text='<%# GenValidations.GetDateValue(Databinder.Eval(container.Dataitem,"CreatedDate"))%>' >
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:ButtonColumn Visible="False" Text="Edit" HeaderText="Edit" CommandName="Edit">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="8%" CssClass="gridlink" VerticalAlign="Middle"></ItemStyle>
</asp:ButtonColumn>
<asp:TemplateColumn>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="10%" HorizontalAlign="center"></ItemStyle>
<HeaderTemplate>
</HeaderTemplate>
<ItemTemplate>
<asp:ImageButton ID="imgCampaignSummary" Runat="server" ImageUrl="../Images/Zoom.gif" BorderWidth="0"
CommandName="Summary"></asp:ImageButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="9%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Edit
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton Runat="server" ID="lnkEditMessage" CommandName="Edit">
<img src="../Images/Edit.gif" border="0">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="9%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Delete
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton Runat="server" ID="lnkDelete" CommandName="Delete">
<img src="../Images/Delete.gif" border="0">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle Width="9%" HorizontalAlign="Center"></ItemStyle>
<HeaderTemplate>
Summary
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton Runat="server" ID="lnkSummary" CommandName="Summary">
<img src="../Images/book.gif" border="0">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>

</Columns>

</asp:datagrid>

Calling a DB2 Stored Procedure from .NET

2007-09-06T05:36:00.001-07:00

Calling a DB2 Stored Procedure from .NET:

using System.Data.OleDb;
------------------------------------
///I am executing a stored procedure which is returning a DataTable
public DataTable ExecuteDb2Procedure()
{

OleDbConnection oledbCnn;
OleDbDataAdapter oledbAdapter;
OleDbCommand oledbCmd;
OleDbParameter oledbParam = new OleDbParameter();;
System.Data.DataTable dt = new DataTable();
OleDbTransaction oledbTrans;
string cmdText;

oledbCnn = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);

cmdText = "{call " + StoredProcedureName + " (";

//Here you have to just pass parameter values. Dont pass parameter name & value. Just pass parameter value. If the parameter is string type place the string inside single quotes.

cmdText = cmdText + " " + intParameterValue1.ToString() + ",'" + strParamValue2 + "'," + intParameterValue2.ToString();

cmdText = cmdText + " ) } ";

oledbCmd = new OleDbCommand(cmdText, oledbCnn);
oledbCmd.CommandTimeout = 60;
oledbAdapter = new OleDbDataAdapter(oledbCmd);

oledbCmd.CommandType = CommandType.Text;
oledbCmd.CommandText = cmdText;
oledbAdapter.SelectCommand = oledbCmd;

try
{
retval = oledbAdapter.Fill(dt);
}
catch
{
//Throw exception
}

return dt;
}

Programmatically determine if a File is an assembly

2007-09-06T05:16:00.001-07:00

We can take help of System.Reflection.AssemblyName class to determine if a file is an assembly or not.

classTestAssembly { static voidMain() { try { System.Reflection.AssemblyName testAssembly = System.Reflection.AssemblyName.GetAssemblyName(@"C:\Bharati\test.dll"); System.Console.WriteLine("Yes, the file is an Assembly."); } catch(System.IO.FileNotFoundException e) { System.Console.WriteLine("The file cannot be found."); } catch(System.BadImageFormatException e) { System.Console.WriteLine("The file is not an Assembly."); } catch(System.IO.FileLoadException e) { System.Console.WriteLine("The Assembly has already been loaded."); } } }

Dynamically Bind Event Handlers at Run Time in ASP.NET

2007-09-06T04:19:00.000-07:00

Microsoft recruits white hat hackers

2007-08-28T04:04:00.000-07:00

Source: http://blogs.msdn.com/hackers/

SQL Server free tools by Idera

2007-08-09T22:56:00.001-07:00

Personally I have not tried this. Hope it would be an useful reference.

http://www.idera.com/products/SQLcheck/

SQL Server 2008 Katmai,

2007-08-08T04:03:00.001-07:00

Today I had attended first webinar on SQL Server 2008. Eventhough the net was slow and voice was breaking somehow I managed to follow that.

Some of the key concepts are:

1. Enterprise Data Platform

2. Beyond Rational

3. Dynamic Development

4. Pervasive Insight

Links:

1. To download the SQL server katmai CTP:

http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

2. SQL server best practices:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

Some of the Features that are very interesting:

1.FileStream data type : We can save word, excel, audio, video files etc. into sql server itself. In SQL Server 2005 to achive the same functionality we need to sql varbinary(MAX) data type which stores everything in binary format.

With the help of filestream format we can handle File System objects in sql server itself & sql server supports ACID properties on this.

2. Separate date & time datatypes along with the existing datetime data type, and also a new datatype called datetime2 to store maximum dates.

Technorati Profile

2007-08-01T21:32:00.000-07:00

<a href="<a href="http://technorati.com/claim/nb863ikuv9" rel="me">Technorati Profile</a>"></a>

Properties of WebMethod() Attribute

2007-08-01T21:06:00.001-07:00

The 6 properties of WebMethod Attribute are

Description
MessageName
EnableSession
CacheDuration
TransactionOption
BufferResponse

<WebMethod(Description:="This Method add two integer")>
Public Function Add(ByVal Num1 As Integer, ByVal Num2 As Integer) As Integer
Return Num1 + Num2
End Function

Assembly Cache Viewer (Shfusion.dll)

2007-07-31T21:46:00.001-07:00

The contents of GAC (Global Assembly Cache) are displayed by using Shfusion.dll

[Fusion is the code name for assembly binder in .NET Framework. Fusion binds the appropriate assemblies (from bin folder or from GAC or from any network etc.) at load time or at run time.]

Shfusion.dll causes the contents of the assembly folder to appear differently than the contents of normal windows folders. Assembly's name, assembly's type, version, culture, and public key token are displayed in GAC.

We cant directly paste an assembly into assembly folder i.e into GAC. First the assembly must be strongly-named & then it can be deployed into GAC using drag & drop method or by using GACUtil tool. (gacutil -i)

SQL : Finding Nth highest salary in different ways

2007-07-31T21:26:00.001-07:00

Query to find 2nd highest salary:

1. Select max( salary) from emp where salary < (Select max(salary) from emp)

2. select max(salary) from emp where salary not in(select max(salary) from emp)

You can write the query to find the Nth max salary details as follows, (This logic is called co-related sub queries, this acts as a for loop in a for loop.

In case of Sub Queries, the inner query gets executed only once. In co-related sub-queries for each record selected by outer query, inner query completely gets executed. So its time-complexity is O(n square)

Select * from Employee E1
where (N-1) = (Select count(distinct(E2.Salary)) From Employee E2
Where E2.salary > E1.Salary)

ex: to find 3rd highest salary

Select * from Emp E1
where 2 = (Select count(E2.Salary) From Emp E2
Where E2.salary > E1.Salary)

The following SQL will also return the top ten employees by salary:

SELECT   EMPNO, LASTNAME, FIRSTNME, SALARY

FROM

EMP A

WHERE 10 > (SELECT COUNT(*)

            FROM   EMP B

            WHERE A.SALARY < B.SALARY

            AND    B.SALARY IS NOT NULL)

ORDER BY SALARY DESC;

another example:

SELECT distinct EMPid, SALARY

FROM EMP A

WHERE 3 >(SELECT COUNT(*)

FROM EMP B

WHERE A.SALARY < B.SALARY

AND B.SALARY IS NOT NULL)

ORDER BY SALARY DESC;

Beauty of Code Snippets

2007-07-27T02:18:00.000-07:00

Although I am using Visual Studio.NET 2005 from more than an year & although I am aware of code snippets in VS.NET, never used it until recently one of my friends told me to find its beauty.

just type the keyword 'while' in your visual studio.net 2005 editor, you can see this something like this:

after typing the word while press tab twice & You will find its complete syntax on your page.

This is the code that I have got in visual studio after typing the word exception and tab twice. AWESOME!! Right!

--------------------------------------------------------------------------
[global::System.Serializable]
public class MyException : Exception
{
//
// For guidelines regarding the creation of new exception types, see
// http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/cpconerrorraisinghandlingguidelines.asp
// and
// http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncscol/html/csharp07192001.asp
//

public MyException() { }
public MyException(string message) : base(message) { }
public MyException(string message, Exception inner) : base(message, inner) { }
protected MyException(
System.Runtime.Serialization.SerializationInfo info,
System.Runtime.Serialization.StreamingContext context)
: base(info, context) { }
}

-------------------------------------------------------------------------
code for creating custom attributes (type in attribute and tab twice)
-------------------------------------------------------------------------
[global::System.AttributeUsage(AttributeTargets.All, Inherited = false, AllowMultiple = true)]
sealed class MyAttribute : Attribute
{
// See the attribute guidelines at
// http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/cpconusingattributeclasses.asp
readonly string _positionalString;
int _namedInt;

// This is a positional argument.
public MyAttribute(string positionalString)
{
this._positionalString = positionalString;

// TODO: Implement code here.
throw new Exception("The method or operation is not implemented.");
}
public string PositionalString
{
get
{
return this._positionalString;
}
}
// This is a named argument.
public int NamedInt
{
get
{
return this._namedInt;
}
set
{
this._namedInt = value;
}
}
}
--------------------------------------------------------------------------

Similarly we can explore iterators, for, while, interfaces etc...

Thank you my best friend for reminding me of this feature!

Hierarchical Grid View (3-levels)

2007-07-25T03:30:00.001-07:00

Recently we had a requirement with one of the customers where we have to design a dashboard that shows sales data.

At a glance we have to show his the sales data of all regions. (He can filter on region any way!)

When he clicks on a region, we should show all the areas in that region and the sales data of each area.

Again he can click on an area, and can see the sales data of individual dealers in that area.

Also when it is completely expanded and when he scrolls down to see the data, headers should remain in the same place. (i.e, just like frozen headers in excel)

Alas! Thats the requirement. Thank god! No further level of hierarchy!!!!

We did the trick with 3 Grid views & some javascript & css.
--------------------------------------------------------------------------

To test this, create a new web page using VS.NET 2005 using C#. Copy the .aspx content of this page into your page & the .aspx.cs into your .aspx.cs file. Also dont forget to copy the style sheet & javascript into .aspx file. Simply run & test this page. For demonistration purpose we have not connected to database here, we are generating data from code behind.
--------------------------------------------------------------------------
: collapse.gif

: expand.gif
--------------------------------------------------------------------------

--------------------------------------------------------------------------
Here is the CSS class that we have used:
-------------------------------------------------------------------------------

<style type="text/css">

table {
/*table-layout: fixed;*/
border-collapse: collapse;
font-size:10px;
font-family:Verdana, Arial, Helvetica, sans-serif;
color:#000000;
}

/*This is for freezing the Header Rows*/
.fixedheadercell
{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:10px;
color:#FFFFFF;
LINE-HEIGHT: 13px;
font-weight:bold;
/*text-align:center;*/
background-color:#3399FF;

position: relative;
/*top: expression(this.offsetParent.scrollTop);*/
top:expression(document.getElementById('p1').scrollTop-2);

padding-right: 2px;
padding-left: 2px;
padding-bottom: 2px;
padding-top: 2px;
}

/*This is for freezing the columns*/
.fixedcolumn
{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:10px;
color:#FFFFFF;
LINE-HEIGHT: 13px;
font-weight:bold;
background-color:#3399FF;
position: relative;
/*top: expression(this.offsetParent.scrollTop);*/
left:expression(document.getElementById('p1').scrollLeft-2);
padding-right: 2px;
padding-left: 2px;
padding-bottom: 2px;
padding-top: 2px;
}

.geo_view_reg{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:9px;
color:#2D469F;
LINE-HEIGHT: 13px;
font-weight:bold;
text-align:left;
background-color:#8DCFF3;
border-top:solid;
border-top-width:1px;
border-top-color:#FFFFFF;
}

.geo_view_col {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:9px;
color:#2D469F;
LINE-HEIGHT: 13px;
font-weight:bold;
background-color:#DFEFFF;
border-top:solid;
border-top-width:1px;
border-top-color:#FFFFFF;
}

</style>

-------------------------------------------------------------------------------
Java script
-------------------------------------------------------------------------------
<script type="text/javascript">

function firstlevelexpand(id)
{
//GridView1_ctl02_ChildGridView1
if(getimagename(document.getElementById('GridView1$ctl0'+ id + '$btnRegion').src) == "expand.gif")
{
document.getElementById('GridView1$ctl0'+ id + '$btnRegion').src = "collapse.gif";
document.getElementById('GridView1_ctl0'+ id + '_ChildGridView1').style.display = "none";
}
else
{
document.getElementById('GridView1$ctl0'+ id + '$btnRegion').src = "expand.gif";
document.getElementById('GridView1_ctl0'+ id + '_ChildGridView1').style.display = "";
}
return false;
}

function collapseAll(count)
{
debugger;
var i;
var index;
for(i=2;i<count+2;i++)
{
if(i<10)
index = '0' + i;
else
index = i;
if(eval(document.getElementById('GridView1_ctl'+ index + '_ChildGridView1')))
{
document.getElementById('GridView1$ctl'+ index + '$btnRegion').src = "collapse.gif";
document.getElementById('GridView1_ctl'+ index + '_ChildGridView1').style.display = "none";
}
}
return false;
}

function secondlevelexpand(id,id2)
{

if(eval(document.getElementById(id2)))
{
if(getimagename(document.getElementById(id).src) == "expand.gif")
{
document.getElementById(id).src = "collapse.gif";
document.getElementById(id2).style.display = "none";
}
else
{
document.getElementById(id).src = "expand.gif";
document.getElementById(id2).style.display = "";
}
return false;
}
else
return true;
}

function getimagename(fullpath)
{
var imagename="";
var temp = new Array();
temp = fullpath.split("/");
return temp[temp.length -1];
}

</script>

-------------------------------------------------------------------------------
ASPX CODE
-------------------------------------------------------------------------------

<form id="form1" runat="server">
<table>
<tr>
<td>
<asp:Button ID="btnExpandAll" runat="server" OnClick="Button1_Click" Text="Expand All" />
<asp:Button ID="btnCollapseAll" runat="server" OnClick="Button2_Click" Text="Collapse All" />
</td>
</tr>
</table>
<div>
<%--<asp:SqlDataSource ID="ParentSqlDataSource" runat="server"
ConnectionString="Provider=SQLOLEDB;Data Source=16.138.50.177;Integrated Security=SSPI;Initial Catalog=Maps"
ProviderName="System.Data.OleDb" SelectCommand="select region ,area,dealer,ALS_Target,ALS_MTD,ALS_MTD_Last_Month,ALS_MTD_Last_Year,ALS_YTD,ALS_YTDLY from RegionSales">
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Provider=SQLOLEDB;Data Source=16.138.50.177;Integrated Security=SSPI;Initial Catalog=Maps"
ProviderName="System.Data.OleDb">
</asp:SqlDataSource>--%>

--------------------------------------------------------------------------
<asp:Panel ID="p1" runat="server" ScrollBars="Auto" Height="150px" BorderStyle="Groove" Width="555px">
<asp:GridView ID="GridView1" runat="server" BorderStyle="None" GridLines="None"
DataKeyNames="region" AutoGenerateColumns="False"
OnRowCommand="GridView1_RowCommand" OnRowCreated="GridView1_RowCreated" ShowFooter="true"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged" ToolTip="View of Sales">
<Columns>
<asp:TemplateField>
<HeaderStyle CssClass="fixedheadercell" />
<HeaderTemplate>
<table id="tblmain" cellpadding="0" cellspacing="0" border="0" style="border-collapse:collapse" width="100%">
<thead>
<tr>
<th align="left">
<asp:Label ID="lblspace" runat="server" Text="" Width="15px"></asp:Label>
</th>
<th align="left">
<asp:Label ID="lblheadingregion" runat="server" Text="Region" Width="75px"></asp:Label>
</th>
<th align="left">
<asp:Label ID="lblheadingarea" runat="server" Text="Area" Width="80px"></asp:Label>
</th>
<th align="left">
<asp:Label ID="lblheadingdealer" runat="server" Text="Dealer" Width="80px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label17" runat="server" Text="Target" Width="45px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label18" runat="server" Text="MTD" Width="45px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label19" runat="server" Text="MTDLM" Width="45px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label20" runat="server" Text="MTDLY" Width="45px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label21" runat="server" Text="YTD" Width="45px"></asp:Label>
</th>
<th align="center">
<asp:Label ID="Label22" runat="server" Text="YTDLY" Width="45px"></asp:Label>
</th>

</tr>
</thead>
</table>
</HeaderTemplate>
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;width:100%">
<tr>
<td class="geo_view_reg">
<asp:ImageButton Width="15px" ID="btnRegion" runat="server" ImageUrl="collapse.gif" CommandName="Select" />
</td>
<td class="geo_view_reg">
<asp:Label Width="75px" ID="lblRegion" runat="server" Text='<%#Eval("region")%>'></asp:Label>
</td>
<td class="geo_view_reg">
<asp:Label Width="80px" ID="lblArea1" runat="server" Text=" "></asp:Label>
</td>
<td class="geo_view_reg">
<asp:Label Width="80px" ID="lbldealer1" runat="server" Text=" "></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="lblCountry" runat="server" Text='<%# Eval("ALS_Target") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label5" runat="server" Text='<%# Eval("ALS_MTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label6" runat="server" Text='<%# Eval("ALS_MTD_Last_Month") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label2" runat="server" Text='<%# Eval("ALS_MTD_Last_Year") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label3" runat="server" Text='<%# Eval("ALS_YTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label4" runat="server" Text='<%# Eval("ALS_YTDLY") %>'></asp:Label>
</td>

</tr>


<tr>
<td colspan="20">

<asp:GridView ID="ChildGridView1" runat="server" GridLines="None" DataKeyNames="area" Visible="False"
OnSelectedIndexChanged="ChildGridView1_SelectedIndexChanged"
AutoGenerateColumns="False" BorderStyle="None" ShowFooter="false" ShowHeader="false" Width="100%">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table border="0" width="100%" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<tr>
<td class="geo_view_reg">
<asp:Label ID="lblspace" runat="server" Width="75px" Text=""></asp:Label>
</td>
<td class="geo_view_reg">
<asp:ImageButton ID="btnState" runat="server" Width="15px" ImageUrl="collapse.gif" CommandName="Select" />
</td>
<td align="right" class="geo_view_reg">
<asp:Label Width="80px" ID="lblCity11" runat="server" Text='<%#Eval("Area")%>'></asp:Label>
</td>
<td align="right" class="geo_view_reg">
<asp:Label Width="80px" ID="lblCountry11" runat="server" Text=""></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="lblCountry" runat="server" Text='<%# Eval("ALS_Target") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label5" runat="server" Text='<%# Eval("ALS_MTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label6" runat="server" Text='<%# Eval("ALS_MTD_Last_Month") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label2" runat="server" Text='<%# Eval("ALS_MTD_Last_Year") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label3" runat="server" Text='<%# Eval("ALS_YTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label4" runat="server" Text='<%# Eval("ALS_YTDLY") %>'></asp:Label>
</td>

</tr>
<tr>
<td colspan="20">

-------------------------------------------------------------------------- <asp:GridView id="ChildGridView2" runat="server" GridLines="None" DataKeyNames="dealer" Visible="False"
ShowHeader="false" ShowFooter="false"
AutoGenerateColumns="False" BorderStyle="None" Width="100%">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" width="100%" style="border-collapse:collapse">
<tr>
<td class="geo_view_reg">
<asp:Label ID="lblspace1" runat="server" Text="" Width="170px"></asp:Label>
</td>
<td align="right" class=" geo_view_reg">
<asp:Label Width="80px" ID="Label1" runat="server" Text='<%# Eval("Dealer") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="lblCountry" runat="server" Text='<%# Eval("ALS_Target") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label5" runat="server" Text='<%# Eval("ALS_MTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label6" runat="server" Text='<%# Eval("ALS_MTD_Last_Month") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label2" runat="server" Text='<%# Eval("ALS_MTD_Last_Year") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label3" runat="server" Text='<%# Eval("ALS_YTD") %>'></asp:Label>
</td>
<td align="right" class="geo_view_col">
<asp:Label Width="45px" ID="Label4" runat="server" Text='<%# Eval("ALS_YTDLY") %>'></asp:Label>
</td>

</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</ItemTemplate>

</asp:TemplateField>
</Columns>
</asp:GridView>
</asp:Panel>
<br />
<br />
</div>
</form>

-------------------------------------------------------------------------------
.aspx.cs
-------------------------------------------------------------------------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
--------------------------------------------------------------------------
public partial class HierarchicalGridView : System.Web.UI.Page
{
public DataSet childDS;
GridView childgv;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string strRegion;
DataTable dtRegion = GetRegionsDT();
GridView1.DataSource = dtRegion.DefaultView;
GridView1.DataBind();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblRegn = (Label)GridView1.Rows[i].FindControl("lblRegion");
GridView childgv = (GridView)GridView1.Rows[i].FindControl("ChildGridView1");
DataTable dt = new DataTable();

strRegion = lblRegn.Text;
dt = GetAreaTable(strRegion);

childgv.DataSource = dt.DefaultView;
childgv.DataBind();
for (int ii = 0; ii < childgv.Rows.Count; ii++)
{
GridView grndChld = (GridView)childgv.Rows[ii].FindControl("ChildGridView2");
Label lblState = (Label)childgv.Rows[ii].FindControl("lblCity11");

DataTable dt1 = new DataTable();
dt1 = GetCityDT(lblState.Text);

grndChld.DataSource = dt1.DefaultView;
grndChld.DataBind();
}
}
}
btnCollapseAll.Attributes.Add("onclick", "return collapseAll('" + GridView1.Rows.Count + "')");
}

//Row Command is equivalent to datagrid's Item Command
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
}

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
// Retrieve the LinkButton control from the first column.
if (e.Row.Cells[0].Controls.Count > 1)
{
ImageButton expandButton = (ImageButton)e.Row.Cells[0].Controls[1];

// Set the LinkButton's CommandArgument property with the
// row's index.
//GridView1$ctl02$btnRegion
expandButton.Attributes.Add("onclick", "javascript:return firstlevelexpand('" + (e.Row.RowIndex + 2).ToString() + "');");
childgv = (GridView) e.Row.Cells[0].FindControl("ChildGridView1");
if (childgv != null)
childgv.RowCreated += ChildGridView1_RowCreated;
}
}
}

--------------------------------------------------------------------------
//To handle child grid events this is used. Dynamically I am adding events to child grid.
--------------------------------------------------------------------------
protected void ChildGridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.Cells[0].Controls.Count > 1)
{
ImageButton expandButton = (ImageButton)e.Row.Cells[0].FindControl("btnState");
string index, id2;
id2 = ((System.Web.UI.WebControls.CompositeDataBoundControl)(sender)).Controls[0].Parent.UniqueID.ToString();
id2 = id2.Replace("$", "_");

if (e.Row.RowIndex + 2 < 10)
index = "0" + (e.Row.RowIndex + 2).ToString();
else
index = (e.Row.RowIndex + 2).ToString();
expandButton.Attributes.Add("onclick", "javascript:return secondlevelexpand('" + ((System.Web.UI.WebControls.CompositeDataBoundControl)(sender)).Controls[0].Parent.UniqueID.ToString() + "$ctl" + index + "$btnState','" + id2 + "_ctl" + index + "_ChildGridView2');");
}
}
}

--------------------------------------------------------------------------
protected void Button1_Click(object sender, EventArgs e)
{
string strRegion;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Label lblRegn = (Label)GridView1.Rows[i].FindControl("lblRegion");
ImageButton btnRegion = (ImageButton)GridView1.Rows[i].FindControl("btnRegion");
btnRegion.ImageUrl = "expand.gif";
GridView childgv = (GridView)GridView1.Rows[i].FindControl("ChildGridView1");

DataTable dt = new DataTable();
strRegion = lblRegn.Text;
dt = GetAreaTable(strRegion);

childgv.DataSource = dt.DefaultView;
childgv.DataBind();
for (int ii = 0; ii < childgv.Rows.Count; ii++)
{
GridView grndChld = (GridView)childgv.Rows[ii].FindControl("ChildGridView2");
Label lblState = (Label)childgv.Rows[ii].FindControl("lblCity11");
ImageButton btnState = (ImageButton)childgv.Rows[ii].FindControl("btnState");
btnState.ImageUrl = "expand.gif";
DataTable dt1 = new DataTable();
dt1 = GetCityDT(lblState.Text);

grndChld.DataSource = dt1.DefaultView;
grndChld.DataBind();

if (grndChld != null)
{
grndChld.Visible = true;
}
}

if (childgv != null)
{

childgv.Visible = true;
}
}
}

--------------------------------------------------------------------------
private DataTable GetAreaTable(string strRegion)
{
//DataSet ds = new DataSet();
//SqlConnection cnn = new SqlConnection("Data Source=16.138.50.177;Integrated Security=SSPI;Initial Catalog=Maps");

////Create a second DataAdapter for the Titles table.
//SqlDataAdapter cmd2 = new SqlDataAdapter("select region ,area,dealer,ALS_Target,ALS_MTD,ALS_MTD_Last_Month,ALS_MTD_Last_Year,ALS_YTD,ALS_YTDLY from AreaSales where region = '" + strRegion + "'", cnn);
//cmd2.Fill(ds, "AreaSales");
//return ds.Tables["AreaSales"];
DataSet parentDataSource = new DataSet();
parentDataSource.Tables.Add(new DataTable("AreaSales"));

parentDataSource.Tables[0].Columns.Add("region");
parentDataSource.Tables[0].Columns.Add("Area");
parentDataSource.Tables[0].Columns.Add("Dealer");
parentDataSource.Tables[0].Columns.Add("ALS_Target");
parentDataSource.Tables[0].Columns.Add("ALS_MTD");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Month");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Year");
parentDataSource.Tables[0].Columns.Add("ALS_YTD");
parentDataSource.Tables[0].Columns.Add("ALS_YTDLY");

DataRow dr;
if (strRegion == "North")
{
dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "North";
dr[1] = "Delhi";
dr[2] = "D1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "North";
dr[1] = "Noida";
dr[2] = "D2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "North";
dr[1] = "Chandigarh";
dr[2] = "D3";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

}
else if (strRegion=="South")
{
dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "South";
dr[1] = "Bangalore";
dr[2] = "B1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "South";
dr[1] = "Hyderabad";
dr[2] = "H2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

dr = parentDataSource.Tables["AreaSales"].NewRow();
dr[0] = "South";
dr[1] = "Madras";
dr[2] = "M3";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["AreaSales"].Rows.Add(dr);

}
return parentDataSource.Tables["AreaSales"];

}

--------------------------------------------------------------------------
private DataTable GetCityDT(string strRegion)
{
//DataSet ds = new DataSet();
//SqlConnection cnn = new SqlConnection("Data Source=16.138.50.177;Integrated Security=SSPI;Initial Catalog=Maps");

////Create a second DataAdapter for the Titles table.
////SqlDataAdapter cmd2 = new SqlDataAdapter("select region ,area,dealer,ALS_Target,ALS_MTD,ALS_MTD_Last_Month,ALS_MTD_Last_Year,ALS_YTD,ALS_YTDLY,MS_Target,MS_YTD,ALD_Target,ALD_YTD,RS_Target,RS_MTD,RS_MTD_Last_Month,RS_MTD_Last_Year,RS_YTD,RS_YTDLY from DealerSales where area='" + strRegion + "'", cnn);
//SqlDataAdapter cmd2 = new SqlDataAdapter("select region ,area,dealer,ALS_Target,ALS_MTD,ALS_MTD_Last_Month,ALS_MTD_Last_Year,ALS_YTD,ALS_YTDLY from DealerSales where area='" + strRegion + "'", cnn);
//cmd2.Fill(ds, "DealerSales");

DataSet parentDataSource = new DataSet();
parentDataSource.Tables.Add(new DataTable("DealerSales"));

parentDataSource.Tables[0].Columns.Add("region");
parentDataSource.Tables[0].Columns.Add("Area");
parentDataSource.Tables[0].Columns.Add("Dealer");
parentDataSource.Tables[0].Columns.Add("ALS_Target");
parentDataSource.Tables[0].Columns.Add("ALS_MTD");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Month");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Year");
parentDataSource.Tables[0].Columns.Add("ALS_YTD");
parentDataSource.Tables[0].Columns.Add("ALS_YTDLY");
DataRow dr;
if (strRegion == "Delhi")
{

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Delhi";
dr[2] = "D1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Delhi";
dr[2] = "D2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Delhi";
dr[2] = "D3";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);
}
else if(strRegion=="Noida")
{
dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Noida";
dr[2] = "N1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Noida";
dr[2] = "N2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

}
else if (strRegion == "Chandigarh")
{
dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Chandigarh";
dr[2] = "C1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "North";
dr[1] = "Chandigarh";
dr[2] = "C2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);
}
else if (strRegion=="Bangalore")
{
dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Bangalore";
dr[2] = "B1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Bangalore";
dr[2] = "B2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Bangalore";
dr[2] = "B3";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

}
else if (strRegion == "Hyderabad")
{
dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Hyderabad";
dr[2] = "H1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Hyderabad";
dr[2] = "H2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Hyderabad";
dr[2] = "H3";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

}
else if (strRegion == "Madras")
{
dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Madras";
dr[2] = "M1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

dr = parentDataSource.Tables["DealerSales"].NewRow();
dr[0] = "South";
dr[1] = "Madras";
dr[2] = "M2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["DealerSales"].Rows.Add(dr);

}
return parentDataSource.Tables["DealerSales"];
}

//--------------------------------------------------------------------------
//Please note we are using dummy data here (for demonstration purpose)
//--------------------------------------------------------------------------

private DataTable GetRegionsDT()
{
DataSet parentDataSource = new DataSet();
parentDataSource.Tables.Add(new DataTable("RegionSales"));

parentDataSource.Tables[0].Columns.Add("region");
parentDataSource.Tables[0].Columns.Add("Area");
parentDataSource.Tables[0].Columns.Add("Dealer");
parentDataSource.Tables[0].Columns.Add("ALS_Target");
parentDataSource.Tables[0].Columns.Add("ALS_MTD");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Month");
parentDataSource.Tables[0].Columns.Add("ALS_MTD_Last_Year");
parentDataSource.Tables[0].Columns.Add("ALS_YTD");
parentDataSource.Tables[0].Columns.Add("ALS_YTDLY");
DataRow dr;

dr = parentDataSource.Tables["RegionSales"].NewRow();
dr[0] = "North";
dr[1] = "Delhi";
dr[2] = "D1";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["RegionSales"].Rows.Add(dr);

dr = parentDataSource.Tables["RegionSales"].NewRow();
dr[0] = "South";
dr[1] = "Delhi";
dr[2] = "D2";
dr[3] = "200";
dr[4] = "300";
dr[5] = "300";
dr[6] = "300";
dr[7] = "300";
dr[8] = "300";

parentDataSource.Tables["RegionSales"].Rows.Add(dr);

return parentDataSource.Tables["RegionSales"];

}

--------------------------------------------------------------------------
protected void Button2_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridView childgv = (GridView)GridView1.Rows[i].FindControl("ChildGridView1");
ImageButton btnRegion = (ImageButton)GridView1.Rows[i].FindControl("btnRegion");
btnRegion.ImageUrl = "collapse.gif";
if (childgv != null)
{
childgv.Visible = false;
}
}

}

//We can do this in Row Command also. Anyways we are able to fulfil the requirement.
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridView gv = (GridView)sender;

Int32 rowIndex = GridView1.SelectedRow.RowIndex;
string strRegion;

Label lblRegn = (Label)gv.Rows[rowIndex].FindControl("lblRegion");
ImageButton btn = (ImageButton)gv.Rows[rowIndex].FindControl("btnRegion");
if (btn.ImageUrl == "collapse.gif")
{
btn.ImageUrl = "expand.gif";
}
else
{
btn.ImageUrl = "collapse.gif";
}
strRegion = lblRegn.Text;

GridView childgv = (GridView)gv.Rows[rowIndex].FindControl("ChildGridView1");

if (childgv != null)
{
childgv.Visible = !childgv.Visible;
}
//to set focus to the row in the gridview in which the expand/collapse button was clicked
Page.SetFocus(gv.Rows[rowIndex]);
}

//-----------------------------------------------------------------------------------
//For the first time it takes the postback, next time onwards we are handling in
//javascript
//-----------------------------------------------------------------------------------
//To handle child grid's expand/collpase event.
protected void ChildGridView1_SelectedIndexChanged(object sender, EventArgs e)
{

GridView gv = (GridView)sender;

Int32 rowIndex = gv.SelectedRow.RowIndex;
string strRegion;

Label lblRegn = (Label)gv.Rows[rowIndex].FindControl("lblCity11");
ImageButton btn = (ImageButton)gv.Rows[rowIndex].FindControl("btnState");
if (btn.ImageUrl == "collapse.gif")
{
btn.ImageUrl = "expand.gif";
}
else
{
btn.ImageUrl = "collapse.gif";
}
strRegion = lblRegn.Text;

GridView childgv = (GridView)gv.Rows[rowIndex].FindControl("ChildGridView2");

if (childgv != null)
{
childgv.Visible = !childgv.Visible;
}
//to set focus to the row in the gridview in which the expand/collapse button was clicked
Page.SetFocus(gv.Rows[rowIndex]);
}

}

--------------------------------------------------------------------------

Points to note:
----------------
We have multiple columns to be displayed for each gridview. We make sure that alignments of all the girdviews are correct. So we have taken only one TemplateField (The data is formatted using Table tags) to display all columns of all the three gridviews.

Some style sheets are created for freezing the header row (class=fixedheadercell) and freezing any columns (class=fixedcolumn) though we have not frozen any columns.

Also, for the Collapse functionality Java scripts are used so that there is no postback.
For expand functionality the postback happens only for the first time. Subsequently Java scripts are used for expanding also.

Note:
Please note that we have used dummy data. So the data at the region level will not be the aggregated one of its areas sales data. The same holds for aggregated data for areas.

Page.SetFocus(Control)

2007-07-17T03:13:00.001-07:00

To maintain cursor position during postbacks (when the page has more content & there are scroll bars) we can use Page.SetFocus(controlname) in .NET 2.0

There is also another option to achive this :

set

SmartNavigation = true

for the page attribute in .aspx page (in HTML view).

SmartNavigation sometimes creates problems in production. It doesnt allow pages to be redirected to another page.

SQL SERVER date functions & some common points

2007-07-15T20:58:00.001-07:00

1. To know current year

select datepart("yy",getdate())

select year(getdate())

2. To know current month

select datepart("mm",getdate())

    select MONTH(GETDATE())

1. How to clear procedure cache
DBCC FREEPROCCACHE
we can use sp_recompile system procedure to recompile the stored procedure
at the time of creating the sp we can add a tag WITH RECOMPILE. This causes the stored procedure to be compiled every time when it is called.

2. How to view the contents of a stored procedure
sp_helptext

3. Difference between Logins and Users
Loing is to establish a connection to the database where as an user is to access a particular database in a sql server.

4. What is sql server Role
Roles contain specific properties & an user can belong to one or more roles.

5. delete duplicates: emp
ex: ID Name Value
1 a 10
2 b 20
3 c 30
4 b 20
5 d 40

DELETE FROM emp
where
ID NOT IN (SELECT MAX(ID) FROM emp e2 WHERE e2.Name = emp.Name AND e2.Value=emp.Value)

(or)

DELETE FROM emp
WHERE
ID > (
SELECT MIN(ID) FROM emp e2 WEHRE e2.Name = emp.Name AND e2.Value = emp.Value
)

(or)

DELETE FROM emp
WHERE
ID <
(
SELECT MAX(ID) FROM emp e2 WHERE e2.Name = emp.Name and e2.Value = emp.Value
)

case 2: If all the columns have same value for ex:
Name Value
1 10
1 10
2 20
2 20

in this scenario

select * into into #temp
(select distinct Name, Value FROM emp)
as T

delete from emp
insert into emp select * from #temp

solution2: Instead of using temp tables, we can do one more thing here.
create another table with this structure. Now add a new column called Id to this table with identity one.
Insert values from previous table to this new table. Drop the previous table. Now this case became case 1.

6. Retrieving Row number
SELECT ROW
select row_number() over(order by ename asc) as rownum from duptest

7. Retrieving Nth highest salary using co-related subquery:

SELECT * FROM emp e1
WHERE
0 = (select count(distinct sal) from emp e2 where e2.sal> e1.sal)

Inheritance Question

2007-07-05T21:24:00.000-07:00

public interface I1
{
void Method1();
}

public class A : I1
{
public void MethodA()
{
Console.WriteLine("In Method A");
}

public void Method1()
{
Console.WriteLine("I am in interface Method1");
}
}

[STAThread]
static void Main()
{
I1 obj = new A();
//Now can I access I1.MethodA();
}

Question: Can I access MethodA from obj.

Answer: Nop. You can't access it.

QUE

2007-07-05T21:19:00.000-07:00

1. what is GAC?
2. How do you create a shared assembly?
(What is the content of snk - strong name key file)
3. Contents of an assembly
4. Reflection?
5. What is meta-data?
6. Delegates means what?
7. Asynchronous call backs means what? How delegates & asynchronous call backs are interrelated?
8. Difference between user control & custom control
9. Can we use controls like dropdownlist etc. in custom control?
10. Do you know anything about Microsoft ApplicationBlocks? (For database interaction this component is used)
11. What do you mean by AJAX? (partial page rendering is the key concept of Ajax)
12. xmlhttprequest in AJAX
var req;

if (window.XMLHttpRequest) { // Non-IE browsers

req = new XMLHttpRequest();

} else if (window.ActiveXObject) { // IE

req = new ActiveXObject("Microsoft.XMLHTTP");

}

13. what is Common Type System
14. What is Finalize method
15. What is Dispose?
16. When do finalize method will be called. When do dispose be called?
17. Garbage Collection?
18. Best practices to be followed in project development
19. What do you mean by design patterns? Singleton design pattern?
20. Differences between Dataset & DataReader
21. Does 3-tier architecture increases performance? No.
22. What do you mean by XML serialization? Writing an object (public data & properties) to xml file. that is the object state information can be saved to xml & can be

retrieved back by deserializing.
Serialization is used for transportation. For accessing between different contexts (app domains) we go for object serialization.
23. What are the differences between Abstract base class & interface?
24. New features in .net framework 2.0
25. what do you mean by partial classes?

sql server
1.how can you return values from stored procedure. In how many ways can u do this.
return
out parameter
select statement

2.Exception Handling in stored procedures
Raise Error
@@ERROR

1. What is inheritance. Where did you use inheritance in your project.
2. What is overloading. Where did you use overloading in your project.
3. Why should I inherit a class from another class. I can just copy & paste the code from parent class. Isn't it?
answer: Yes you can do. But for maintenance & to reduce code redundancy you go for inheritance eventhough you can do copy & paste to the child class.
4. what is the difference between dataset & data reader.
5. can you tell the methods of a page class (init, prerender, load, error, unload etc.)
6. can u explain page execution life cycle. What happens when a page is executed
7. Why should we go for .NET framework, y can't we do with other development tools (like j2ee etc.)
8. differences between sql server 2000 & sql server 2005.
9. whats web.config file good for?
10. whats global.asax file
11.

Override and New Keywords (C#.NET)

2007-07-04T21:31:00.001-07:00

Override and New Keywords (C#.NET) :

// Define the base class
class Car
{
    public virtual void DescribeCar()
    {
        System.Console.WriteLine("Four wheels and an engine.");
    }
}

// Define the derived classes
class ConvertibleCar : Car
{
    public new virtual void DescribeCar()
    {
        base.DescribeCar();
        System.Console.WriteLine("A roof that opens up.");
    }
}

class Minivan : Car
{
    public override void DescribeCar()
    {
        base.DescribeCar();
        System.Console.WriteLine("Carries seven people.");
    }
}

public static void TestCars1()
{
    Car car1 = new Car();
    car1.DescribeCar();
    System.Console.WriteLine("----------");

    ConvertibleCar car2 = new ConvertibleCar();
    car2.DescribeCar();
    System.Console.WriteLine("----------");

    Minivan car3 = new Minivan();
    car3.DescribeCar();
    System.Console.WriteLine("----------");
}

Output:
Four wheels and an engine.

----------

Four wheels and an engine.

A roof that opens up.

----------

Four wheels and an engine.

Carries seven people.

----------

Test 2:
public static void TestCars2()
{
    Car[] cars = new Car[3];
    cars[0] = new Car();
    cars[1] = new ConvertibleCar();
    cars[2] = new Minivan();

foreach (Car vehicle in cars)
{
    System.Console.WriteLine("Car object: " + vehicle.GetType());
    vehicle.DescribeCar();
    System.Console.WriteLine("----------");
}

}

The output from this loop is as follows:

Car object: YourApplication.Car

Four wheels and an engine.

----------

Car object: YourApplication.ConvertibleCar

Four wheels and an engine.

----------

Car object: YourApplication.Minivan

Four wheels and an engine.

Carries seven people.

----------------------------------------------------------------------------------------------------------------
Notice how the ConvertibleCar description is not what you might expect. As the new keyword was used to define this method, the derived class method is not called—the base class method is called instead. The Minivan object correctly calls the overridden method, producing the results we expected.

If you want to enforce a rule that all classes derived from Car must implement the DescribeCar method, you should create a new base class that defines the method DescribeCar as abstract. An abstract method does not contain any code, only the method signature. Any classes derived from this base class must provide an implementation of DescribeCar.
---------------------------------------------------------------------------------------------------------
Reference: MSDN Library
http://msdn2.microsoft.com/en-us/library/ms173153(VS.80).aspx

Some Frequently used Java Script Functions

2007-07-04T01:50:00.001-07:00

/* --------------------- Used in KeyPress Validations --------------------------------
  KeyAscii Character
  32   Space
  40   (
  41   )
  45   -
  44   ,
  46   .
  48 - 57  0 to 9
  13   Enter
*/


function closewindows()
{
  if(win && win.open && !win.closed)
  win.close();
}

//----------------------------------------------------------------
function CheckNumeric(obj)
{
  if (document.getElementById(obj).value != '.')
  {
   var num = document.getElementById(obj).value;
   var testval = Math.ceil(num*10/10);

   if (!(testval > -1))
   {
    document.getElementById(obj).value = "";
    return;
   }
  }
}

/* --------- allows any float values with any number of decimal places ----------- */
function AllowFloat(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    if (!(window.event.keyCode == 46))
    {
     window.event.keyCode = null
    }
    else if (window.event.keyCode == 46)
    {
     if (document.getElementById(obj).value.lastIndexOf(".") > -1)
     {
      window.event.keyCode = null
     }
    }
   }
  }
}

/* --------- allows only 2 decimal places ----------- */
function AllowCurrency(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    if (!(window.event.keyCode == 46))
    {
     window.event.keyCode = null
    }
    else if ( window.event.keyCode == 46)
    {
     if (document.getElementById(obj).value.lastIndexOf(".") > -1)
     {
      window.event.keyCode = null
     }
    }
   }
   else
   {
    /* --- extra added to restrict to 2 decimal places --- */
    if (document.getElementById(obj).value.lastIndexOf(".") > -1)
    {
     if((document.getElementById(obj).value.length)-(document.getElementById(obj).value.lastIndexOf(".")) > 2)
     {
      window.event.keyCode = null
     }
    }
   }
  }
}


function AllowInt(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    window.event.keyCode = null
   }
  }
}

function AllowPhoneFax(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    if (!( (window.event.keyCode == 40) || (window.event.keyCode == 41) || (window.event.keyCode == 44) || (window.event.keyCode == 45) || (window.event.keyCode == 32) ))
    {
     window.event.keyCode = null
    }
   }
  }
}

function AllowZip(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    window.event.keyCode = null
   }
  }
}

function AllowNonNumeric(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    window.event.keyCode = null
   }
  }
}

function AllowCreditCardNumber(obj)
{
  if (window.event.keyCode == 13)
  {
   //do nothing
  }
  else
  {
   if (!((window.event.keyCode >= 48) && (window.event.keyCode <= 57)))
   {
    if (!( window.event.keyCode == 32 ))
    {
     window.event.keyCode = null
    }
   }
  }
}

function RTrim(VALUE)
{
var w_space = String.fromCharCode(32);
var v_length = VALUE.length;
var strTemp = "";
if(v_length < 0){
return"";
}
var iTemp = v_length -1;

while(iTemp > -1)
{
  if(VALUE.charAt(iTemp) == w_space){
  }
  else{
  strTemp = VALUE.substring(0,iTemp +1);
  break;
  }
  iTemp = iTemp-1;

} //End While
return strTemp;

} //End Function

function LTrim(VALUE){
var w_space = String.fromCharCode(32);
if(v_length < 1){
return"";
}
var v_length = VALUE.length;
var strTemp = "";

var iTemp = 0;

while(iTemp < v_length){
if(VALUE.charAt(iTemp) == w_space){
}
else{
strTemp = VALUE.substring(iTemp,v_length);
break;
}
iTemp = iTemp + 1;
} //End While
return strTemp;
} //End Function

Index on Primary Key

2007-07-03T22:32:00.001-07:00

How do I drop the index related to a primary key? DROP INDEX doesn't work.

Answer : A simple & direct answer is we can't do it directly. (according to my knowledge)

There are two work-arounds:

1. Create a clustered Index on another column & delete clustered index from that column.

2. Delete the constarint

sp_helpconstraint table_name

ALTER TABLE [database.[owner].]table_name
DROP CONSTRAINT constraint_name

Check if a table already exists in SQL SERVER

2007-07-03T22:08:00.001-07:00

1. if object_id('TABLE1') is not null

print 'Table exists'

2. if exists (select * from sysobjects where id = object_id('TABLE1') and OBJECTPROPERTY(id, N'IsUserTable') = 1 )

print 'Table exists'

3. if exists (select * from sysobjects where id = object_id('TABLE1') and xtype= 'U' )

print 'Table exists'

-----------------------------------------------------------------------------------------

How to test if a column for a table already exists?

select * from information_schema.columns WHERE TABLE_NAME ='Table1' and COLUMN_NAME ='col1'

Trigger Order

2007-07-03T21:43:00.001-07:00

How can I guarantee the order that SQL Server fires triggers?

SQL Server 7.0 does not guarantee the firing order of multiple triggers for the same action. If you need things to happen in a particular order, you'll need to put all the code in a single trigger.

In SQL 7.0 triggers actually fire in object id order, but this is NOT documented or guaranteed and therefore could change without warning in a service pack or new version.

With SQL 2000 you can now define the first and last trigger to fire using sp_settriggerorder. This is only available for AFTER triggers.

Triggers

2007-07-03T21:39:00.000-07:00

Question:

Does SQL Server support before and after (pre and post) triggers? What about "row" versus "set" triggers?

Answer:

SQL Server 7.0 and below only supports "after" triggers, however you can see what the "before" data was by using the logical tables 'inserted' and 'deleted', within the trigger.

SQL Server 2000 introduces INSTEAD OF triggers as well as the default "after" trigger. This trigger will be executed instead of the triggering statement, which makes it a very flexible alternative.

SQL Server triggers only fire once per query, so they are set triggers rather than row triggers.

SQL Server does not support SELECT triggers (trigger fire only on Insert, Update & Delete statements but not on Select statements).

Showing an alert using Javascript

2007-06-15T02:17:00.001-07:00

This is the Javascript code to show an alert if users keep the web page open & unattended for more than 10 minutes.

----------------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------------

function pageload()

{

window.setInterval("SetAlert()",480000);

}

----------------------------------------------------------------------------------------------------------------------------------

function SetAlert()

{

//In my example alert is on the same page. You can embed another .html page also here.

document.getElementById('divSession').style.display='';

document.getElementById('divSession').style.posTop=200;

document.getElementById('divSession').style.posLeft=250;

document.getElementById('divSession').style.width=430;

document.getElementById('divSession').style.height=130;

window.setInterval("document.getElementById('divSession').style.display='none'",115000);

}

----------------------------------------------------------------------------------------------------------------------------------

<tr>

You are not browing this site from 10 minutes.

<br>

<INPUT type='submit' value='OK' onClick='CloseWin()' style="WIDTH: 103px" ID="Submit1"

NAME="Submit1">

</p>

</td>

</tr>

</table>

</div>

----------------------------------------------------------------------------------------------------------------------------------

function CloseWin()

{

//Anything you can write here.

document.getElementById('divSession').style.display='none';

}

Sorting a ListBox using Javascript

2007-06-15T01:46:00.001-07:00

Javascript code for sorting a listbox:

<hr>

function SortList()

{

var last = document.getElementById("listBox1").options.length - 2;

var isChanged = 1;

var TempText,TempVal;

while ( last >= 0 && isChanged )

{

isChanged = 0;

for ( var k = 0; k <= last; k++ )

if ( document.getElementById("listBox1")(k).text.toUpperCase() > document.getElementById("listBox1")(k+1).text.toUpperCase() )

{

TempText = document.getElementById("listBox1")(k).text;

TempVal = document.getElementById("listBox1")(k).value;

document.getElementById("listBox1")(k).text = document.getElementById("listBox1")(k+1).text;

document.getElementById("listBox1")(k).value = document.getElementById("listBox1")(k+1).value;

document.getElementById("listBox1")(k+1).text = TempText;

document.getElementById("listBox1")(k+1).value = TempVal;

isChanged = 1;

}

last--;

}

return;

}

Bharathi Kambhampati

Freeze Table Columns & Non-Scroll Headers (HTML & CSS)

2007-06-12T22:06:00.001-07:00

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>1aaa</title>
<style type="text/css">
div#tbl-container {
width: 700px;
height: 252px;
overflow: auto;
scrollbar-base-color:#ffeaff;
}

table {
table-layout: fixed;
border-collapse: collapse;
background-color: WhiteSmoke;
}

div#tbl-container table th {
width: 100px;
}

thead th, thead th.locked {
font-size: 14px;
font-weight: bold;
text-align: center;
background-color: navy;
color: white;
border-right: 1px solid silver;
position:relative;
cursor: default;
}

thead th {
top: expression(document.getElementById("tbl-container").scrollTop-2); /* IE5+ only */
z-index: 20;
}

thead th.locked {z-index: 30;}

td.locked, th.locked{
background-color: white;
font-weight: bold;
border-right: 1px solid silver;
left: expression(parentNode.parentNode.parentNode.parentNode.scrollLeft); /* IE5+ only */
position: relative;
z-index: 10;
}

</style>

</head>

<tbody>

<tr>
    <td class="locked">Student01</td>
    <td>Languages</td>
    <td>male</td>
    <td>80</td>
    <td>70</td>
    <td>75</td>
    <td>80</td>

</tr>
<tr>
    <td class="locked">Student02</td>
    <td>Mathematics</td>
    <td>male</td>
    <td>90</td>
    <td>88</td>
    <td>100</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student03</td>
    <td>Languages</td>
    <td>female</td>
    <td>85</td>
    <td>95</td>
    <td>80</td>
    <td>85</td>

</tr>
<tr>
    <td class="locked">Student04</td>
    <td>Languages</td>
    <td>male</td>
    <td>60</td>
    <td>55</td>
    <td>100</td>
    <td>100</td>

</tr>
<tr>
    <td class="locked">Student05</td>
    <td>Languages</td>
    <td>female</td>
    <td>68</td>
    <td>80</td>
    <td>95</td>
    <td>80</td>

</tr>
<tr>
    <td class="locked">Student06</td>
    <td>Mathematics</td>
    <td>male</td>
    <td>100</td>
    <td>99</td>
    <td>100</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student07</td>
    <td>Mathematics</td>
    <td>male</td>
    <td>85</td>
    <td>68</td>
    <td>90</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student08</td>
    <td>Languages</td>
    <td>male</td>
    <td>100</td>
    <td>90</td>
    <td>90</td>
    <td>85</td>

</tr>
<tr>
    <td class="locked">Student09</td>
    <td>Mathematics</td>
    <td>male</td>
    <td>80</td>
    <td>50</td>
    <td>65</td>
    <td>75</td>

</tr>
<tr>
    <td class="locked">Student10</td>
    <td>Languages</td>
    <td>male</td>
    <td>85</td>
    <td>100</td>
    <td>100</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student11</td>
    <td>Languages</td>
    <td>male</td>
    <td>86</td>
    <td>85</td>
    <td>100</td>
    <td>100</td>

</tr>
<tr>
    <td class="locked">Student12</td>
    <td>Mathematics</td>
    <td>female</td>
    <td>100</td>
    <td>75</td>
    <td>70</td>
    <td>85</td>

</tr>
<tr>
    <td class="locked">Student13</td>
    <td>Languages</td>
    <td>female</td>
    <td>100</td>
    <td>80</td>
    <td>100</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student14</td>
    <td>Languages</td>
    <td>female</td>
    <td>50</td>
    <td>45</td>
    <td>55</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student15</td>
    <td>Languages</td>
    <td>male</td>
    <td>95</td>
    <td>35</td>
    <td>100</td>
    <td>90</td>

</tr>
<tr>
    <td class="locked">Student16</td>
    <td>Languages</td>
    <td>female</td>
    <td>100</td>
    <td>50</td>
    <td>30</td>
    <td>70</td>

</tr>
<tr>
    <td class="locked">Student17</td>
    <td>Languages</td>
    <td>female</td>
    <td>80</td>
    <td>100</td>
    <td>55</td>
    <td>65</td>

</tr>
</tbody>
</table>
</div>
</body>

</html>

Source:http://web.tampabay.rr.com/bmerkey/examples/locked-column-csv.html

SQL SERVER 2000 Maximum Capacity Specifications

2007-06-05T03:55:00.001-07:00


Object	SQL Server 2000
Batch size	65,536 * Network Packet Size¹
Bytes per sort string column	8,000
Bytes per text, ntext, or image column	2 GB-2
Bytes per GROUP BY, ORDER BY	8,060
Bytes per index	900²
Bytes per foreign key	900
Bytes per primary key	900
Bytes per row	8,060
Bytes in source text of a stored procedure	Lesser of batch size or 250 MB
Clustered indexes per table	1
Columns in GROUP BY, ORDER BY	Limited only by number of bytes per GROUP BY, ORDER BY
Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement
Columns per index	16
Columns per foreign key	16
Columns per primary key	16
Columns per base table	1,024
Columns per SELECT statement	4,096
Columns per INSERT statement	1,024
Connections per client	Maximum value of configured connections
Database size	1,048,516 TB³
Databases per instance of SQL Server	32,767
Filegroups per database	256
Files per database	32,767
File size (data)	32 TB
File size (log)	32 TB
Foreign key table references per table	253
Identifier length (in characters)	128
Instances per computer	16
Length of a string containing SQL statements (batch size)	65,536 * Network packet size¹
Locks per connection	Max. locks per server
Locks per instance of SQL Server	2,147,483,647 (static) 40% of SQL Server memory (dynamic)
Nested stored procedure levels	32
Nested subqueries	32
Nested trigger levels	32
Nonclustered indexes per table	249
Objects concurrently open in an instance of SQL Server⁴	2,147,483,647 (or available memory)
Objects in a database	2,147,483,647⁴
Parameters per stored procedure	2,100
REFERENCES per table	253
Rows per table	Limited by available storage
Tables per database	Limited by number of objects in a database⁴
Tables per SELECT statement	256
Triggers per table	Limited by number of objects in a database⁴
UNIQUE indexes or constraints per table	249 nonclustered and 1 clustered

Maximum Capacity Specifications for SQL Server 2005

2007-06-05T03:51:00.000-07:00

The following table specifies the maximum sizes and numbers of various objects defined in SQL Server 2005 databases or referenced in Transact-SQL statements. The table does not include SQL Server Windows CE Edition.

SQL Server 2005 Database Engine object	Maximum sizes/numbers SQL Server 2005 (32-bit)	Maximum sizes/numbers SQL Server 2005 (64-bit)
Batch size¹	65,536 * Network Packet Size	65,536 * Network Packet Size
Bytes per short string column	8,000	8,000
Bytes per GROUP BY, ORDER BY	8,060	8,060
Bytes per index key²	900	900
Bytes per foreign key	900	900
Bytes per primary key	900	900
Bytes per row⁸	8,060	8,060
Bytes per varchar(max), varbinary(max), xml, text, or image column	2^31-1	2^31-1
Characters per ntext or nvarchar(max) column	2^30-1	2^30-1
Clustered indexes per table	1	1
Columns in GROUP BY, ORDER BY	Limited only by number of bytes	Limited only by number of bytes
Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement	10	10
Columns per index key⁷	16	16
Columns per foreign key	16	16
Columns per primary key	16	16
Columns per base table	1,024	1,024
Columns per SELECT statement	4,096	4,096
Columns per INSERT statement	1,024	1,024
Connections per client	Maximum value of configured connections	Maximum value of configured connections
Database size	1,048,516 terabytes	1,048,516 terabytes
Databases per instance of SQL Server	32,767	32,767
Filegroups per database	32,767	32,767
Files per database	32,767	32,767
File size (data)	16 terabytes	16 terabytes
File size (log)	2 terabytes	2 terabytes
Foreign key table references per table⁴	253	253
Identifier length (in characters)	128	128
Instances per computer	50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances. SQL Server 2005 supports 25 instances on a failover cluster.	50 instances on a stand-alone server. 25 instances on a failover cluster.
Length of a string containing SQL statements (batch size)¹	65,536 * Network packet size	65,536 * Network packet size
Locks per connection	Maximum locks per server	Maximum locks per server
Locks per instance of SQL Server⁵	Up to 2,147,483,647	Limited only by memory
Nested stored procedure levels⁶	32	32
Nested subqueries	32	32
Nested trigger levels	32	32
Nonclustered indexes per table	249	249
Parameters per stored procedure	2,100	2,100
Parameters per user-defined function	2,100	2,100
REFERENCES per table	253	253
Rows per table	Limited by available storage	Limited by available storage
Tables per database³	Limited by number of objects in a database	Limited by number of objects in a database
Partitions per partitioned table or index	1,000	1,000
Statistics on non-indexed columns	2,000	2,000
Tables per SELECT statement	256	256
Triggers per table³	Limited by number of objects in a database	Limited by number of objects in a database
UNIQUE indexes or constraints per table	249 nonclustered and 1 clustered	249 nonclustered and 1 clustered
User connections	32,767	32,767
XML indexes	249	249

Source: http://technet.microsoft.com/en-us/library/ms143432.aspx

My experiences in .NET

Exception handling difference between .NET Framework 1.1 and 2.0

Serialize a class to XML

Stored Procedures Performance Tuning

Regular Expressions

Regular Expressions

Character Classes http://tinyurl.com/5ck4ll

Custom Validator to validate Date

Printing Date in different formats

Regular Expression that accepts 0-9,space,/,+,- only

Calling a web-service

What happens when an asp.net page is requested from the browser

Crystal Reports in ASP.NET

Posting to my blog after a very long time

Upload a file in Window application

VB.NET + ASP.NET + Data Grid + V1.x

Calling a DB2 Stored Procedure from .NET

Programmatically determine if a File is an assembly

Dynamically Bind Event Handlers at Run Time in ASP.NET

Microsoft recruits white hat hackers

SQL Server free tools by Idera

SQL Server 2008 Katmai,

Technorati Profile

Properties of WebMethod() Attribute

Assembly Cache Viewer (Shfusion.dll)

SQL : Finding Nth highest salary in different ways

Beauty of Code Snippets

Hierarchical Grid View (3-levels)

Page.SetFocus(Control)

SQL SERVER date functions & some common points

Inheritance Question

QUE

Override and New Keywords (C#.NET)

Some Frequently used Java Script Functions

Index on Primary Key

Check if a table already exists in SQL SERVER

Trigger Order

Triggers

Showing an alert using Javascript

Sorting a ListBox using Javascript

Freeze Table Columns & Non-Scroll Headers (HTML & CSS)

SQL SERVER 2000 Maximum Capacity Specifications

Maximum Capacity Specifications for SQL Server 2005