Extending an ASP.NET Datagrid to Support Simple Cross Tab Reporting: The Structure - The enumerations declared in the custom control
(Page 2 of 4 )
Let us start with all the enumerations I declared. First look at the following:
Public Enum OperationType
Sum
Avg
Max
Min
Count
End Enum
The above mainly deals with the type of operation you may want to process for the cross tab. This is essential; you can even add few more according to your requirements. Now let us look at the following:
Public Enum ObjectType
Table
StoredProcedure
End Enum
Sometimes, the cross-tab information must be retrieved either from a table or stored procedure. The above code handles that. And finally look at the following:
Public Enum MSSQLDataType
SQLString
SQLChar
SQLInteger
SQLBit
SQLDateTime
SQLDecimal
SQLMoney
SQLImage
SQLFloat
End Enum
Those are the only data types (my own interpretation) I am focusing on at the moment. The mapping of these custom data types to the original data types will be dealt with in the “SPAddParameter” method.
Next: The properties available to customize the custom control >>
More ASP.NET Articles
More By Jagadish Chaterjee
