Saturday, February 23, 2013

C# Constructors



1. Constructor is special method of a class that has the same name as the class and that does not have any return value.
2. A constructor that does not take any parameter (i.e. parameter less) is called default constructor.
3. In C#, all classes (except static classes) and structs are required to have default (parameter less) constructor.
4. static classes are not required to have default constructor. But if a constructor is provided to static class, then it must be static and it must be parameter less.
              *static classes cannot have instance constructors.
              *static class constructor must be static
              *static class constructor must be parameter less.
In short static classes can have only one constructor, and it must be static and parameter less.
5. structs  CANNOT have explicit default constructor. A default constructor is always provided by compiler to structs and it not allowed to code default constructor for structs.
6. Classes can have multiple constructors, each with different signature. These are called overloaded constructors.
7. If a parametered constructor is provided for a class, then default constructor MUST also be provided. Compiler provides default constructor only when no constructors are provided to the class.
8. Abstract classes can also have constructors, and rules for abstract class constructors are same as those of any non-static class constructors.

Saturday, February 16, 2013

What is the difference between an interface and an abstract class ?
Interface    Abstract Class
You cannot use access specifiers with members of an interface. All interface members are implicitly public and cannot have any other access specifier.    Members of abstract class can have all access specifiers except private i.e. they can be internal, public, protected and protected internal but not private.
All the members of an interface are implicitly abstract (although you cannot explicitly use abstract keyword because it not allowed to use access specifiers in interface).    An abstract class can have non-abstract members.
Interface cannot have static members.    Abstract classes can have non-abstract static members.
A class can inherit one or more interfaces.     A class can inherit from only one abstract (or non-abstract ) class.
Modifying an interface results in breaking the existing clients. This is because clients must implement all interface members, and interface members are only declarations , no code or values are allowed.    Not all modifications in an abstract class break existing clients. E.g. adding a new non-abstract method to the base abstract class will not break existing clients.
Interfaces CANNOT have constructors and destructors.    Constructors and destructors ARE ALLOWED in abstract classes.
The abstract class constructors cannot be abstract or private.
Interface    Abstract Class
You cannot use access specifiers with members of an interface. All interface members are implicitly public and cannot have any other access specifier.    Members of abstract class can have all access specifiers except private i.e. they can be internal, public, protected and protected internal but not private.
All the members of an interface are implicitly abstract (although you cannot explicitly use abstract keyword because it not allowed to use access specifiers in interface).    An abstract class can have non-abstract members.
Interface cannot have static members.    Abstract classes can have non-abstract static members.
A class can inherit one or more interfaces.     A class can inherit from only one abstract (or non-abstract ) class.
Modifying an interface results in breaking the existing clients. This is because clients must implement all interface members, and interface members are only declarations , no code or values are allowed.    Not all modifications in an abstract class break existing clients. E.g. adding a new non-abstract method to the base abstract class will not break existing clients.
Interfaces CANNOT have constructors and destructors.    Constructors and destructors ARE ALLOWED in abstract classes.
The abstract class constructors cannot be abstract or private.
   
Interface    Abstract Class
You cannot use access specifiers with members of an interface. All interface members are implicitly public and cannot have any other access specifier.    Members of abstract class can have all access specifiers except private i.e. they can be internal, public, protected and protected internal but not private.
All the members of an interface are implicitly abstract (although you cannot explicitly use abstract keyword because it not allowed to use access specifiers in interface).    An abstract class can have non-abstract members.
Interface cannot have static members.    Abstract classes can have non-abstract static members.
A class can inherit one or more interfaces.     A class can inherit from only one abstract (or non-abstract ) class.
Modifying an interface results in breaking the existing clients. This is because clients must implement all interface members, and interface members are only declarations , no code or values are allowed.    Not all modifications in an abstract class break existing clients. E.g. adding a new non-abstract method to the base abstract class will not break existing clients.
Interfaces CANNOT have constructors and destructors.    Constructors and destructors ARE ALLOWED in abstract classes.
The abstract class constructors cannot be abstract or private.
   

jQuery and GridView : How to highlight current row/current cell on mouseover ?

It is particularly very simple to highlight a row /highlight a gridview cell on mouseover.

GridView can be access by its ID as a table and its row can be accessed as a "tr", its cell can be accessed as "tr td", in the simplest case.

So I can have something like following to change the color of a row on mouseover, and recover the color on mouseout :


$(document).ready(function() {
                             $("#GridView1 tr").mouseover(function() { $(this).css("background-color", "Red"); }).mouseout(function() { $(this).css("background-color", "White"); });
             
           });


The same can be done for a cell simply by changing "tr" to "tr td" :


$(document).ready(function() {
                             $("#GridView1 tr td").mouseover(function() { $(this).css("background-color", "Red"); }).mouseout(function() { $(this).css("background-color", "White"); });
             
           });



"#GridView1 tr td" can be literally interpreted as "for each td in each tr in a parent element named GridView1"

Same way code can be written for click event also:

$(document).ready(function() {
               alert("hello");
               $("#GridView1 tr").mouseover(function() { $(this).css("background-color", "Red"); }).mouseout(function() { $(this).css("background-color", "White"); });
               $("#GridView1 tr").click(function() { $(this).css("background-color", "Green"); });              
           });





This code was tested using jquery-1.7.2 :
 <script type="text/javascript" src="jquery-1.7.2.min.js"></script>


Saturday, January 19, 2013


Difference between AFTER and INSTEAD OF TRIGGERS


1. Views cannot have AFTER triggers.
2. We can have multiple AFTER triggers on EACH of the Update/Insert/Delete statements, where as we can have only ONE INSTEAD OF triggers for all these.
3. AFTER triggers do not affect the DML operation that caused them, however INSTEAD OF triggers are invoked instead of the DML operation.

Sunday, November 13, 2011

The confusing "Invalid postback or callback argument" error in an .aspx page.


Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Invalid postback or callback argument.  Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page.  For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them.  If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.




Here is one possible condition, in which I could simulate this error :

You populate a GridView in Page_Load always. Instead normally you should do it only in case of post bacK :

       if ( !Page.IsPostBack)
{
            //.... code to populate the gridview
            pui.PopulateGrid(CustomerGridView, scmbl_cust.GetCustomerDataTable());
 
}

If you comment the !Page.IsPostBack, you will get the above error.

Thursday, September 15, 2011

GridView Vertical text in headers

http://forums.asp.net/t/1049758.aspx/1




.verticaltext

{

font:bold 10px Tahoma;

color: #0000FF;

writing-mode: tb-rl;

filter: flipH() flipV();

}

So what I am doing is loading my gridview like usual, and then adding a _DataBound event for the gridview.  So here is the code to rotate the header row.

Protected Sub gvMatrix_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvMatrix.DataBound

Dim style As New Web.UI.WebControls.Style

Dim row As GridViewRow = gvMatrix.HeaderRow

style.CssClass = "verticaltext"

For Each cell As TableCell In row.Cells

cell.ApplyStyle(style)

Next

end sub

Friday, September 2, 2011

Paging at DAL




PAGING AT DAL

1. http://www.codeproject.com/KB/webforms/GridViewCustomPaging.aspx
====================================================================
CREATE PROCEDURE [usp_GetProducts]
@startRowIndex int,
@maximumRows int,
@totalRows int OUTPUT

AS

DECLARE @first_id int, @startRow int

SET @startRowIndex =  (@startRowIndex - 1)  * @maximumRows

IF @startRowIndex = 0
SET @startRowIndex = 1

SET ROWCOUNT @startRowIndex

SELECT @first_id = ProductID FROM Products ORDER BY ProductID

PRINT @first_id

SET ROWCOUNT @maximumRows

SELECT ProductID, ProductName FROM Products WHERE
ProductID >= @first_id
ORDER BY ProductID

SET ROWCOUNT 0

-- GEt the total rows

SELECT @totalRows = COUNT(ProductID) FROM Products
GO
====================================================================

2. http://www.aspsnippets.com/Articles/Custom-Paging-in-ASP.Net-GridView-using-SQL-Server-Stored-Procedure.aspx

====================================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
CREATE PROCEDURE GetCustomersPageWise
      @PageIndex INT = 1
      ,@PageSize INT = 10
      ,@RecordCount INT OUTPUT
AS
BEGIN
      SET NOCOUNT ON;
      SELECT ROW_NUMBER() OVER
      (
            ORDER BY [CustomerID] ASC
      )AS RowNumber
      ,[CustomerID]
      ,[CompanyName]
      ,[ContactName]
     INTO #Results
      FROM [Customers]
     
      SELECT @RecordCount = COUNT(*)
      FROM #Results
           
      SELECT * FROM #Results
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
     
      DROP TABLE #Results
END
GO
====================================================================

Comparing features of LangGraph vs CrewAI

LangGraph Orchestration vs CrewAI Orchestration The following table compares LangGraph and CrewAI orchestration across their menta...