AS/400 iseries in ASP.NET

Issue
Connecting to AS/400 from ASP.NET, following are the options available:
1. rfrompcb.exe

Fails with no error message but the following output:

IBM iSeries Access for WindowsVersion 5 Release 2 Level 0Transfer data to iSeries(C) Copyright IBM Corporation and Others 1984, 2002. All rights reserved.U.S. Government Users Restricted Rights - Use, duplication or disclosurerestricted by GSA ADP Schedule Contract with IBM Corp.Licensed Materials - Property of IBM

2. Program Files/IBM/Client Access/Shared/cwbx.dll - IBM AS/400 Client Acess Express ActiveX Object Library

Fails with [COMException] 'Unspecified Error' exception

Conclusion

The conclusion after a detailed study was the connectivity failed from ASP.NET but worked with from commandline or desktop application.

Problem

The problem is the identity under which aspnet worker process works is as configured in machine.config meaning 'machine' or SYSTEM or any NT user as specified and this user doesn't have rights to access AS/400 through the firewall.

Solution

The solution to this problem is to set the username and password values of tag in machine.config to the user that had access to AS/400 and limited rights on the webserver.

<ProcessModel>

Many a times asp.net code fails with or without an error but if the same is tried manually, it works!

Example:

• Open Browser and type a URL; you are able to visit the site but when you try to do the same in ASP.NET using webrequest.create method, it fails with an error The underlying connection was closed: Unable to connect to the remote server.
• Run a batch file that utilizes network resources; the batch file executes successfully but when you try to do the same in ASP.NET using process.start method, it fails without any error

Wonder why?

The reason is ASP.NET by default runs under the context of ASPNET user, change the <processmodel> tag and specify a user who is authorized to access the web server as well as network/domain resources and your code will work.

SQL Server Custom Paging

You can use a query of the following form to retrieve records by row number from Microsoft SQL Server:

SELECT *
FROM (SELECT TOP {0} *
FROM (SELECT TOP {1} *
FROM {2}
ORDER BY {3}) AS t1
ORDER BY {3} DESC) AS t2
ORDER BY {3}

Replace:
{0} with the page size (the number of records displayed on each page),
{1} with the page size * page number (1-based),
{2} with the name of the table you wish to query, and
{3} with a field name.

The following example retrieves rows 41-50 from the "Products" table of the Northwind database:

SELECT *
FROM (SELECT TOP 10 *
FROM (SELECT TOP 50 *
FROM Products
ORDER BY ProductID) AS t1
ORDER BY ProductID DESC) AS t2
ORDER BY ProductID

You can combine this query technique with custom paging to make DataGrid paging more efficient. With default paging, you must initialize the data source with all records displayed on all pages. With custom paging, you can initialize the data source with just those records that pertain to the current page.

Undocumented SQL SP's

Every MS product has features beyond exploitation and more beyond documentation

Here is one such stored procedure, which is undocumented but is very useful for developers:

sp_MSforeachtable (T-SQL)

Syntax

sp_MSforeachtable[@command1 =] 'sql_command'
[, [@replacechar =] 'replacement_character']
[, [@command2 =] 'sql_command']
[, [@command3 =] 'sql_command']
[, [@whereand =] 'sql_command']
[, [@precommand =] 'sql_command']
[, [@postcommand =] 'sql_command']

Arguments

[@command1 =] 'sql_command'
Is the sql command to apply to each user table with the replacement_character where the table name would normally be placed. 'sql_command' is nvarchar(2000)*, varchar(255)+ with no default.

[, [@replacechar =] 'replacement_character']
Is the wild card character that will be replaced with each user table name. replacement_character is char(1) with a default of '?'

[, [@command2 =] 'sql_command']
Is the continuation of the sql command entered in @command1 to apply to each user table with the replacement_character where the table name would normally be placed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. (Note: This parameter is not as useful on 7.0 since there are 4000 characters available in @command1)

[, [@command3 =] 'sql_command']
Is the continuation of the sql command entered in @command2 to apply to each user table with the replacement_character where the table name would normally be placed. 'sql_command' is nvarchar(2000)*, varchar(255)+ with a default of NULL. (Note: This parameter is not as useful on 7.0 since there are 4000 characters available in @command1)

[, [@whereand =] 'sql_command']
Is an additional where clause to limit the result set of the user table select. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is added to the select that retrieves the user tables as passed to the procedure. It MUST be a valid where clause for a select against sysobjects.

[, [@precommand =] 'sql_command']
Is the sql command to be executed once before @command1 is processed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is executed as passed to the procedure.

[, [@postcommand =] 'sql_command']
Is the sql command to be executed once after @command1 is processed. sql_command is nvarchar(2000)*, varchar(255)+ with a default of NULL. No wild card replacement occurs. It is executed as passed to the procedure.

Return Code Values
0 (success) or @@ERROR (failure)
Result Sets

sp_MSforeachtable returns this message if no parameters are specified:

Procedure 'sp_MSforeachtable' expects parameter '@command1', which was not supplied.
Remarks

The procedure sp_MSforeachtable executes a set of commands against all the user tables in the current database. The sp_MSforeachtable procedure executes the precommand if entered. It then declares a cursor called hCForEach against sysobjects in the current database and passes the actual commands to be executed to sp_MSforeach_worker. The post command is then executed if entered.

Examples

Get the number of rows in each user table
sp_MSforeachtable 'print ''?'' select count(*) from ?'
sp_MSforeachtable 'select count(*) "?" from ?'

Grant SELECT permission to the developers on every user table
EXECUTE sp_MSforeachtable 'GRANT SELECT ON ? TO Developers'

Grant all permissions to the database maintenance role on every user meta data table
EXECUTE sp_MSforeachtable @command1 = 'PRINT ''?'' GRANT SELECT , INSERT , UPDATE , DELETE ON ? TO dbMaintenace', @whereand = 'AND name LIKE ''tbl%REF'' ORDER BY uid , name', @precommand = 'PRINT ''Granting permission on...''', @postcommand = 'PRINT ''Complete!'''

This is an exhaustive list of SQL Server undocumented stored procedures, yet to be explored by the world:

sp_MSchunkgeneration
sp_MSchunkgeneration
sp_MSgettools_path
sp_MSregistersubscription
sp_MSregistersubscription
sp_MSregistersubscription
sp_MS_upd_sysobj_category
sp_MSget_agent_names
sp_MSunregistersubscription
sp_MScleanup_conflict
sp_MSinit_replication_perfmon
sp_MSsubscription_enabled_for_syncmgr
sp_MSgetreplnick
sp_MSrepl_startup
sp_MSget_jobstate
sp_MSreplcheck_publish
sp_MShelpmergeconflictcounts
sp_MShelpmergeconflictcounts
sp_MSscriptmvastablenci
sp_MSflush_access_cache
sp_MSscript_pkvar_assignment
sp_MSscript_pkvar_assignment
sp_MSlocktable
sp_MShelpmergeconflictpublications
sp_MSscriptmvastablepkc
sp_MSreinit_failed_subscriptions
sp_MSreinit_failed_subscriptions
sp_MSget_publication_from_taskname
sp_MSenumcolumns
sp_MSclearcolumnbit
sp_MSscriptmvastableidx
sp_MSacquireHeadofQueueLock
sp_MSsetaccesslist
sp_MSscriptmvastable
sp_MSrepl_gettype_mappings
sp_MSacquireSlotLock
sp_MSreplcheck_pull
sp_MSreplcheck_pull
sp_MSreleaseSlotLock
sp_MSreplcheck_connection
sp_MSfix_6x_tasks
sp_MSfix_6x_tasks
sp_MSrepl_check_server
sp_MSrepl_PAL_rolecheck
sp_MShelpconflictpublications
sp_MSreset_synctran_bit
sp_MSreplcheck_qv
sp_MSenum_replsqlqueues
sp_MSenum_replqueues
sp_MSreplcheck_subscribe
sp_MScleanupmergepublisher
sp_MSreplicationcompatlevel
sp_MSaddpubtocontents
sp_MScleanupdynsnapshotvws
sp_MShelp_identity_property
sp_MShelp_identity_property
sp_MSget_subtypedatasrc
sp_MSpub_adjust_identity
sp_MSpub_adjust_identity
sp_MScleanupmergepublisherdb
sp_MScopysnapshot
sp_MScopysnapshot
sp_MSgenreplnickname
sp_MShelp_replication_table
sp_MSmergesubscribedb
sp_MScopyscriptfile
sp_MSenumallsubscriptions
sp_MSdrop_6x_replication_agent
sp_MSrepl_validate_dts_package
sp_MSenumsubscriptions
sp_MSenumsubscriptions
sp_MScomputemergearticlescreationorder
sp_MScomputemergearticlescreationorder
sp_MSreinit_article
sp_MSreinit_article
sp_MSget_load_hint
sp_MSenumallpublications
sp_MSenumallpublications
sp_MScomputemergeunresolvedrefs
sp_MScomputearticlescreationorder
sp_MScomputearticlescreationorder
sp_MSenumtranpublications
sp_MSCheckmergereplication
sp_MScomputeunresolvedrefs
sp_MSverifytranfilter
sp_MSenummergepublications
sp_MSgetpubinfo
sp_MShelptranconflictpublications
sp_MSenum3rdpartypublications
sp_MSaddmergedynamicsnapshotjob
sp_MSaddmergedynamicsnapshotjob
sp_MSaddmergedynamicsnapshotjob
sp_MShelptranconflictcounts
sp_MShelptranconflictcounts
sp_MSenumthirdpartypublicationvendornames
sp_MSdropmergedynamicsnapshotjob
sp_MSdropmergedynamicsnapshotjob
sp_MSgettranconflictrow
sp_MSagent_access_check
sp_MShelpmergedynamicsnapshotjob
sp_MSgettrancftsrcrow
sp_MSgettrancftsrcrow
sp_MSremove_userscript
sp_MSdeletetranconflictrow
sp_MSupdatesharedagentproperties
sp_MSupdatesharedagentproperties
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSdrop_rlrecon
sp_MSexternalfkreferences
sp_MSfetchidentityrange
sp_MSgetarticlereinitvalue
sp_MSfixupdistributorinfo
sp_MScheckidentityrange
sp_MSispkupdateinconflict
sp_MSfixupdistributorsecurity
sp_MShelpmergeidentity
sp_MSisnonpkukupdateinconflict
sp_MSrestore_sub_merge
sp_MSrestore_sub_merge
sp_MSrestore_sub_merge
sp_MSfixupftpinfo
sp_MShelpmergearticles
sp_MShelpmergearticles
sp_MShelpmergearticles
sp_MSrestore_sub_tran
sp_MSfixupaltsnapshotfolder
sp_MShelpmergeschemaarticles
sp_MSrestore_sub
sp_MSfixupworkingdirectory
sp_MScreateretry
sp_MSfixupuseftp
sp_MSdropretry
sp_MSprepare_sub_for_detach
sp_MSfixupagentoffloadinfo
sp_MSdroptemptable
sp_MSgetversion
sp_MSsub_check_identity
sp_MSfixupsharedagentproperties
sp_MSfixupsharedagentproperties
sp_MSchangearticleresolver
sp_MSpost_auto_proc
sp_MSsub_cleanup_orphans
sp_MSenumretries
sp_MSrepl_schema
sp_MSrepl_schema
sp_MSsub_cleanup_prop_table
sp_MSdeleteretry
sp_MSreplupdateschema
sp_MSreseed
sp_MSreseed
sp_MSaddlogin_implicit_ntlogin
sp_MSdeletepushagent
sp_MSdefer_check
sp_MSsub_set_identity
sp_MSget_pullsubsagent_owner
sp_MSgetonerow
sp_MSreenable_check
sp_MSinstance_qv
sp_MSuplineageversion
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSdrop_repltran
sp_MSget_shared_agent
sp_MSgetlastrecgen
sp_MS_marksystemobject
sp_MSprep_exclusive
sp_MSdrop_pub_tables
sp_MSrepl_backup_start
sp_MStable_has_unique_index
sp_MSgetlastsentgen
sp_MSarticlecolstatus
sp_MSrepl_backup_complete
sp_MSchange_retention
sp_MSgetlastsentrecgens
sp_MSarticlecol
sp_MSadd_compensating_cmd
sp_MSadd_compensating_cmd
sp_MSchange_priority
sp_MSdummyupdate
sp_MSdummyupdate
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MScreate_pub_tables
sp_MSsetlastrecgen
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSobjectprivs
sp_MSsetfilterparent
sp_MSsetlastsentgen
sp_MSdoesfilterhaveparent
sp_MSenumgenerations
sp_MSsetfilteredstatus
sp_MSget_setup_paths
sp_MScheckexistsgeneration
sp_MSdrop_rlcore
sp_MSdrop_rlcore
sp_MSretrieve_publication
sp_MSremoveoffloadparameter
sp_MSadduser_implicit_ntlogin
sp_MSchecksnapshotstatus
sp_MSguidtostr
sp_MSget_current_activity
sp_MSreplsup_table_has_pk
sp_MSaddoffloadparameter
sp_MScheck_uid_owns_anything
sp_MSget_mergepullsubsagent_owner
sp_MSenumreplicas
sp_MSgetconflicttablename
sp_MSset_current_activity
sp_MSset_current_activity
sp_MSenumdeletesmetadata
sp_MSuniqueobjectname
sp_MSobjsearch
sp_MSobjsearch
sp_MSobjsearch
sp_MSobjsearch
sp_MSUpgradeConflictTable
sp_MSUpgradeConflictTable
sp_MSreplraiserror
sp_MSenumpartialdeletes
sp_MSSetServerProperties
sp_MSuniquetempname
sp_MShasdbaccess
sp_MSsendtosqlqueue
sp_MSenumchanges
sp_MSsetalertinfo
sp_MSuniquecolname
sp_MSenumpartialchanges
sp_MSaddguidcolumn
sp_MShelpcolumns
sp_MShelpcolumns
sp_MShelpcolumns
sp_MShelpcolumns
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSestimatemergesnapshotworkload
sp_MSpad_command
sp_MSinitdynamicsubscriber
sp_MSprepare_mergearticle
sp_MShelpindex
sp_MShelpindex
sp_MShelpindex
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSestimatesnapshotworkload
sp_MSflush_command
sp_MSgetrowmetadata
sp_MSgetcolumnlist
sp_MShelptype
sp_MShelptype
sp_MSis_col_replicated
sp_MSis_col_replicated
sp_MSget_colinfo
sp_MSgetmetadatabatch
sp_MSaddguidindex
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdependencies
sp_MSdropfkreferencingarticle
sp_MSget_col_position
sp_MSsetrowmetadata
sp_MSrefcnt
sp_MStablespace
sp_MSget_map_position
sp_MSinsertgenhistory
sp_MSgentablenickname
sp_MSindexspace
sp_MSmergeupdatelastsyncinfo
sp_MSget_type
sp_MSupdategenhistory
sp_MStablenickname
sp_MStablerefs
sp_MStablerefs
sp_MStablerefs
sp_MSrepl_FixPALRole
sp_MSrepl_FixPALRole
sp_MSscript_where_clause
sp_MSscript_where_clause
sp_MSscript_where_clause
sp_MSlocalizeinterruptedgenerations
sp_MStablenamefromnick
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MStablekeys
sp_MSscript_params
sp_MSenumschemachange
sp_MSgetmakegenerationapplock
sp_MStablechecks
sp_MSscript_article_view
sp_MSsetcontext_replagent
sp_MSscript_procbodystart
sp_MSenumschemachange_70
sp_MSreleasemakegenerationapplock
sp_MSsettopology
sp_MSscript_begintrig1
sp_MSscript_begintrig1
sp_MSenumschemachange_80
sp_MSenumschemachange_80
sp_MSenumschemachange_80
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmakegeneration
sp_MSmatchkey
sp_MSaddexecarticle
sp_MSaddexecarticle
sp_MSaddexecarticle
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSdrop_replcom
sp_MSscript_begintrig2
sp_MSscript_begintrig2
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSenumschemachange_80sp3
sp_MSfixlineageversions
sp_MSfixlineageversions
sp_MSforeach_worker
sp_MSforeach_worker
sp_MSaddschemaarticle
sp_MSaddschemaarticle
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MScreate_distributor_tables
sp_MSscript_endtrig
sp_MSupdateschemachange
sp_MSaddupdatetrigger
sp_MSaddupdatetrigger
sp_MSaddupdatetrigger
sp_MSforeachdb
sp_MSscript_trigger_variables
sp_MSscript_trigger_variables
sp_MSremove_mergereplcommand
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSaddmergetriggers
sp_MSforeachtable
sp_MSgettranconflictname
sp_MSIfExistsRemoteLogin
sp_MSscript_trigger_assignment
sp_MSadd_mergereplcommand
sp_MSadd_mergereplcommand
sp_MSchangeobjectowner
sp_MSloginmappings
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSmaketrancftproc
sp_MSscript_trigger_fetch_statement
sp_MSsetreplicainfo
sp_MShelpdestowner
sp_MScleanuptask
sp_MSuniquename
sp_MSreplrole
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSscript_trigger_exec_rpc
sp_MSsetreplicastatus
sp_MSfillupmissingcols
sp_MSkilldb
sp_MSscript_trigger_update_checks
sp_MScreateglobalreplica
sp_MScreateglobalreplica
sp_MSmaptype
sp_MSchangeschemaarticle
sp_MSchangeschemaarticle
sp_MShelpobjectpublications
sp_MSscript_trigger_updates
sp_MSsetconflictscript
sp_MSquerysubtype
sp_MSSQLDMO80_version
sp_MSscript_trigger_version_updates
sp_MSsetconflicttable
sp_MSSQLDMO70_version
sp_MSscript_singlerow_trigger
sp_MSmakeconflictinsertproc
sp_MSmakeconflictinsertproc
sp_MSmakeconflictinsertproc
sp_MSsethighestversion
sp_MSSQLOLE65_version
sp_MSscript_multirow_trigger
sp_MSmaketempinsertproc
sp_MSSQLOLE_version
sp_MSscript_sync_ins_trig
sp_MSgetconflictinsertproc
sp_MSgetconflictinsertproc
sp_MSpurgecontentsorphans
sp_MSscriptdatabase
sp_MSscript_sync_upd_trig
sp_MSinsertdeleteconflict
sp_MScleanup_zeroartnick_genhistory
sp_MSscriptdb_worker
sp_MSscript_sync_del_trig
sp_MScheckmetadatamatch
sp_MSdelete_specifiedcontents
sp_MSdbuseraccess
sp_MSdbuseraccess
sp_MSdbuseraccess
sp_MSget_synctran_column
sp_MSdelrow
sp_MSdelrow
sp_MSispulldistributionjobnamegenerated
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdrop_rladmin
sp_MSdbuserpriv
sp_MSdbuserpriv
sp_MSpublishdb
sp_MSsetartprocs
sp_MSsetartprocs
sp_MSispullmergejobnamegenerated
sp_MSaddmergepub_snapshot
sp_MSaddmergepub_snapshot
sp_MShelpfulltextindex
sp_MSactivate_auto_sub
sp_MSmakesystableviews
sp_MSmakesystableviews
sp_MSdropmergepub_snapshot
sp_MShelpfulltextscript
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSget_synctran_commands
sp_MSgetchangecount
sp_MScheckatpublisher
sp_MSbelongs
sp_MSbelongs
sp_MSaddmergeschemaarticle
sp_MSaddmergeschemaarticle
sp_MSGetServerProperties
sp_MSaddpub_snapshot
sp_MSaddpub_snapshot
sp_MSexpandbelongs
sp_MSis_pk_col
sp_MScheck_agent_instance
sp_MSexpandnotbelongs
sp_MSchangemergeschemaarticle
sp_MSchangemergeschemaarticle
sp_MSSharedFixedDisk
sp_MSmark_proc_norepl
sp_MSBumpupCompLevel
sp_MSsetupbelongs_withoutviewproc
sp_MSfilterclause
sp_MSdrop_expired_subscription
sp_MSdrop_expired_subscription
sp_MSCleanupForPullReinit
sp_MSsetupnotbelongs
sp_MSadjustmergeidentity
sp_MSadjustmergeidentity
sp_MSgetalertinfo
sp_MSscript_validate_subscription
sp_MSpublicationcleanup
sp_MSpublicationcleanup
sp_MSsetupworktables
sp_MSsetupworktables
sp_MSsetupworktables
sp_MSvalidate_subscription
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MScreate_dist_tables
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSsetupbelongs
sp_MSdroparticleconstraints
sp_MSscript_insert_statement
sp_MSscript_insert_statement
sp_MSupdate_mqserver_distdb
sp_MSarticlecleanup
sp_MSarticlecleanup
sp_MSaddinitialarticle
sp_MSaddinitialarticle
sp_MSacquireserverresourcefordynamicsnapshot
sp_MSadd_distributor_alerts_and_responses
sp_MSadd_distributor_alerts_and_responses
sp_MSdroparticleprocs
sp_MSaddinitialschemaarticle
sp_MSscript_insert_subwins
sp_MSdrop_distributor_alerts_and_responses
sp_MSdrop_distributor_alerts_and_responses
sp_MSdroparticletriggers
sp_MSaddinitialpublication
sp_MSaddinitialpublication
sp_MSis_identity_insert
sp_MSaddinitialsubscription
sp_MSaddinitialsubscription
sp_MSscript_compensating_send
sp_MSmakearticleprocs
sp_MSgettranlastupdatedtime
sp_MSscriptinsertconflictfinder
sp_MSscriptinsertconflictfinder
sp_MSupdatesysmergearticles
sp_MSgetmergelastupdatedtime
sp_MSscript_insert_pubwins
sp_MSscript_insert_pubwins
sp_MSrepl_addrolemember
sp_MSexclause
sp_MSgetlastupdatedtime
sp_MSscript_update_statement
sp_MSscript_update_statement
sp_MSrepl_droprolemember
sp_MSgetcolordinalfromcolname
sp_MSreinitmergepublication
sp_MSinsertbeforeimageclause
sp_MSreinit_hub
sp_MSscript_update_subwins
sp_MScreatedupkeyupdatequery
sp_MScreatedupkeyupdatequery
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSscriptupdateconflictfinder
sp_MSmakeinsertproc
sp_MSmakeinsertproc
sp_MSmakeinsertproc
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSpublicationview
sp_MSscript_update_pubwins
sp_MSscript_update_pubwins
sp_MSscript_update_pubwins
sp_MSremovedbreplication
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSmakeupdateproc
sp_MSscript_delete_statement
sp_MSmakeselectproc
sp_MSmakeselectproc
sp_MSretrieve_mergepublication
sp_MSscript_delete_subwins
sp_MScopyregvalue
sp_MSdropconstraints
sp_MSscriptdelconflictfinder
sp_MSinsertschemachange
sp_MSreplcheckoffloadserver
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSscript_compensating_insert
sp_MSgetviewcolumnlist
sp_MSscript_delete_pubwins
sp_MSvalidatearticle
sp_MSget_file_existence
sp_MShelpvalidationdate
sp_MSscript_beginproc
sp_MSsubscriptionvalidated
sp_MSrepl_isdbowner
sp_MSmergepublishdb
sp_MSscript_security
sp_MSdroparticletombstones
sp_MSscript_endproc
sp_MSproxiedmetadata
sp_MSget_qualified_name
sp_MStable_not_modifiable
sp_MSupdate_agenttype_default
sp_MScontractsubsnb
sp_MSdrop_object
sp_MSscript_ExecutionMode_stmt
sp_MSexpandsubsnb
sp_MSscript_sync_ins_proc
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSvalidate_agent_parameter
sp_MSdelsubrows
sp_MSdelsubrows
sp_MSscript_sync_upd_proc
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSdelsubrowsbatch
sp_MSsubst_filter_name
sp_MSscript_dri
sp_MSscript_sync_del_proc
sp_MSscriptviewproc
sp_MSscriptviewproc
sp_MSsubst_filter_names
sp_MSenumpubreferences
sp_MSscript_pub_upd_trig
sp_MSmakeviewproc
sp_MSreplcheck_name
sp_MSsubsetpublication
sp_MSmakeconflicttable
sp_MSmakeconflicttable
sp_MSmakeconflicttable
sp_MSget_publisher_rpc
sp_MScreatebeforetable
sp_MScheckvalidsystables
sp_MSindexcolfrombin
sp_MShelp_distdb
sp_MShelpcreatebeforetable
sp_MShelpcreatebeforetable
sp_MSdrop_mergesystables
sp_MSmakejoinfilter
sp_MSgen_sync_tran_procs
sp_MSgen_sync_tran_procs
sp_MSupdate_replication_status
sp_MSupdate_replication_status
sp_MSreset_queue
sp_MShelpalterbeforetable
sp_MShelpalterbeforetable
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MScreate_mergesystables
sp_MSmakeexpandproc
sp_MSmakeexpandproc
sp_MSmakeexpandproc
sp_MSenum_misc_agents
sp_MSreset_queued_reinit
sp_MSgetbeforetableinsert
sp_MStestbit
sp_MSdrop_expired_mergesubscription
sp_MSdrop_expired_mergesubscription
sp_MSload_replication_status
sp_MSinit_subscription_agent
sp_MSfixupbeforeimagetables
sp_MSsetbit
sp_MScleanup_metadata
sp_MScleanup_metadata
sp_msupg_removesystemcomputedcolumns
sp_MSareallcolumnscomputed
sp_MScreate_replication_status_table
sp_MSupdatelastsyncinfo
sp_MSreplcheck_permission
sp_MSinsertcontents
sp_MSgettypestringudt
sp_MShelp_replication_status
sp_MShelp_replication_status
sp_MSget_attach_state
sp_MSinserterrorlineage
sp_MSupdatecontents
sp_MSquiescecheck
sp_MSenum_replication_agents
sp_MSenum_replication_agents
sp_MSenum_replication_agents
sp_MSreset_attach_state
sp_MSevalsubscriberinfo
sp_MSdeletecontents
sp_MSset_subscription_properties
sp_MSsetsubscriberinfo
sp_MSunmarkifneeded
sp_MSpreparecleanup
sp_MSscript_missing_row_check
sp_MScreate_replication_checkup_agent
sp_MSset_sub_guid
sp_MSgetsubscriberinfo
sp_MSunmarkreplinfo
sp_MSquiescetriggerson
sp_msupg_recreatecatalogfaketables
sp_MSenum_replication_job
sp_MSmakectsview
sp_MSmakectsview
sp_MSmakectsview
sp_MSmarkreplinfo
sp_MSquiescetriggersoff
sp_msupg_dosystabcatalogupgrades
sp_msupg_dosystabcatalogupgrades
sp_msupg_dosystabcatalogupgrades
sp_MSrepl_dbrole
sp_MScreate_sub_tables
sp_MScreate_sub_tables
sp_MScreate_sub_tables
sp_MSinsertgenerationschemachanges
sp_MSinsertgenerationschemachanges
sp_MSunmarkschemaobject
sp_MSquiesceforcleanup
sp_msupg_dropcatalogcomputedcols
sp_MSupdate_mqserver_subdb
sp_MSalreadyhavegeneration
sp_MSmarkschemaobject
sp_msupg_createcatalogcomputedcols
sp_msupg_createcatalogcomputedcols
sp_msupg_createcatalogcomputedcols
sp_MS_replication_installed
sp_MSgettablecontents
sp_MSaddanonymousreplica
sp_MScompletecleanup
sp_MScompletecleanup
sp_msupg_recreatesystemviews
sp_MSget_oledbinfo
sp_MSunc_to_drive
sp_MSdelgenzero
sp_MSgetreplicainfo
sp_MSpropagateschematorepubs
sp_msupg_upgradecatalog
sp_MSretrieve_publication_attributes
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSmakedynsnapshotvws
sp_MSadd_repl_job
sp_MSadd_repl_job
sp_MSadd_repl_job
sp_MScleanup_publication_ADinfo
sp_MSdropdynsnapshotvws
sp_MScheck_subscription
sp_MScleanup_conflict_table
sp_MSrepl_linkedservers_rowset

Meta Reunion

It was sunday the 27th of June 2004 late evening and i thought of cleaning my office filing cabinet, when i found a sheet of white paper which was no more white ;). This sheet has brought some significant change in life and made me feel more stronger and confident. This sheet had the names, phone nos and email'ds of all my team from good old days of Meta Infotech . I sent a mail to all of them in the hope that these id's still work as its been almost 2 years now and to my surprise most of the id's did work and i got warm replies too :).

I would love to do this with my associations with other organizations too viz.: Genesys & Mediline, oneway it helps get a feedback of oneself on how you treated your team and vice-versa.

Well there is a community created on Orkut called Meta Alumni. If you have not received my invitation, do ping me.

Break through firewall

Bypass firewalls to chat with your friends and download files. Works with Kazaa, iMesh, Messenger, ICQ and any other application that supports the SOCKS protocol.

No configuration hassles, no techie-talk or geek-speak. Not only does hopster configure itself, it even knows how to configure Kazaa, MSN Messenger and many others - so you don't need to.
Once installed, hopster operates silently in the background, you won't even notice it's there.

Hopster was designed with the most popular applications in mind: MSN Messenger, ICQ, Yahoo Messenger, Trillian... no matter where your friends are, hopster gets you there. And so are they adding more apps every day.

Hopster also protects you from the nosy Bad Guys on the 'net.

It hides your actual ip address, making it impossible for hackers to trace you. And their firewalls protect you from unwanted visitors.

Download Now

On downloading the demo version, if you get annonyed with the ad bar right click on the title bar and click minimize, this will hide the ad bar for ever and you don't need to buy it unless you need more than 4kb/sec data.

Visio to anything

Problem statement:

Couple of weeks back i got myself actively involved with the design team and realized that most of the time was spent in getting the class diagrams from Visio (modelling tool) and stored procedures documented as per the custom design document template.

Technologies

• Visio,
• .NET Office Extensibility Add-in,
• MS Word,
• VBA,
• XMI,
• XSL,
• CSS

Approach:

Visio does provide a reporting add-in but unfortunately it is neither readable nor is it customizable and so started the thought to work on an alternative.

Microsoft always has a means to automate/customize/extend their products and so do they have UML to XMI Export Functionality, meaning a Visio UML Model can be exported to XML Metadata Interchange (XMI) format. This is build using .NET Office extensibility Add-in.

Now the XMI that is generated by Visio uses UML.dtd, which unfortunately is not distributed by Microsoft but have provided the resource in the readme.txt. With XMI & DTD in place i am sure of a valid Visio XMI file.

The next step was to display the XMI data in a custom format and the best alternative was to use eXtensible Stylesheet Language (XSL), now I needed to understand the structure of Visio XMI file and this is a tough job because there is no documentation available whatsoever to understand how visio model is interpretted in XMI format.

Attached a CSS to XSL to apply the formatting styles including header styles.

The next step was to place this information at an appropriate postion with in the design document template, hence created a .dot file, which is a template file for word.

Created a macro in word VBA that will use MSXML 2.0/4.0 and dynamically translate XMI with XSL and insert it into appropriate position.

Rebuild the table of contents, which will now include the design headings as defined by the CSS.

Please do drop me a comment if you need the UML to XMI add-in/DTD/XSL/CSS/DOT.

Custom Datagrid

This datagrid custom webcontrol will provide out of the box functionalities for the following features:

• CAT Stylesheet for HeadingItemStyle, EditItemStyle, SelectedItemStyle
• Inline of Page Redirect on Edit
• Captions for Edit, Update, Cancel & Delete buttons can be either text or graphic
• On double click of any row, editcommand, pageredirect of the row will be performed
• On single click of any row, selectcommand will be performed on the client end, thus saving the roundtrip to server.
• Sorting of the columns ASC/DESC on corresponding clicks on the column header with glmph
• Paging of the datagrid
• Maintaining State Across Pages For Checked Records
• Complement Inline Edit & Delete Support
• Fully Editable Support
• Maintains Concurrency Checks For InlineEdit Records
• Makes A Particular Row or Column ReadOnly

Code Copy HideScrollFull

/// <summary>
/// File Name: EMSDataGrid.cs
/// Description:
///<Author> Amith Ellur & Yasin Mukadam</Author>
///<Date> 11-Feb-2004</Date>
///<Description>This datagrid custom webcontrol will provide out of the box functionalities for the following:
///1.   CAT Stylesheet for HeadingItemStyle, EditItemStyle, SelectedItemStyle
///2.   Inline of Page Redirect on Edita
///3.   Captions for Edit, Update, Cancel & Delete buttons can be either text or graphic
///4.   On double click of any row, editcommand, pageredirect of the row will be performed
///5.   On single click of any row, selectcommand will be performed on the client end,
///thus saving the roundtrip to server.
///6.  Sorting of the columns ASC/DESC on corresponding clicks on the column header
///7.  Paging of the datagrid
///8.  Maintaining State Across Pages For Checked Records
///9.  Complement Inline Edit & Delete Support
///10. Fully Editable Support
///11. Maintains Concurrency Checks For InlineEdit Records
///12. Makes A Particular Row or Column ReadOnly
///</Description>
/// </summary>

using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Collections;
using System.Text;
using System.IO;
using Caterpillar.Ems;
using System.Text.RegularExpressions;
using System.Web.Handlers;
using System.Globalization;
using System.Web;

namespace Caterpillar.Ems.Controls
{

/// <summary>
/// Summary description for EMSDataGrid.
/// </summary>
[DefaultProperty("Text"),
ToolboxData("<{0}:EMSDataGrid runat=server></{0}:EMSDataGrid>")]
public class EMSDataGrid : System.Web.UI.WebControls.DataGrid
{

#region Constant
/// <summary>
///  Used To Set The Default Validator Control Style Sheet
/// </summary>
const string VALIDATORSTYLESHEET = "RequiredFieldValidator"
/// <summary>
/// Used To Set The Default Range Validator Control Error Message
/// </summary>
const string RANGEERRORMESSAGE = "<BR><BLINK>||Invalid Data||</BLINK>"
/// <summary>
/// Used To Set The Default Required Validator Control Error Message
/// </summary>
const string REQUIREDERRORMESSAGE = "<BR><BLINK>||Required||</BLINK>"
/// <summary>
/// Used To Set The Default Regular Validator Control Error Message
/// </summary>
const string REGULARERRORMESSAGE = "<BR><BLINK>||Invalid Format||</BLINK>"
/// <summary>
/// Used To Set The Default Custom Validator Control Error Message
/// </summary>
const string CUSTOMERRORMESSAGE = "<BR><BLINK>||Custom Validation Failed||</BLINK>"
/// <summary>
///  Used To Set The Default DropDown Text
/// </summary>
const string DROPDOWNDEFAULTTEXT = "||-SELECT-||"
/// <summary>
/// Used To Set The DropDownStyle Attribute
/// </summary>
const string DROPDOWNSTYLE = "DropDownStyle"
/// <summary>
/// Name Of The Hidden CheckboxState Control
/// </summary>
const string HIDDENCHECKSTATE = "hiddencheckstate"
/// <summary>
/// Name Of The Hidden Control For Storing The NoOfRecordsChecked
/// </summary>
const string HIDDENNORECORDSCHECKBOXSTATE = "hiddennoofrecordscheckboxstate"
/// <summary>
/// Name Of The Hidden Control For Storing The Total Number Of Records
/// </summary>
const string HIDDENCHECKBOXSTATECOUNT = "hiddencheckboxstatecount"
/// <summary>
/// Name Of The hidden Control To Store CheckBox State
/// </summary>
const string HIDDENCONCURRENCYSTATE = "hiddenconcurrencystate"
/// <summary>
/// Name Of The HiddenControlWhich Stores The PreviousPage
/// </summary>
const string HIDDENPREVIOUSPAGE = "hiddenpreviouspage"
/// <summary>
/// Name Of The ReadOnly TextBoxStyle
/// </summary>
const string READONLYTEXTBOXSTYLE = "ReadOnlyTextBoxStyle"
/// <summary>
/// Name Of The TextBoxStyle
/// </summary>
const string TEXTBOXSTYLE = "TextBoxStyle"
/// <summary>
/// Name Of The hidden Control Used For Validating The Selected Record Id
/// </summary>
const string HIDDENCONCURRENCYIDCONCTROL = "hiddenconcurrencyidcontrol"
#endregion
#region Member Variables
/// <summary>
/// Defined enumerations for the different types of edit, delete, caption and stylesheet use
/// </summary>
public enum EditType { UnAuthorized = 0, InLine = 1, PageRedirect = 2 };
/// <summary>
/// Defined enumeration for the different type of delete message
/// </summary>
public enum DeleteType { DeleteWithConfirmation = 0, DeleteWithOutConfirmation = 1 };
/// <summary>
/// Defined enumeration for the different type of caption Type
/// </summary>
public enum CaptionType { Text = 0, Graphics = 1 };
/// <summary>
/// Used To Specify The Default Style Sheet
/// </summary>
public enum StyleSheetType { None = 0, CAT = 1, Default = 2 };
/// <summary>
/// Used To Specify The Status Of The Edit Button
/// </summary>
private bool editVisible;
/// <summary>
/// Used To Specify The Status Of The Delete Button
/// </summary>
private DeleteType allowDelete;
/// <summary>
/// Used To Specify The Status Of The Delete Button
/// </summary>
private bool deleteVisible;
/// <summary>
/// Used To Specify The Control Caption
/// </summary>
private CaptionType controlCaption;
/// <summary>
/// Used To Specifiy The Style Sheet Type
/// </summary>
private StyleSheetType styleSheet;
/// <summary>
/// Used To Specify The Status Of Edit On Double Click
/// </summary>
private bool editOnDoubleClick;
/// <summary>
/// Used To Specify The Status Of The Edit On single Click
/// </summary>
private bool selectOnSingleClick;
/// <summary>
/// Used To Specify The Id Of The Currently Selected Record On The Client Side
/// </summary>
private string keyHiddenControlId;
/// <summary>
/// Used To Specify The Status Of Fully Editable Grid
/// </summary>
private bool blnFullEdidtable;
/// <summary>
/// Used To Specify The Status Of The Inline Edit Enhance Features
/// </summary>
private bool blnEnhanceEdit;
/// <summary>
/// Stores The DataMembers Extended Properties For Each DataColumn
/// </summary>
private System.Data.PropertyCollection PropertyCollection;
/// <summary>
/// Stores The Max Decimal Value
/// </summary>
private string DecimalMaxValue = System.Configuration.ConfigurationSettings.AppSettings["DecimalMaxValue"];
/// <summary>
/// Stores The Min Decimal Value
/// </summary>
private string DecimalMinValue = System.Configuration.ConfigurationSettings.AppSettings["DecimalMinValue"];
/// <summary>
/// DataTable Which Contains The Modified Data Of The DataGrid After An Post Back From Inline Edit Or Fully Editable grid
/// </summary>
private DataTable dtModifiedDataTable = new DataTable();
/// <summary>
/// Maintains The Status Of The CheckBox State
/// </summary>
private bool blnCheckBoxState;
/// <summary>
/// Column Number From The DataMember On Which To Maintain The CheckBox State
/// </summary>
private int intCheckBoxColumn;
/// <summary>
/// Hidden Control Name Of The CheckBoxState Property
/// </summary>
private string strHiddenCheckBoxState;
/// <summary>
/// Hidden Control Name Of The CheckBoxState Property
/// </summary>
private string strNoOfRecordsCheckBoxState;
/// <summary>
/// Hidden Control Name Of The CheckBoxState Property
/// </summary>
private string strCheckBoxStateCount;
/// <summary>
/// Hidden Control Name Of The Previously Selected Page
/// </summary>
private string strHiddenPreviousPage;
/// <summary>
/// Number Of Records Selected For The Current Page
/// </summary>
private int intNoOfRecordsCheckBoxState = 0;
/// <summary>
/// DataSet Which Contains The CheckBox Ids For All The Pages
/// </summary>
private DataSet dsCheckBoxState;
/// <summary>
/// Stores The Name Of The Hidden Control Of Header Column
/// </summary>
private string strHeaderCheckBoxId = string.Empty;
/// <summary>
/// Hidden Control Which Stores The Id Of The Currently Selected Row On The Client Side
/// </summary>
private HtmlInputHidden hidConcurrencyIdControl = new HtmlInputHidden();
/// <summary>
/// Hidden Control Which Stores The Id Of The Currently Selected Row On The Client Side
/// </summary>
private string strConcurrencyIdControl;
/// <summary>
///
/// </summary>
private bool blnClearGridStatus = false;
#endregion
#region Events
/// <summary>
/// define the events for EMS DataGrid. This will be listed under EMS Events
/// </summary>
[Category("EMS Events"), Description("Fires when edit is clicked.")]
public event DataGridCommandEventHandler EditPage;
/// <summary>
///
/// </summary>
public event EMSExceptionEventHandler EMSDataGridRaiseException;
#endregion
#region Properties
/// <summary>
/// Attribute of the control to contain AllowEdit.
/// This will say if we need to provide edit functionality
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if edit option is to be made available.")]
public EditType AllowEdit
{

get
{

if (!object.Equals(ViewState["allowEdit"], null))
{

return (EditType)ViewState["allowEdit"];

}
else
{

return EditType.InLine;

}

}
set
{

if (!object.Equals(value, null))
{

ViewState["allowEdit"] = value;

}

}

}
/// <summary>
/// Attribute of the control to contain KeyHiddenControlId.
/// This will contain the id of the field to which the datagrid is associated for different functions
/// This will be the id of the associated control
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify the field in which the primary key value has to be displayed.")]
public string KeyHiddenControlId
{

get
{

return keyHiddenControlId;

}
set
{

keyHiddenControlId = value;

}

}
/// <summary>
/// Attribute of the control to contain AllowDelete.
/// This will say if we need to provide delete functionality
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if delete option is to be made available.")]
public DeleteType AllowDelete
{

get
{

return allowDelete;

}
set
{

allowDelete = value;

}

}
/// <summary>
/// Attribute of the control to contain controlCaption.
/// This will say what kind of caption is used
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify the caption style for the edit and delete columns.")]
public CaptionType ControlCaption
{

get
{

return controlCaption;

}
set
{

controlCaption = value;

}

}
/// <summary>
/// Attribute of the control to contain StyleSheet.
/// This will say what kind of StyleSheet is used
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify the style sheet to be used to render the rows.")]
public StyleSheetType StyleSheet
{

get
{

return styleSheet;

}
set
{

styleSheet = value;

}

}
/// <summary>
/// Attribute of the control to contain EditOnDoubleClick.
/// This will say if we need to provide edit functionality on row double click as well
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if edit to be made available on double clicking the row.")]
public bool EditOnDoubleClick
{

get
{

return editOnDoubleClick;

}
set
{

editOnDoubleClick = value;

}

}
/// <summary>
/// Attribute of the control to contain SelectOnSingleClick.
/// This will say if we need to provide select functionality on row single click as well
/// </summary>
[Category("EMS Properties"),
DefaultValue(""), Description("Specify if the row has to be selected on single click.")]
public bool SelectOnSingleClick
{

get
{

return selectOnSingleClick;

}
set
{

selectOnSingleClick = value;

}

}
/// <summary>
/// Attribute of the control to contain EditVisible.
/// This will say if edit link on the grid will be displayed or not
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if the edit column is to be displayed.")]
public bool EditVisible
{

get
{

return editVisible;

}
set
{

editVisible = value;

}

}
/// <summary>
/// Attribute of the control to contain EditVisible.
/// This will say if delete link on the grid will be displayed or not
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if the delete column is to be displayed.")]
public bool DeleteVisible
{

get
{

return deleteVisible;

}
set
{

deleteVisible = value;

}

}
/// <summary>
/// Specify if the Grid Will Be Fully Editable
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if the Grid Will Be Fully Editable.")]
public bool FullEditable
{

get
{

return this.blnFullEdidtable;

}
set
{

this.blnFullEdidtable = value;

}

}
/// <summary>
/// Specify if the Grid Will Be Contain Enhance Features For Enline Edit.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specify if the Grid Will Be Contain Enhance Features For Enline Edit.")]
public bool EnhanceEdit
{

get
{

return this.blnEnhanceEdit;

}
set
{

this.blnEnhanceEdit = value;

}

}
/// <summary>
/// Returns The Updated DataSet Of The Grid i.e. When The Update Event Is Fired.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Returns The Updated DataSet Of The Grid i.e. When The Update Event Is Fired.")]
public DataSet ModifiedDataSet
{

get
{

if (object.Equals(this.DataSource, null) || object.Equals(((DataView)this.DataSource).Table, null))
{

throw new ArgumentNullException("ModifiedDataTable", "This Property Should Be Used To Access The Updated Values From The DataSource");

}

this.dtModifiedDataTable.TableName = ((DataView)this.DataSource).Table.TableName;

//((DataView)this.DataSource).DataSetName

DataSet ds = new DataSet();

ds.Tables.Add(this.dtModifiedDataTable);

this.EditItemIndex = -1;

return ds;

}

}
/// <summary>
/// Speficies If The CheckBox State Is Going To Be Maintained Accross Pages.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Speficies If The CheckBox State Is Going To Be Maintained Accross Pages.")]
public bool CheckBoxState
{

get
{

return blnCheckBoxState;

}
set
{

blnCheckBoxState = value;

}

}
/// <summary>
/// Column Number Of The DataSource Of Which To Maintain State.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Column Number Of The DataSource Of Which To Maintain State.")]
public int CheckBoxColumn
{

get
{

return this.intCheckBoxColumn;

}
set
{

this.intCheckBoxColumn = value;

}

}
/// <summary>
/// Returns The DataSet For Checked Columns Accross Pages.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Returns The DataSet For Checked Columns Accross Pages.")]
public DataSet ReadCheckBoxStateData
{

get
{

//Validating If The CheckBoxState Member Variable Is Set
if (this.blnCheckBoxState)
{

//Reading Data From The Hidden Control Into The DataSet
this.WriteHiddenControl();
//Validating If The DataSet Exists
if (!object.Equals(this.dsCheckBoxState, null))
{

//Validating If The DataSet Has Any Tables
if (!object.Equals(this.dsCheckBoxState.Tables[this.DataMember.ToString()], null))
{

//Validating If The Fetched Table Has Any Rows
if (this.dsCheckBoxState.Tables[this.DataMember.ToString()].Rows.Count == 0)
{

this.ProcessException(new Exception("||No Records Exists In The State Bag||"));
return null;

}
else
{

//calling the helper function to remove data from the viewstate
//this.ClearCheckBoxState();
//Returning The Newly Populated DataSet
return this.dsCheckBoxState;

}

}
else
{

this.ProcessException(new ArgumentNullException(this.DataMember.ToString(), "||ReadCheckBoxStateData Method Fetched A DataSet With No Tables||"));
return null;

}

}
else
{

this.ProcessException(new ArgumentNullException(this.dsCheckBoxState.ToString(), "||ReadCheckBoxStateData Method Fetched An Empty DataSet||"));
return null;

}

}
else
{

this.ProcessException(new Exception("||Not Authorized To Access This Property If CheckBoxState Property Is Not Set To True||"));
return null;

}

}

}
/// <summary>
/// Returns The Hidden Control Id Which Contain The No Of Records Checked For Current Page.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Returns The Hidden Control Id Which Contain The No Of Records Checked For Current Page.")]
public string NoOfRecordsCheckBoxState
{

get
{

return this.strNoOfRecordsCheckBoxState;

}

}
/// <summary>
/// Returns The Hidden Control Id Which Contain The No Of Records Checked For All The Pages.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Returns The Hidden Control Id Which Contain The No Of Records Checked For All The Pages.")]
public string CheckBoxStateCount
{

get
{

return this.strCheckBoxStateCount;

}

}
/// <summary>
/// Returns The Hidden Control Id Which Contain The checkBox State.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Returns The Hidden Control Id Which Contain The checkBox State.")]
public string HiddenCheckBoxState
{

get
{

return this.strHiddenCheckBoxState;

}

}
/// <summary>
/// Specifies To Clear The DataSet From The ViewState.
/// </summary>
[Category("EMS Properties"), DefaultValue(""), Description("Specifies To Clear The DataSet From The ViewState.")]
public void ClearCheckBoxState()
{

//
if (!object.Equals(this.ViewState[this.strHiddenCheckBoxState], null))
{

this.ViewState.Remove(this.strHiddenCheckBoxState);

}
//
this.blnClearGridStatus = true;

}
#endregion
#region OverReidden Events And Method Of The DataGrid
#region Events That Get Fired Each Time The DataGrid Is Processed
/// <summary>
/// calling the EMS Datagrid Constructor
/// </summary>
public EMSDataGrid()
{

//Default properties for the datagrid
this.ShowHeader = true;
this.AutoGenerateColumns = false;
//this.AllowSorting = true;
this.BorderColor = Color.Black;
this.BorderStyle = BorderStyle.Solid;
// Set the Handlers for the events to be handled in EMS Datagrid
CancelCommand += new DataGridCommandEventHandler(EMSDataGrid_CancelCommand);
EditCommand += new DataGridCommandEventHandler(EMSDataGrid_EditCommand);
UpdateCommand += new DataGridCommandEventHandler(EMSDataGrid_UpdateCommand);
SortCommand += new DataGridSortCommandEventHandler(EMSDataGrid_SortCommand);
DataBinding += new EventHandler(EMSDataGrid_DataBinding);
PageIndexChanged += new DataGridPageChangedEventHandler(EMSDataGrid_PageIndexChanged);

}

/// <summary>
/// Get Fired When The Instance If The Grid Is Fired
/// </summary>
/// <param name="e"></param>
protected override void OnInit(EventArgs e)
{

base.OnInit(e);
this.Columns.Clear();
if (this.AllowPaging || this.AllowCustomPaging)
{

this.PagerStyle.Position = PagerPosition.TopAndBottom;
this.PagerStyle.Mode = PagerMode.NumericPages;
this.PagerStyle.HorizontalAlign = HorizontalAlign.Left;
this.PageSize = int.Parse(System.Configuration.ConfigurationSettings.AppSettings["RowsPerPage"].ToString());

}

if (object.Equals(this.NamingContainer.ClientID, null))
{

this.strConcurrencyIdControl = this.ClientID + ":" + HIDDENCONCURRENCYIDCONCTROL;

}
else
{

this.strConcurrencyIdControl = this.NamingContainer.ClientID + ":" + this.ID + ":" + HIDDENCONCURRENCYIDCONCTROL;

}

//Validating If The CheckBoxState Has To Be Maintained
if (this.blnCheckBoxState)
{

//Setting CheckBoxStateName
if (object.Equals(this.NamingContainer.ClientID, null))
{

this.strHiddenCheckBoxState = this.ClientID + ":" + HIDDENCHECKSTATE;
this.strNoOfRecordsCheckBoxState = this.ClientID + ":" + HIDDENNORECORDSCHECKBOXSTATE;
this.strCheckBoxStateCount = this.ClientID + ":" + HIDDENCHECKBOXSTATECOUNT;
this.strHiddenPreviousPage = this.ClientID + ":" + HIDDENPREVIOUSPAGE;

}
else
{

this.strHiddenCheckBoxState = this.NamingContainer.ClientID + ":" + this.ID + ":" + HIDDENCHECKSTATE;
this.strNoOfRecordsCheckBoxState = this.NamingContainer.ClientID + ":" + this.ID + ":" + HIDDENNORECORDSCHECKBOXSTATE;
this.strCheckBoxStateCount = this.NamingContainer.ClientID + ":" + this.ID + ":" + HIDDENCHECKBOXSTATECOUNT;
this.strHiddenPreviousPage = this.NamingContainer.ClientID + ":" + this.ID + ":" + HIDDENPREVIOUSPAGE;

}

}
//
//if(!object.Equals(HttpContext.Current.Session["DataSource"], null) && !object.Equals(HttpContext.Current.Session["DataMember"], null))
//{
//this.DataSource = HttpContext.Current.Session["DataSource"];
//this.DataMember = HttpContext.Current.Session["DataMember"].ToString();
//this.DataBind();
//}

}
/// <summary>
/// Method to handle the DataBinding event of the EMS Datagrid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EMSDataGrid_DataBinding(object sender, EventArgs e)
{

//
this.Columns.Clear();
//                                    
if (!this.IsTrackingViewState)
{

this.TrackViewState();

}
//if the page is loading for the first time, set the sort order to desc
if (this.ViewState["SortDirection"] == null)
{

this.ViewState["SortDirection"] = " DESC"
this.ViewState["SortExpression"] = string.Empty;

}

//set the datasource
if (this.DataSource != null && this.DataSource is DataSet)
{

//
this.DataSource = ((DataSet)this.DataSource).Tables[this.DataMember.ToString()].DefaultView;
//
if (!(this.CurrentPageIndex <= (((DataView)this.DataSource).Table.Rows.Count / this.PageSize)))
{

this.CurrentPageIndex = 0;

}

}
//else
//{
//            this.CurrentPageIndex = 0;
//}
#region Set the Stylesheet styles
//Set the Stylesheet styles
//CAT
if (this.StyleSheet == StyleSheetType.CAT)
{

this.CssClass = "CATDataGridStyle"
this.HeaderStyle.CssClass = "CATDataGridHeaderStyle"
this.ItemStyle.CssClass = "CATDataGridItemStyle"
this.AlternatingItemStyle.CssClass = "CATDataGridAlternatingStyle"
this.SelectedItemStyle.CssClass = "CATDataGridSelectedItemStyle"
this.FooterStyle.CssClass = "CATDataGridFooterStyle"

}
//Default
else if (this.StyleSheet == StyleSheetType.Default)
{

this.CssClass = "DefaultDataGrid"
this.ItemStyle.CssClass = "DefaultDataGridItemStyle"
this.AlternatingItemStyle.CssClass = "DefaultDataGridAlternatingStyle"
this.HeaderStyle.CssClass = "DefaultDataGridHeaderStyle"
this.SelectedItemStyle.CssClass = "DefaultDataGridSelectedItemStyle"

}
#endregion
#region Adding Edit Item Template Column
//if the edit link is visible and edit on double click is enabled
//add the edit column
if (this.EditVisible || this.EditOnDoubleClick)
{

EditCommandColumn editCommandColumn = new EditCommandColumn();
editCommandColumn.ButtonType = ButtonColumnType.LinkButton;
if (this.ControlCaption == CaptionType.Text)
{

editCommandColumn.EditText = "Edit"
editCommandColumn.UpdateText = "Apply"
editCommandColumn.CancelText = "Cancel"

}
else
{

editCommandColumn.ItemStyle.Font.Size = 11;
editCommandColumn.ItemStyle.Font.Name = "wingdings 2"
editCommandColumn.EditText = "/"
editCommandColumn.UpdateText = "R"
editCommandColumn.CancelText = "T"

}
this.Columns.Add(editCommandColumn);
this.Columns[this.Columns.Count - 1].Visible = this.EditVisible;

}
#endregion
#region Adding Delete Item Template Column
//add the delete column
ButtonColumn deleteColumn = new ButtonColumn();
deleteColumn.CommandName = "delete"
if (this.ControlCaption == CaptionType.Text)
{

deleteColumn.Text = "Delete"

}
else
{

deleteColumn.ItemStyle.Font.Size = 11;
deleteColumn.ItemStyle.Font.Name = "webdings"
deleteColumn.Text = "r"

}
this.Columns.Add(deleteColumn);
this.Columns[this.Columns.Count - 1].Visible = this.DeleteVisible;
#endregion
//if the data source is not null, add the template column to each column
if (this.DataSource != null)
{

this.SetColumnsCollection();
//HttpContext.Current.Session["DataSource"] = this.DataSource;
//HttpContext.Current.Session["DataMember"] = this.DataMember;

}

#region Adding ClientSide Script For SelectOnsingleClick etc...
string scriptString;
#region if the select on single click is true Set the OnClick Event of the grid
//if the select on single click is true Set the OnClick Event of the grid
if (this.SelectOnSingleClick)
{

//write the script for onclick
scriptString = "<Script>"
scriptString += "var " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex;"
scriptString += "var " + this.UniqueID.Replace(":", "_") + "SelectedItemStyle;"
if (this.DataSource != null && ((System.Data.DataView)this.DataSource).Table.Rows.Count > 0)
{

scriptString += this.UniqueID.Replace(":", "_") + "SelectedItemStyle='" + this.ItemStyle.CssClass + "';"
//                            //Code commented due to a bug, the bug still exists
if (this.KeyHiddenControlId != null && ((System.Web.UI.HtmlControls.HtmlInputHidden)this.Page.FindControl(this.KeyHiddenControlId)) != null)
{

if (((System.Web.UI.HtmlControls.HtmlInputHidden)this.Page.FindControl(this.KeyHiddenControlId)).Value.Equals(String.Empty))

((System.Web.UI.HtmlControls.HtmlInputHidden)this.Page.FindControl(this.KeyHiddenControlId)).Value = ((System.Data.DataView)this.DataSource).Table.Rows[0].ItemArray[0].ToString();

}
if (this.AllowPaging && this.PagerStyle.Position == PagerPosition.TopAndBottom)
{

this.Page.RegisterStartupScript(this.UniqueID.Replace(":", "_") + "SelectFirstElement", "<Script> try{" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex=document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[2].id; " + this.UniqueID.Replace(":", "_") + "SelectedItemStyle = document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[2].className; document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[2].className='" + this.SelectedItemStyle.CssClass + "';} catch (e) {} </Script>");

}
else
{

this.Page.RegisterStartupScript(this.UniqueID.Replace(":", "_") + "SelectFirstElement", "<Script> try{" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex=document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[1].id; " + this.UniqueID.Replace(":", "_") + "SelectedItemStyle = document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[1].className; document.getElementById('" + this.UniqueID.Replace(":", "_") + "').rows[1].className='" + this.SelectedItemStyle.CssClass + "';} catch (e) {} </Script>");

}


//this.Page.RegisterStartupScript(this.UniqueID.Replace(":","_") + "ScrolltoElement","<Script> document.getElementById(" + this.UniqueID.Replace(":","_") + "SelectedItemIndex).scrollIntoView(false); </Script>");

}
else

scriptString += this.UniqueID.Replace(":", "_") + "SelectedItemIndex='1';"

scriptString += " function " + this.UniqueID.Replace(":", "_") + "SelectMe()"
scriptString += " {"
scriptString += " try {"
scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != event.srcElement.parentElement.id && event.srcElement.parentElement.id!='')"
scriptString += " {"
//if(this.FullEditable) scriptString += "alert(" + this.UniqueID.Replace(":","_") + "SelectedItemIndex);"
//                      scriptString += "//Set Previously Selected Row to Alternating Style"
scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != '1')"
scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className=" + this.UniqueID.Replace(":", "_") + "SelectedItemStyle;"
//                      scriptString += "//Set Currently Selected Row to Selected Style"
scriptString += " " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex = event.srcElement.parentElement.id;"
if (this.KeyHiddenControlId != null)

scriptString += " document.getElementById('" + this.KeyHiddenControlId + "').value = " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex;"

scriptString += this.UniqueID.Replace(":", "_") + "SelectedItemStyle = event.srcElement.parentElement.className;"
if (this.StyleSheet == StyleSheetType.CAT)

scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className='CATDataGridSelectedItemStyle';"

if (this.StyleSheet == StyleSheetType.Default)

scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className='DefaultDataGridSelectedItemStyle';"

scriptString += "}"

//enhanced for druv to allow checkbox click selection of row
scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != event.srcElement.parentElement.parentElement.id && event.srcElement.parentElement.parentElement.id!='')"
scriptString += " {"
//                      scriptString += "//Set Previously Selected Row to Alternating Style"
scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != '1')"
scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className=" + this.UniqueID.Replace(":", "_") + "SelectedItemStyle;"
//                      scriptString += "//Set Currently Selected Row to Selected Style"
scriptString += " " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex = event.srcElement.parentElement.parentElement.id;"
if (this.KeyHiddenControlId != null)

scriptString += " document.getElementById('" + this.KeyHiddenControlId + "').value = " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex;"

scriptString += this.UniqueID.Replace(":", "_") + "SelectedItemStyle = event.srcElement.parentElement.parentElement.className;"
//                                                                                                                                                
if (this.StyleSheet == StyleSheetType.CAT)

scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className='CATDataGridSelectedItemStyle';"

if (this.StyleSheet == StyleSheetType.Default)

scriptString += " document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).className='DefaultDataGridSelectedItemStyle';"

scriptString += "}"
scriptString += "}"
scriptString += "catch (e) {}"
scriptString += "}"
scriptString += " </Script>"
//register the script
this.Page.RegisterClientScriptBlock(this.UniqueID.Replace(":", "_") + "SelectMe", scriptString);

}
#endregion
#region if the edit on double click is true, Set the doubleClick Event of the grid
//if the edit on double click is true, Set the doubleClick Event of the grid
if (this.EditOnDoubleClick && this.AllowEdit == EditType.UnAuthorized)
{

//Set the OndblClick Event of the grid
scriptString = "<Script>"
scriptString += " function " + this.UniqueID.Replace(":", "_") + "OpenMe()"
scriptString += " {"
scriptString += " }"
scriptString += " </Script>"
this.Page.RegisterClientScriptBlock(this.UniqueID.Replace(":", "_") + "OpenMe", scriptString);

}
if (this.EditOnDoubleClick && this.AllowEdit != EditType.UnAuthorized)
{

//Set the OndblClick Event of the grid
scriptString = "<Script>"
if (!this.SelectOnSingleClick)

scriptString += "var " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex;"

scriptString += " function " + this.UniqueID.Replace(":", "_") + "OpenMe()"
scriptString += " {"
if (!this.SelectOnSingleClick)

scriptString += " " + this.UniqueID.Replace(":", "_") + "SelectedItemIndex = event.srcElement.parentElement.id;"

scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != '1'){"
scriptString += " var callEdit=new Function(document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).onedit);"
scriptString += " callEdit();"
scriptString += " }}"
scriptString += " </Script>"
this.Page.RegisterClientScriptBlock(this.UniqueID.Replace(":", "_") + "OpenMe", scriptString);

}
#endregion
#region Call Delete Event of the Selected Item
//Call Delete Event of the Selected Item
scriptString = "<Script>"
scriptString += " function " + this.UniqueID.Replace(":", "_") + "DeleteMe()"
scriptString += " {"
scriptString += " var status=confirm('" + Resource.Application.DeleteConfirmationMessage + "');"
scriptString += " if (!status) return;"
scriptString += " if (" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex != '1'){ "
scriptString += " var callDelete=new Function(document.getElementById(" + this.UniqueID.Replace(":", "_") + "SelectedItemIndex).onDelete);"
scriptString += " callDelete();"
scriptString += " } }"
scriptString += " </Script>"
this.Page.RegisterClientScriptBlock(this.UniqueID.Replace(":", "_") + "DeleteMe", scriptString);
#endregion
#endregion
//this.DataBind();
if (this.ViewState["SortExpression"].ToString().Length != 0)

((DataView)this.DataSource).Sort = this.ViewState["SortExpression"].ToString() + this.ViewState["SortDirection"].ToString();

}
/// <summary>
/// Gets Fired Each Time The DataGrid Is Processded
/// </summary>
/// <param name="e"></param>
protected override void OnItemCreated(DataGridItemEventArgs e)
{

base.OnItemCreated(e);

if (e.Item.ItemType == ListItemType.Pager)
{

// Extract the Pager
TableCell pager = (TableCell)e.Item.Controls[0];
pager.HorizontalAlign = HorizontalAlign.Left;

//Add Cell to Row to Hold Row Count Label
//                                                                TableCell newcell = new TableCell();
//                                                                newcell.HorizontalAlign = HorizontalAlign.Right;

//Add Label Indicating Row Count
Label lblNumRecords = new Label();
lblNumRecords.CssClass = "LabelStyle"
lblNumRecords.ID = "lblNumRecords"
pager.Controls.Add(lblNumRecords);

Table pagerTable = new Table();
pagerTable.Width = Unit.Percentage(100);
pagerTable.Rows.Add(new TableRow());
pagerTable.Rows[0].CssClass = e.Item.CssClass;
pagerTable.Rows[0].Cells.Add(pager);
//                                                                pagerTable.Rows[0].Cells.Add(newcell);

e.Item.Controls.Add(new TableCell());
((TableCell)e.Item.Controls[0]).ColumnSpan = pager.ColumnSpan;
e.Item.Controls[0].Controls.Add(pagerTable);

try
{

for (int ictr = 0; ictr < pager.Controls.Count; ictr = ictr + 2)
{

if (pager.Controls[ictr].GetType().ToString() == "System.Web.UI.WebControls.Label")

((Label)pager.Controls[ictr]).CssClass = "LabelStyle"

else

((LinkButton)pager.Controls[ictr]).CssClass = "LabelStyle"

}

}
catch
{
}

}

}
/// <summary>
/// Method to handle the ItemDataBound event of the EMS Datagrid
/// </summary>
/// <param name="e"></param>
protected override void OnItemDataBound(DataGridItemEventArgs e)
{

#region From This Part Implements EMS 1.0 Written Amith
//Set the Sort Glyph
if (e.Item.ItemType == ListItemType.Header && this.ViewState["SortExpression"] != null)
{

//if there is a value for sort
if (this.ViewState["SortExpression"].ToString().Length != 0)
{

for (int i = 0; i < this.Columns.Count; i++)
{

if (this.ViewState["SortExpression"].ToString() == Columns[i].SortExpression)
{

Label lblSorted = new Label();
lblSorted.Font.Name = "webdings"
lblSorted.Font.Size = FontUnit.XSmall;
if (this.ViewState["SortDirection"].ToString() == " ASC")

lblSorted.Text = "6"

else

lblSorted.Text = "5"

e.Item.Cells[i].Controls.Add(lblSorted);

}

}

}

}

//only for items and alternating items
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{

//add the primary key as the row id for each row to support single click
if (((DataRowView)e.Item.DataItem).DataView.Table.PrimaryKey.Length != 0)

e.Item.Attributes.Add("ID", ((DataRowView)e.Item.DataItem).Row[((DataRowView)e.Item.DataItem).DataView.Table.PrimaryKey[0].ColumnName.ToString()].ToString());

else

e.Item.Attributes.Add("ID", ((DataRowView)e.Item.DataItem).Row.ItemArray[0].ToString());

if (this.SelectOnSingleClick)

//set single click attribute to the row
e.Item.Attributes.Add("onclick", this.UniqueID.Replace(":", "_") + "SelectMe(); document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';");

if ((this.EditVisible || this.EditOnDoubleClick) && e.Item.Cells[0].Controls.Count > 0)
{

LinkButton editbutton = (LinkButton)e.Item.Cells[0].Controls[0];
//Set the tooltip if the captionstyle is graphics
if (this.ControlCaption == CaptionType.Graphics)

editbutton.ToolTip = "Edit"

//Set double click attribute to the row, which is enter edit mode
if (this.EditOnDoubleClick)
{

e.Item.Attributes.Add("ondblClick", this.UniqueID.Replace(":", "_") + "OpenMe();; document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';");
//this is to pass the selected item id as an argument to the event.
editbutton.CommandArgument = e.Item.Attributes["ID"];
e.Item.Attributes.Add("onedit", Page.GetPostBackClientHyperlink(editbutton, e.Item.Attributes["ID"]) + " document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';");

}

}
//                
if (this.DeleteVisible && this.AllowDelete == DeleteType.DeleteWithConfirmation && e.Item.Cells[1].Controls.Count > 0)
{

LinkButton deletebutton = null;
//
if (e.Item.Cells[1].Controls[0] is LinkButton)
{

deletebutton = (LinkButton)e.Item.Cells[1].Controls[0];

}
else if (e.Item.Cells[0].Controls[0] is LinkButton)
{

deletebutton = (LinkButton)e.Item.Cells[0].Controls[0];

}
//                                                                                                                                                                
if (!object.Equals(deletebutton, null))
{

//Set the tooltip if the captionstyle is graphics
if (this.ControlCaption == CaptionType.Graphics)

deletebutton.ToolTip = "Delete"

//Set a popup confirmation box attribute if delete needs a confirmation
if (this.AllowDelete == DeleteType.DeleteWithConfirmation)
{

deletebutton.Attributes["onclick"] = "return confirm('" + Resource.Application.DeleteConfirmationMessage + "'); document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';"

}
deletebutton.CommandArgument = e.Item.Attributes["ID"];
e.Item.Attributes.Add("onDelete", Page.GetPostBackClientHyperlink(deletebutton, e.Item.Attributes["ID"]) + " document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';");

}

}
try
{

LinkButton deletebutton;
if (this.editOnDoubleClick)
{

deletebutton = (LinkButton)e.Item.Cells[1].Controls[0];

}
else
{

deletebutton = (LinkButton)e.Item.Cells[0].Controls[0];

}
//this is to pass the selected item id as an argument to the event.
deletebutton.CommandArgument = e.Item.Attributes["ID"];
e.Item.Attributes.Add("onDelete", Page.GetPostBackClientHyperlink(deletebutton, e.Item.Attributes["ID"]) + " document.forms[0].item(\"" + this.strConcurrencyIdControl + "\").value='" + e.Item.Attributes["ID"] + "';");

}
catch
{

//Nothing to do if the first control in the first column is not linkbutton.

}

}
#endregion
#region From This Part Implements EMS 2.0 Written Yasin

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
{

if (this.FullEditable)
{

//
DataTable dt = ((DataView)this.DataSource).Table;
//this.BindServerControl(e.Item, 0, e.Item.ItemIndex, dt.Rows[e.Item.ItemIndex], dt.Columns, dt.Columns.Count);
this.SetDropDownSelectedValue(e, 1);
//
this.SetRowColumnReadOnly(e.Item, 1, e.Item.ItemIndex, dt.Rows[e.Item.ItemIndex], dt.Columns, dt.Columns.Count);
//
this.AddValidatorControl(e, 1);
//
this.AddMultipleControls(e, 1);
//
this.AddDateControl(e, 1);
//
this.FormatGridCell(e, 1);

}
else if (this.EnhanceEdit)
{

if (this.EditItemIndex != -1 && this.EditItemIndex == e.Item.ItemIndex)
{

//
DataTable dt = ((DataView)this.DataSource).Table;
//
this.BindServerControl(e.Item, 2, e.Item.ItemIndex, dt.Rows[e.Item.ItemIndex], dt.Columns, dt.Columns.Count);
//
this.AddValidatorControl(e, 2);
//
this.AddMultipleControls(e, 2);
//
this.AddDateControl(e, 2);
//Removing The Delete Button Link Incase of Edit Mode
if (e.Item.Cells[1].Controls[0] is LinkButton)
{

e.Item.Cells[1].Controls[0].Visible = false;

}

}
else
{

if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{

DataTable dt = ((DataView)this.DataSource).Table;
if (e.Item.ItemIndex < dt.Rows.Count)
{

this.BindServerControl(e.Item, 2, e.Item.ItemIndex, dt.Rows[e.Item.ItemIndex], dt.Columns, dt.Columns.Count);

}

}

}
this.FormatGridCell(e, 2);

}
else
{

this.FormatGridCell(e, 2);

}

}

//Adding The Feature Of CheckBoxState
if (this.blnCheckBoxState)
{

this.AddCheckBoxState(e);

}
#endregion
base.OnItemDataBound(e);

}
/// <summary>
/// Get Fired to Before The HTML Content Is Rendered
/// </summary>
/// <param name="e"></param>
protected override void OnPreRender(EventArgs e)
{

if ((this.AllowPaging || this.AllowCustomPaging) && !Object.Equals(this.DataSource, null))
{

int startRecord = (this.CurrentPageIndex * this.PageSize) + 1;
int endRecord = (startRecord + this.PageSize) - 1;
if (((DataView)this.DataSource).Count < endRecord)

endRecord = ((DataView)this.DataSource).Count;

int totalRecord = ((DataView)this.DataSource).Count;
//Set the top pager
((Label)this.Controls[0].Controls[0].FindControl("lblNumRecords")).Text = "&nbsp;&nbsp;&nbsp;Records " + startRecord.ToString() + " to " + endRecord.ToString() + " of " + totalRecord.ToString();
//Clear the bottom pager
((Label)this.Controls[0].Controls[this.Controls[0].Controls.Count - 1].FindControl("lblNumRecords")).Text = ""
//
if (((DataView)this.DataSource).Count == 0)
{

//TODO: Localization - Amith Ellur
((Label)this.Controls[0].Controls[0].FindControl("lblNumRecords")).Text = "There are no records to be displayed."
this.Controls[0].Controls.Remove(this.Controls[0].Controls[1]);
this.Controls[0].Controls.Remove(this.Controls[0].Controls[2]);
this.Controls[0].Controls[0].Controls[0].Controls[0].Controls[0].Controls.Remove(this.Controls[0].Controls[0].Controls[0].Controls[0].Controls[0].Controls[0]);
this.BorderColor = Color.Transparent;
this.BorderStyle = BorderStyle.None;

}
//Adding The ClientSide Scripts For CheckBoxState
if (this.blnCheckBoxState)
{

this.AddClientSideScript();

}

}

//
if (this.Items.Count > 0)
{

//
this.hidConcurrencyIdControl.ID = HIDDENCONCURRENCYIDCONCTROL;
//
this.hidConcurrencyIdControl.Value = this.Items[0].Attributes["ID"];
//
this.Controls.Add(this.hidConcurrencyIdControl);

}


//Adding The Focus On The Editted Item Control
//                                    if(this.EnhanceEdit)
//                                    {
//                                                bool blnFocus = false;
//                                                for(int item = 0; item < this.Items.Count; item++)
//                                                {
//                                                            if(this.Items[item].ItemType == ListItemType.EditItem)
//                                                            {
//                                                                        for(int cell = 0; cell < this.Items[item].Cells.Count; cell++)            
//                                                                        {
//                                                                                    if(this.Items[item].Cells[cell].Visible)
//                                                                                    {
//                                                                                                for(int control = 0; control < this.Items[item].Cells[cell].Controls.Count; control++)
//                                                                                                {
//                                                                                                            if(this.Items[item].Cells[cell].Controls[control] is TextBox)
//                                                                                                            {
//                                                                                                                        if(!((TextBox)this.Items[item].Cells[cell].Controls[control]).ReadOnly)
//                                                                                                                        {
//                                                                                                                                    this.Page.RegisterClientScriptBlock("focus", "<script>document.forms[0].item(\"" + ((TextBox)this.Items[item].Cells[cell].Controls[control]).ClientID + "\").focus()</script>");
//                                                                                                                                    blnFocus = true;
//                                                                                                                                    break;
//                                                                                                                                                
//                                                                                                                        }
//                                                                                                            }
//                                                                                                            else if(this.Items[item].Cells[cell].Controls[control] is DropDownList)
//                                                                                                            {
//                                                                                                                        this.Page.RegisterClientScriptBlock("focus", "<script>document.forms[0].item(\"" + ((DropDownList)this.Items[item].Cells[cell].Controls[control]).ClientID + "\").focus()</script>");
//                                                                                                                        blnFocus = true;
//                                                                                                                        break;
//                                                                                                            }
//                                                                                                }
//                                                                                    }
//                                                                                    if(blnFocus) break;
//                                                                        }
//                                                            }
//                                                            if(blnFocus) break;
//                                                }
//                                    }                                    

base.OnPreRender(e);

}
/// <summary>
///
/// </summary>
/// <param name="savedState"></param>
//protected override void LoadViewState(object savedState)
//{
//this.DataSource = HttpContext.Current.Cache["temp"];
//this.DataMember = HttpContext.Current.Cache["temp1"].ToString();
//this.DataBind();
//TODO: Yasin, This is where the columns controls should be added - Amith Ellur
//}

//protected override object SaveViewState()
//{
//HttpContext.Current.Cache["temp"]  = this.DataSource;
//HttpContext.Current.Cache["temp1"] = this.DataMember;
//this.ViewState;
//        return null;
//}
#endregion
#region Events That Get Fired On Post Back When Edit, Delete, Sorting, Paging etc.. Get Fired
/// <summary>
/// Method to handle the PageIndexChanged event of the EMS Datagrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
private void EMSDataGrid_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{

this.WriteHiddenControl();
this.EditItemIndex = -1;
this.CurrentPageIndex = e.NewPageIndex;
this.DataBind();

}
/// <summary>
/// Method to handle the CancelCommand event of the EMS Datagrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
private void EMSDataGrid_CancelCommand(object source, DataGridCommandEventArgs e)
{

this.EditItemIndex = -1;
this.DataBind();

}
/// <summary>
/// Method to handle the EditCommand event of the EMS Datagrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
private void EMSDataGrid_EditCommand(object source, DataGridCommandEventArgs e)
{

try
{

//Calling The Helper Function To Validate If The Record Exists In The Grid
this.ValidateConcurrencyControl(e.Item.Attributes["ID"]);
//if inline edit, hide the delete column
if (this.AllowEdit == EditType.InLine)
{

//this.EditItemIndex = e.Item.ItemIndex;
ToggleDeleteColumn(false);
this.DataBind();

}
//if not inline edit, then redirect to the selected page
else if (this.AllowEdit == EditType.PageRedirect)
{

OnEditPage(e);

}

}
catch (Exception exception)
{

this.ProcessException(exception);

}

}
/// <summary>
/// Method to handle the UpdateCommand event of the EMS Datagrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
private void EMSDataGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{

//Validating If Ehance Edit Is True
if (this.EnhanceEdit)
{

//Calling The Helper Function For Updating The Specific Data Row From DataGrid Row Values
this.ReadDataGridData(e.Item.ItemIndex);
//Creating A DataTable From The Default DataView
DataTable dt = ((DataView)this.DataSource).Table;
//Declaring the PK
DataColumn[] prk = dt.PrimaryKey;
//Coping the DataRow
DataRow dr = dt.Rows[e.Item.ItemIndex];
//Iterating Through the Primary Keys To Set The New Guid Incase A New Record Is Added
for (int dclength = 0; dclength < prk.Length; dclength++)
{

//Validating if the primary is blank
if (object.Equals(dr[prk[dclength].Ordinal], DBNull.Value))
{

//Validating if the primary is readonly
if (dt.Columns[prk[dclength].ColumnName].ReadOnly)
{

//Updating the New Guid for the PK
dt.Columns[prk[dclength].ColumnName].ReadOnly = false;
dr[prk[dclength].ColumnName] = Guid.NewGuid();
dt.Columns[prk[dclength].ColumnName].ReadOnly = true;

}

}

}

//Iterating Through the DataColums To Set The Default Values For The New Data Row
for (int dclength = 0; dclength < dt.Columns.Count; dclength++)
{

//Validating if the column is readonly
if (dt.Columns[dclength].ReadOnly)
{

//Validating if the data columns value is dbnull
if (object.Equals(dr[dclength], DBNull.Value))
{

//Updating the default value
dt.Columns[dclength].ReadOnly = false;
dr[dclength] = dt.Columns[dclength].DefaultValue;
dt.Columns[dclength].ReadOnly = true;

}

}

}
//Copying the Structure of the datatable
this.dtModifiedDataTable = dt.Clone();
//Adding A new Row
DataRow newdr = this.dtModifiedDataTable.NewRow();
//Iterating To The Columns of the datarow
for (int i = 0; i < dr.ItemArray.Length; i++)
{

//Updating Data Into New Column
newdr[i] = dr.ItemArray[i];

}
//Adding The New DataRow
this.dtModifiedDataTable.Rows.Add(newdr);

}
//base.OnUpdateCommand(e);
//show the delete column of the datagrid
ToggleDeleteColumn(true);

}
/// <summary>
/// Method to handle the SortCommand event of the EMS Datagrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
private void EMSDataGrid_SortCommand(object source, DataGridSortCommandEventArgs e)
{

this.ViewState["SortExpression"] = e.SortExpression;

//Change the sort direction for next use.
if (this.ViewState["SortDirection"].ToString() == " DESC")

this.ViewState["SortDirection"] = " ASC"

else

this.ViewState["SortDirection"] = " DESC"

// The DataView provides an easy way to sort. Simply set the
// Sort property with the name of the field to sort by.
((DataView)this.DataSource).Sort = e.SortExpression + this.ViewState["SortDirection"];

// Rebind the data source and specify that it should be sorted
// by the field specified in the SortExpression property.
this.DataBind();

}

/// <summary>
///
/// </summary>
/// <param name="e"></param>
protected override void OnDeleteCommand(DataGridCommandEventArgs e)
{

try
{

// If First item in the row, one page back
if (this.Items.Count == 1)

this.CurrentPageIndex = (this.CurrentPageIndex == 0 ? 0 : this.CurrentPageIndex - 1);

//Calling The Helper Function To Validate If The Record Exists In The Grid
this.ValidateConcurrencyControl(e.Item.Attributes["ID"]);
base.OnDeleteCommand(e);

}
catch (Exception exception)
{

//Calling The Helper Function
this.ProcessException(exception);

}

}
/// <summary>
/// This Helper Function Rasies The EMSDataGridRaiseException Event
/// </summary>
/// <param name="exception"></param>
private void ProcessException(Exception exception)
{

//Validating If The Caller Has Implemented The Event
if (!object.Equals(this.EMSDataGridRaiseException, null))
{

this.EMSDataGridRaiseException(this, exception);

}
else
{

throw exception;

}

}

/// <summary>
/// Used For Page Redirect
/// </summary>
/// <param name="e"></param>
protected virtual void OnEditPage(DataGridCommandEventArgs e)
{

if (EditPage != null)

EditPage(this, e);

}
#endregion
#endregion
#region Helper Functions Used In Class
/// <summary>
/// Show/Hide the DELETE column when in edit mode. This handles the visibility of Delete column based on DeleteVisible property
/// </summary>
/// <param name="bViewState"></param>
private void ToggleDeleteColumn(bool bViewState)
{

if (!this.DeleteVisible)

Columns[1].Visible = bViewState;

}
/// <summary>
/// This Helper function Is Called In The Page Index Changed Event To Store The Checked Records In The Dataset From The Hidden Control
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
private void WriteHiddenControl()
{

if (this.blnCheckBoxState)
{

//
if (this.DataSource == null && this.DataSource is DataSet)
{

return;

}
//
string strHidden = HttpContext.Current.Request[this.strHiddenCheckBoxState];
//Validating If The user has checked any records
if (strHidden.Length > 0)
{

//Validating If The ViewState Exists For This Object
if (object.Equals(this.ViewState[this.strHiddenCheckBoxState], null))
{

//Creating The DataTable
DataTable dtCheckBoxState = new DataTable(this.DataMember.ToString());
//Adding Columns To The DataTable
dtCheckBoxState.Columns.Add(new DataColumn("PageNumber", System.Type.GetType("System.Int64")));
dtCheckBoxState.Columns.Add(new DataColumn("Id", System.Type.GetType("System.Guid")));
//Splitting The Strings
string[] spliter = strHidden.Split(new char[1] { '~' });
string[] strId = spliter[1].Split(new char[1] { '^' });
//Adding The Newly Checked Records Into The DataTable
for (int i = 0; i < strId.Length; i++)
{

//
DataView dv = ((DataView)this.DataSource);
//
DataColumn[] dc = dv.Table.PrimaryKey;
//
if (dc.Length == 1)
{

//
DataRow[] DataRowSearch = dv.Table.Select(dc[0].ColumnName + "='" + strId[i] + "'");
//
if (DataRowSearch.Length == 1)
{

DataRow drCheckBoxState = dtCheckBoxState.NewRow();
dtCheckBoxState.Rows.Add(drCheckBoxState);
drCheckBoxState["PageNumber"] = spliter[0];
drCheckBoxState["Id"] = strId[i];

}

}
else
{

throw new Exception("No Primary Key Set For Binded DataTable " + dv.Table.TableName);

}

}
//Creating the Instance Of The DataSet
this.dsCheckBoxState = new DataSet();
//Adding the DataTable To The DataSet
this.dsCheckBoxState.Tables.Add(dtCheckBoxState);

}
else
{

//Creating The Instance Of The DataSet
this.dsCheckBoxState = new DataSet();
//Creating The Instance of StringReader Class
StringReader sr = new StringReader(this.ViewState[this.strHiddenCheckBoxState].ToString());
//Loading The DataSet From StringReader Class
this.dsCheckBoxState.ReadXml(sr);
//Fetching The datatable from the dataset
DataTable dtCheckBoxState = this.dsCheckBoxState.Tables[this.DataMember.ToString()];
//Splitting The Strings
string[] spliter = strHidden.Split(new char[1] { '~' });
//Filtering The DataTable Based on DataRows
DataRow[] dr = dtCheckBoxState.Select("PageNumber" + "='" + strHidden[0] + "'");
//Removing The DataRows Which Were Affected From The DataTable.Select Method
for (int drCtr = 0; drCtr < dr.Length; drCtr++)
{

dtCheckBoxState.Rows.Remove(dr[drCtr]);

}
//                        
if (spliter.Length == 2)
{

//
string[] strId = spliter[1].Split(new char[1] { '^' });
//Checking The DataRow Length
if (dr.Length == 0)
{

//Adding The Newly Checked Records Into The DataTable
for (int i = 0; i < strId.Length; i++)
{

//
DataView dv = ((DataView)this.DataSource);
//
DataColumn[] dc = dv.Table.PrimaryKey;

if (dc.Length == 1)
{

//
DataRow[] DataRowSearch = dv.Table.Select(dc[0].ColumnName + "='" + strId[i] + "'");
//
if (DataRowSearch.Length == 1)
{

DataRow drCheckBoxState = dtCheckBoxState.NewRow();
dtCheckBoxState.Rows.Add(drCheckBoxState);
drCheckBoxState["PageNumber"] = spliter[0];
drCheckBoxState["Id"] = strId[i];

}

}
else
{

throw new Exception("No Primary Key Set For Binded DataTable " + dv.Table.TableName);

}

}

}
else
{

//Adding The Newly Checked Records Into The DataTable
for (int i = 0; i < strId.Length; i++)
{

//
DataView dv = ((DataView)this.DataSource);
//
DataColumn[] dc = dv.Table.PrimaryKey;

if (dc.Length == 1)
{

//
DataRow[] DataRowSearch = dv.Table.Select(dc[0].ColumnName + "='" + strId[i] + "'");
//
if (DataRowSearch.Length == 1)
{

DataRow drCheckBoxState = dtCheckBoxState.NewRow();
dtCheckBoxState.Rows.Add(drCheckBoxState);
drCheckBoxState["PageNumber"] = spliter[0];
drCheckBoxState["Id"] = strId[i];

}

}
else
{

throw new Exception("No Primary Key Set For Binded DataTable " + dv.Table.TableName);

}

}

}

}

}
//Storing The DataSet Into ViewState
//TODO: Amith Please Check This Option And Get Back
if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

this.ViewState[this.strHiddenCheckBoxState] = this.dsCheckBoxState.GetXml();

}
this.intNoOfRecordsCheckBoxState = this.dsCheckBoxState.Tables[0].Rows.Count;

}
else
{

if (!object.Equals(HttpContext.Current.Request[this.strHiddenPreviousPage], null) && !object.Equals(this.ViewState[this.strHiddenCheckBoxState], null))
{

//Creating The Instance Of The DataSet
this.dsCheckBoxState = new DataSet();
//Creating The Instance of StringReader Class
StringReader sr = new StringReader(this.ViewState[this.strHiddenCheckBoxState].ToString());
//Loading The DataSet From StringReader Class
this.dsCheckBoxState.ReadXml(sr);
//Fetching The datatable from the dataset
DataTable dtCheckBoxState = this.dsCheckBoxState.Tables[this.DataMember.ToString()];
//Filtering The DataTable Based on DataRows
DataRow[] dr = dtCheckBoxState.Select("PageNumber" + "='" + HttpContext.Current.Request[this.strHiddenPreviousPage] + "'");
//Removing The DataRows Which Were Affected From The DataTable.Select Method
for (int drCtr = 0; drCtr < dr.Length; drCtr++)
{

dtCheckBoxState.Rows.Remove(dr[drCtr]);

}
//Storing The DataSet Into ViewState
//TODO: Amith Please Check This Option And Get Back
if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

this.ViewState[this.strHiddenCheckBoxState] = this.dsCheckBoxState.GetXml();

}
else
{

this.ViewState.Remove(this.strHiddenCheckBoxState);

}

}
//
if (!object.Equals(HttpContext.Current.Request[this.strCheckBoxStateCount], null))
{

//
if (HttpContext.Current.Request[this.strCheckBoxStateCount].Trim().Length > 0)
{

this.intNoOfRecordsCheckBoxState = int.Parse(HttpContext.Current.Request[this.strCheckBoxStateCount].Trim());

}

}

}

}

}
/// <summary>
/// Helper function Is used To Set The Various Item Template For The Grid
/// </summary>
private void SetColumnsCollection()
{

//TODO: Remove - Yasin
string strCellName;

int ctr;
//
if (this.EditOnDoubleClick && this.selectOnSingleClick)
{

ctr = 2;

}
else
{

ctr = 1;

}
//
foreach (DataColumn col in ((DataView)this.DataSource).Table.Columns)
{

strCellName = this.NamingContainer.ID + "_" + this.ID + "_row" + this.Items.Count + "_ctr" + col.Ordinal.ToString();

this.PropertyCollection = col.ExtendedProperties;

TemplateColumn tc1 = new TemplateColumn();

if (this.intCheckBoxColumn == ctr)
{

tc1.HeaderTemplate = new

DataGridTemplate(ListItemType.Header, col.ColumnName, col.Caption, col.Ordinal, col.DataType.ToString(), this.AllowSorting, this.HeaderStyle.CssClass, this.blnFullEdidtable, col.ReadOnly, this.PropertyCollection, col.AllowDBNull, this.blnEnhanceEdit, strCellName, col.MaxLength, this.blnCheckBoxState, this.intCheckBoxColumn);

}
else
{

tc1.HeaderTemplate = new

DataGridTemplate(ListItemType.Header, col.ColumnName, col.Caption, col.Ordinal, col.DataType.ToString(), this.AllowSorting, this.HeaderStyle.CssClass, this.blnFullEdidtable, col.ReadOnly, this.PropertyCollection, col.AllowDBNull, this.blnEnhanceEdit, strCellName, col.MaxLength, false, this.intCheckBoxColumn);

}

tc1.ItemTemplate = new

DataGridTemplate(ListItemType.Item, col.ColumnName, col.Caption, col.Ordinal, col.DataType.ToString(), this.AllowSorting, this.HeaderStyle.CssClass, this.blnFullEdidtable, col.ReadOnly, this.PropertyCollection, col.AllowDBNull, this.blnEnhanceEdit, strCellName, col.MaxLength, this.blnCheckBoxState, this.intCheckBoxColumn);

tc1.EditItemTemplate = new

DataGridTemplate(ListItemType.EditItem, col.ColumnName, col.Caption, col.Ordinal, col.DataType.ToString(), this.AllowSorting, this.HeaderStyle.CssClass, this.blnFullEdidtable, col.ReadOnly, this.PropertyCollection, col.AllowDBNull, this.blnEnhanceEdit, strCellName, col.MaxLength, this.blnCheckBoxState, this.intCheckBoxColumn);

tc1.FooterTemplate = new

DataGridTemplate(ListItemType.Footer, col.ColumnName, col.Caption, col.Ordinal, col.DataType.ToString(), this.AllowSorting, this.HeaderStyle.CssClass, this.blnFullEdidtable, col.ReadOnly, this.PropertyCollection, col.AllowDBNull, this.blnEnhanceEdit, strCellName, col.MaxLength, this.blnCheckBoxState, this.intCheckBoxColumn);

tc1.SortExpression = col.ColumnName;

if (!Object.Equals(col.ExtendedProperties[EMSDataGridExtendedProperties.Visibility], null))
{

tc1.Visible = (bool)col.ExtendedProperties[EMSDataGridExtendedProperties.Visibility];

}

this.Columns.Add(tc1);
//
ctr++;

}

}

/// <summary>
///  This Helper Function Is Used For Validating If The Selected Records Exists In Post Backs
/// </summary>
/// <param name="strID"></param>
private void ValidateConcurrencyControl(string strID)
{

if (!object.Equals(this.strConcurrencyIdControl, null))
{

if (strID != HttpContext.Current.Request[this.strConcurrencyIdControl])
{

throw new Exception("||Record Does Not Exisits In The System||");

}

}

}
/// <summary>
/// Helper Function Returns A DataTime Based On The Specific Format Used With Concurrency
/// </summary>
/// <param name="strDate"></param>
/// <returns></returns>
private DateTime DateConvertorConcurrency(string strDate)
{

//TODO: Get It From The Ticket
return DateTime.ParseExact(strDate, "dd/MM/yyyy HH:mm:ss:fff", System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None);

}
/// <summary>
/// Helper Function Returns A String Based On The Specific Format Used With Concurrency
/// </summary>
/// <param name="dtDate"></param>
/// <returns></returns>
private string DateConvertorConcurrency(DateTime dtDate)
{

return dtDate.ToString("dd/MM/yyyy HH:mm:ss:fff");

}
/// <summary>
/// Helper function Is Used To Format The Date Based On System Preferences
/// </summary>
/// <param name="dtDate"></param>
/// <returns></returns>
public DateTime DateConvertor(string strDate)
{

//TODO: Get It From The Ticket
return DateTime.ParseExact(strDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None);

}
/// <summary>
///  Helper function Is Used To Format The Date Based On System Preferences
/// </summary>
/// <param name="dtDate"></param>
/// <returns></returns>
public string DateConvertor(DateTime dtDate)
{

return dtDate.ToString("dd/MM/yyyy");

}

/// <summary>
/// Helper function converts A DataRow Value into Date
/// </summary>
/// <param name="objDate"></param>
/// <returns></returns>
private object GetValidDate(object objDate)
{

if (objDate.Equals(DBNull.Value))
{

return objDate;

}
else
{

return this.DateConvertor(objDate.ToString());

}

}
/// <summary>
/// Helper function converts A DataRow Value into Valid String Value
/// </summary>
/// <param name="strValue"></param>
/// <returns></returns>
private object GetValidValue(string strValue)
{

strValue = strValue.ToString().Trim();
if (strValue.Length == 0)
{

return DBNull.Value;

}
else
{

return strValue;

}

}
/// <summary>
/// Helper function converts A String Value Into A DataRow Value
/// </summary>
/// <param name="strControlValue"></param>
/// <returns></returns>
private object SetValidDBValue(string strControlValue)
{

strControlValue = strControlValue.Trim();

if (strControlValue.Length == 0)
{

return DBNull.Value;

}
else
{

return strControlValue;

}

}

/// <summary>
/// This helper function is called in the ItemDataBound Event to format the Item Cells based on the datatypes
/// </summary>
private void FormatGridCell(DataGridItemEventArgs e, int cells)
{

try
{

DataTable dt = ((DataView)this.DataSource).Table;
for (int i = 0; i < dt.Columns.Count; i++)
{

//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dt.Columns[i].DataType.ToString())
{

case "System.Guid": //UniqueIdentifier

break;

case "System.String": //varchar

e.Item.Cells[cells].HorizontalAlign = HorizontalAlign.Left;
break;

case "System.Boolean": //Bit

e.Item.Cells[cells].HorizontalAlign = HorizontalAlign.Center;
break;

case "System.Int64": //BigInt

//Right
goto case "Numeric"

case "System.Decimal": //Decimal, Money, Numeric, SmallMoney

//Right
goto case "Numeric"

case "System.Double": //Float

//Right
goto case "Numeric"

case "System.Int32": //Int

//Right
goto case "Numeric"

case "System.Int16": //smallInt

//Right
goto case "Numeric"

case "System.Byte": //tinyInt

//Right
goto case "Numeric"

case "System.DateTime": //DateTime

//Center
e.Item.Cells[cells].HorizontalAlign = HorizontalAlign.Center;
//Format Based
for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is Literal)
{

if (dt.Rows[e.Item.ItemIndex][i] != DBNull.Value)
{

((Literal)e.Item.Cells[cells].Controls[ctl]).Text = this.DateConvertor((DateTime)dt.Rows[e.Item.ItemIndex][i]);

}
break;

}
else if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

if (dt.Rows[e.Item.ItemIndex][i] != DBNull.Value)
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).Text = this.DateConvertor((DateTime)dt.Rows[e.Item.ItemIndex][i]);

}
break;

}

}
break;

case "Numeric":

e.Item.Cells[cells].HorizontalAlign = HorizontalAlign.Right;
break;

}
cells++;

}

}
catch
{

}

}

/// <summary>
/// Helper Functions Used to Various Validator Control
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
private void AddValidatorControl(DataGridItemEventArgs e, int cells)
{

DataTable dt = ((DataView)this.DataSource).Table;

for (int i = 0; i < dt.Columns.Count; i++)
{

string strCellName = this.NamingContainer.ID + "_" + this.ID + "_row" + e.Item.Cells.Count + "_ctr" + dt.Columns[i].Ordinal.ToString();

//Putting Required Field Validators For Colunms
if (!dt.Columns[i].ReadOnly && !dt.Columns[i].AllowDBNull)
{

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;
e.Item.Cells[cells].Controls.Add(RequiredFieldValidatorControl(strCellName));

}

if (e.Item.Cells[cells].Controls[ctl] is DropDownList)
{

((DropDownList)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;
e.Item.Cells[cells].Controls.Add(RequiredFieldValidatorControl(strCellName));

}

}

}

//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dt.Columns[i].DataType.ToString())
{

case ("System.Decimal"):

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

if (object.Equals(((TextBox)e.Item.Cells[cells].Controls[ctl]).ID, null))
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
e.Item.Cells[cells].Controls.Add(this.RangeValidatorControl(strCellName, ValidationDataType.Double, dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.MaxValue], dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.MinValue]));

}

}
break;

case ("System.Int16"):

break;

case ("System.Int32"):

break;

case ("System.Int64"):

break;

}

//Adding Additional Required Field Validator Controls
if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRequiredFieldValidator], null))
{

RequiredFieldValidator rfv = new RequiredFieldValidator();

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRequiredFieldValidatorErrorMessage], null))
{

rfv.ErrorMessage = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRequiredFieldValidatorErrorMessage].ToString();

}
else
{

rfv.ErrorMessage = REQUIREDERRORMESSAGE;

}

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRequiredFieldValidatorCssClass], null))
{

rfv.CssClass = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRequiredFieldValidatorCssClass].ToString();

}
else
{

rfv.CssClass = VALIDATORSTYLESHEET;

}

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
else if (e.Item.Cells[cells].Controls[ctl] is DropDownList)
{

((DropDownList)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}

}

rfv.ControlToValidate = strCellName;

e.Item.Cells[cells].Controls.Add(rfv);

}
//Adding Additional Regular Expression Validator Controls
if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidator], null))
{

RegularExpressionValidator rev = new RegularExpressionValidator();
if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorErrorMessage], null))
{

rev.ErrorMessage = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorErrorMessage].ToString();

}
else
{

rev.ErrorMessage = REGULARERRORMESSAGE;

}

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorCssClass], null))
{

rev.CssClass = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorCssClass].ToString();

}
else
{

rev.CssClass = VALIDATORSTYLESHEET;

}

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorExpression], null))
{

rev.ValidationExpression = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomRegularExpressionValidatorExpression].ToString();

}
else
{

throw new ArgumentNullException("Regular Expression Patern Not Set For Column " + dt.Columns[i].ColumnName);

}

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
else if (e.Item.Cells[cells].Controls[ctl] is DropDownList)
{

((DropDownList)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}

}

rev.ControlToValidate = strCellName;

e.Item.Cells[cells].Controls.Add(rev);

}

//Adding Additional Custom Validator Controls
if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidator], null))
{

CustomValidator cv = new CustomValidator();
if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorErrorMessage], null))
{

cv.ErrorMessage = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorErrorMessage].ToString();

}
else
{

cv.ErrorMessage = CUSTOMERRORMESSAGE;

}

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorCssClass], null))
{

cv.CssClass = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorCssClass].ToString();

}
else
{

cv.CssClass = VALIDATORSTYLESHEET;

}

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorClientValidationFunction], null))
{

cv.ClientValidationFunction = dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.CustomCustomValidatorClientValidationFunction].ToString();

}
else
{

throw new ArgumentNullException("Custom Validator Client Validation Function Not Set " + dt.Columns[i].ColumnName);

}

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
else if (e.Item.Cells[cells].Controls[ctl] is DropDownList)
{

((DropDownList)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}

}

cv.ControlToValidate = strCellName;

e.Item.Cells[cells].Controls.Add(cv);

}
//Range Validator


//Compare Validator


cells++;

}

}
/// <summary>
/// Helper Function Used To Add Multiple Controls
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
private void AddMultipleControls(DataGridItemEventArgs e, int cells)
{

DataTable dt = ((DataView)this.DataSource).Table;

for (int i = 0; i < dt.Columns.Count; i++)
{

string strCellName = this.NamingContainer.ID + "_" + this.ID + "_row" + e.Item.Cells.Count + "_ctr" + dt.Columns[i].Ordinal.ToString();

//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dt.Columns[i].DataType.ToString())
{

case ("System.String"):

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.ElipseButton], null))
{

TextBox textbox = new TextBox();
for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

if (object.Equals(((TextBox)e.Item.Cells[cells].Controls[ctl]).ID, null))
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
//Storing The Textbox Information In ElipseTextBox
textbox = ((TextBox)e.Item.Cells[cells].Controls[ctl]);

}
else if (e.Item.Cells[cells].Controls[ctl] is HtmlInputButton && !object.Equals(textbox, null))
{

((HtmlInputButton)e.Item.Cells[cells].Controls[ctl]).Attributes.Add("onclick", this.NamingContainer.ID + this.ID + dt.Columns[i].ColumnName.Replace(" ", "_") + "(document.forms[0]." + textbox.ClientID + "," + (e.Item.ItemIndex + 1) + "," + cells + ")");

}

}

}
else if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControl], null))
{

//
object[] obj = (object[])dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControl];
//
string strControlValue = string.Empty;
//
if (e.Item.Cells[cells].Controls[0] is TextBox)
{

strControlValue = ((TextBox)e.Item.Cells[cells].Controls[0]).Text;

}
else if (e.Item.Cells[cells].Controls[0] is Literal)
{

strControlValue = ((Literal)e.Item.Cells[cells].Controls[0]).Text;

}
//
string[] spliter = strControlValue.Split(new char[1] { char.Parse(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControlDelimiter].ToString()) });
//
e.Item.Cells[cells].Controls.RemoveAt(0);
//
for (int ctr = 0; ctr < obj.Length; ctr++)
{

Hashtable hashtable = (Hashtable)obj[ctr];

if (hashtable[EMSDataGridExtendedProperties.MultipleControlDropDown] is DropDownList)
{

DropDownList dropdownlist;

if (this.FullEditable)
{

//TODO: Having Problem In Memory Management Of Adding The Same Object To The Grid Control
dropdownlist = new DropDownList();

}
else
{

dropdownlist = (DropDownList)hashtable[EMSDataGridExtendedProperties.MultipleControlDropDown];

}

dropdownlist.CssClass = DROPDOWNSTYLE;
if (object.Equals(dropdownlist.ID, null))
{

dropdownlist.ID = dt.Columns[i].ColumnName + "_" + ctr.ToString();

}
DataTable datatable = (DataTable)hashtable[EMSDataGridExtendedProperties.MultipleControlDropDownDataTable];

dropdownlist.DataSource = datatable;
dropdownlist.DataTextField = hashtable[EMSDataGridExtendedProperties.MultipleControlDropDownDataTextField].ToString();
dropdownlist.DataValueField = hashtable[EMSDataGridExtendedProperties.MultipleControlDropDownDataValueField].ToString();
dropdownlist.DataBind();

dropdownlist.Items[0].Text = DROPDOWNDEFAULTTEXT;

if (spliter.Length == obj.Length)
{

if (spliter[ctr].Length > 0)
{

dropdownlist.SelectedValue = spliter[ctr];

}

}

if (this.FullEditable)
{

if (!object.Equals(dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly], null))
{

if (dt.Rows[e.Item.ItemIndex][dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()].GetType().ToString() == "System.Boolean")
{

bool blnFlag = (bool)dt.Rows[e.Item.ItemIndex][dt.Columns[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()];

if (!blnFlag)
{

e.Item.Cells[cells].Controls.Add(dropdownlist);

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator], null))
{

RequiredFieldValidator rfv;

if (this.FullEditable)
{

rfv = new RequiredFieldValidator();

}
else
{

rfv = (RequiredFieldValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator];

}

rfv.ErrorMessage = REQUIREDERRORMESSAGE + "<BR>"
rfv.CssClass = VALIDATORSTYLESHEET;
rfv.ControlToValidate = dropdownlist.ID;
rfv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rfv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator], null))
{

CompareValidator cv;

if (this.FullEditable)
{

cv = new CompareValidator();

}
else
{

cv = (CompareValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator];

}

cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator], null))
{

CustomValidator cv;

if (this.FullEditable)
{

cv = new CustomValidator();

}
else
{

cv = (CustomValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator];

}

cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator], null))
{

RangeValidator rv;

if (this.FullEditable)
{

rv = new RangeValidator();

}
else
{

rv = (RangeValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator];

}

rv.CssClass = VALIDATORSTYLESHEET;
rv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator], null))
{

RegularExpressionValidator re;

if (this.FullEditable)
{

re = new RegularExpressionValidator();

}
else
{

re = (RegularExpressionValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator];

}
re.CssClass = VALIDATORSTYLESHEET;
re.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(re);

}

}
else
{

e.Item.Cells[cells].Text = strControlValue;

}

}

}
else
{

e.Item.Cells[cells].Controls.Add(dropdownlist);

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator], null))
{

RequiredFieldValidator rfv;

if (this.FullEditable)
{

rfv = new RequiredFieldValidator();

}
else
{

rfv = (RequiredFieldValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator];

}

rfv.ErrorMessage = REQUIREDERRORMESSAGE + "<BR>"
rfv.CssClass = VALIDATORSTYLESHEET;
rfv.ControlToValidate = dropdownlist.ID;
rfv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rfv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator], null))
{

CompareValidator cv;

if (this.FullEditable)
{

cv = new CompareValidator();

}
else
{

cv = (CompareValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator];

}
cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator], null))
{

CustomValidator cv;

if (this.FullEditable)
{

cv = new CustomValidator();

}
else
{

cv = (CustomValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator];

}
cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator], null))
{

RangeValidator rv;

if (this.FullEditable)
{

rv = new RangeValidator();

}
else
{

rv = (RangeValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator];

}

//RangeValidator rv = (RangeValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator];
rv.CssClass = VALIDATORSTYLESHEET;
rv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator], null))
{

RegularExpressionValidator re;

if (this.FullEditable)
{

re = new RegularExpressionValidator();

}
else
{

re = (RegularExpressionValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator];

}
re.CssClass = VALIDATORSTYLESHEET;
re.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(re);

}

}

}
else
{

e.Item.Cells[cells].Controls.Add(dropdownlist);

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator], null))
{

RequiredFieldValidator rfv = (RequiredFieldValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRequiredFieldValidator];
rfv.ErrorMessage = REQUIREDERRORMESSAGE + "<BR>"
rfv.CssClass = VALIDATORSTYLESHEET;
rfv.ControlToValidate = dropdownlist.ID;
rfv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rfv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator], null))
{

CompareValidator cv = (CompareValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCompareValidator];
cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator], null))
{

CustomValidator cv = (CustomValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlCustomValidator];
cv.CssClass = VALIDATORSTYLESHEET;
cv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(cv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator], null))
{

RangeValidator rv = (RangeValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRangeValidator];
rv.CssClass = VALIDATORSTYLESHEET;
rv.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(rv);

}

if (!object.Equals(hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator], null))
{

RegularExpressionValidator re = (RegularExpressionValidator)hashtable[EMSDataGridExtendedProperties.MultipleControlRegularExpressionValidator];
re.CssClass = VALIDATORSTYLESHEET;
re.Display = ValidatorDisplay.Dynamic;
e.Item.Cells[cells].Controls.Add(re);

}

}

}

}

}
break;

}
cells++;

}

}
/// <summary>
/// Helper Function Used To Set The Values For Editable Grid Items
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
/// <param name="row"></param>
/// <param name="dr"></param>
/// <param name="dc"></param>
/// <param name="columncount"></param>
private void BindServerControl(DataGridItem e, int cells, int row, DataRow dr, DataColumnCollection dc, int columncount)
{

//
DataTable dt = ((DataView)this.DataSource).Table;
//
DataColumn[] dcPrimaryKey;
//
dcPrimaryKey = dt.PrimaryKey;
#region Making The Whole Row As ReadOnly
if (dcPrimaryKey.Length == 1)
{

if (!object.Equals(dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow], null))
{

//
if (dr[dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow].ToString()].GetType().ToString() == "System.Boolean")
{

//
if ((bool)dr[dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow].ToString()])
{

//
if (!Object.Equals(dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyStyle], null))
{

e.CssClass = dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyStyle].ToString();

}
else
{

e.CssClass = "CATDataGridReadOnlyItemStyle"

}
//
if (e.Cells[0].Controls[0] is LinkButton)
{

e.Cells[0].Controls.RemoveAt(0);

}
//
if (e.Cells[1].Controls[0] is LinkButton)
{

e.Cells[1].Controls.RemoveAt(0);

}

}

}

}

}
#endregion
//
for (int i = 0; i < columncount; i++)
{

if (!dc[i].ReadOnly)
{

#region Setting The Control Values
//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dc[i].DataType.ToString())
{

#region Setting Drop Down Box Value with GUID DataType
case ("System.Guid"):

for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

if (e.Cells[cells].Controls[ctl] is DropDownList)
{

this.BindDropDown((DropDownList)e.Cells[cells].Controls[ctl], dr[i].ToString(), dc[i].ColumnName, dc[i].Caption, dc[i].ExtendedProperties);
if (e.Cells[cells].Controls[0] is Literal)
{

e.Cells[cells].Controls.RemoveAt(0);

}

break;

}
else if (e.Cells[cells].Controls[ctl] is Literal)
{

e.Cells[cells].ID = this.NamingContainer.ClientID + "_" + this.ClientID + "_" + e.ItemIndex + "_" + cells + "_" + dr[i].ToString();

}

}
break;

#endregion
#region Setting TextBox Value with Decimal DataType
case ("System.Decimal"):

for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

if (e.Cells[cells].Controls[ctl] is TextBox)
{

((TextBox)e.Cells[cells].Controls[ctl]).Text = dr[i].ToString();
break;

}

}
break;

#endregion
case ("System.Int16"):

break;

case ("System.Int32"):

break;

case ("System.Int64"):

break;

#region Setting TextBox Value with DataTime DataType
case ("System.DateTime"):

if (!object.Equals(dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ConcurrencyState], null))
{

if (e.ItemType == ListItemType.EditItem)
{

if (object.Equals(this.ViewState[HIDDENCONCURRENCYSTATE], null))
{

if (!object.Equals(dr[i], DBNull.Value))
{

this.ViewState[HIDDENCONCURRENCYSTATE] = this.DateConvertorConcurrency((DateTime)dr[i]);
this.ViewState["ItemIndex"] = e.ItemIndex;

}

}
else if (this.ViewState[HIDDENCONCURRENCYSTATE].ToString().Trim().Length > 0 && (int)this.ViewState["ItemIndex"] != e.ItemIndex)
{

if (!object.Equals(dr[i], DBNull.Value))
{

this.ViewState[HIDDENCONCURRENCYSTATE] = this.DateConvertorConcurrency((DateTime)dr[i]);
this.ViewState["ItemIndex"] = e.ItemIndex;

}

}

}

}
break;

#endregion

}
#endregion
#region Setting A Particular Column As ReadOnly In EnLine Edit
//
if (!object.Equals(dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly], null))
{

Literal lit = new Literal();
//
if (dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].GetType().ToString() == "System.Boolean")
{

for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

//
if (e.Cells[cells].Controls[ctl] is TextBox)
{

//
if ((bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly])
{

lit.Text = ((TextBox)e.Cells[cells].Controls[ctl]).Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
//
if (e.Cells[cells].Controls[ctl] is DropDownList)
{

//
if ((bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly])
{

lit.Text = ((DropDownList)e.Cells[cells].Controls[ctl]).SelectedItem.Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}

}

}
//
else if (dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()].GetType().ToString() == "System.Boolean")
{

//
for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

//
if (e.Cells[cells].Controls[ctl] is TextBox)
{

//
if ((bool)dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()])
{

lit.Text = ((TextBox)e.Cells[cells].Controls[ctl]).Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
//
if (e.Cells[cells].Controls[ctl] is DropDownList)
{

//
if ((bool)dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()])
{

lit.Text = ((DropDownList)e.Cells[cells].Controls[ctl]).SelectedItem.Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}

}

}

}
#endregion

}
cells++;

}

}

/// <summary>
/// Helper function Used To Make A Row or Column ReadOnly
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
/// <param name="row"></param>
/// <param name="dr"></param>
/// <param name="dc"></param>
/// <param name="columncount"></param>
private void SetRowColumnReadOnly(DataGridItem e, int cells, int row, DataRow dr, DataColumnCollection dc, int columncount)
{

//
DataTable dt = ((DataView)this.DataSource).Table;
//
DataColumn[] dcPrimaryKey;
//
dcPrimaryKey = dt.PrimaryKey;
#region Making The Whole Row As ReadOnly
if (dcPrimaryKey.Length == 1)
{

if (!object.Equals(dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow], null))
{

//
if (dr[dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow].ToString()].GetType().ToString() == "System.Boolean")
{

//
if ((bool)dr[dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyRow].ToString()])
{

//
if (!Object.Equals(dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyStyle], null))
{

e.CssClass = dcPrimaryKey[0].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnlyStyle].ToString();

}
else
{

e.CssClass = "CATDataGridReadOnlyItemStyle"

}
//
foreach (TableCell tc in e.Cells)
{

foreach (Control control in tc.Controls)
{

if (control is TextBox)
{

//
Literal lit = new Literal();
lit.Text = ((TextBox)control).Text;
tc.Controls.Remove(control);
tc.Controls.Add(lit);

}
else if (control is DropDownList)
{

//
Literal lit = new Literal();
lit.Text = ((DropDownList)control).SelectedItem.Text;
tc.Controls.Remove(control);
tc.Controls.Add(lit);

}
else if (control is CheckBox)
{

((CheckBox)control).Enabled = false;

}

}

}

}

}

}

}
#endregion
//
for (int i = 0; i < columncount; i++)
{

if (!dc[i].ReadOnly)
{

#region Setting A Particular Column As ReadOnly In EnLine Edit
//
if (!object.Equals(dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly], null))
{

if (dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].GetType().ToString() == "System.Boolean")
{

for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

//
if (e.Cells[cells].Controls[ctl] is TextBox)
{

//
if ((bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly])
{

Literal lit = new Literal();
//                                                                                                                                                                                                                                                                                                                                                                                                                                                        
lit.Text = ((TextBox)e.Cells[cells].Controls[ctl]).Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
//
if (e.Cells[cells].Controls[ctl] is DropDownList)
{

//
if ((bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly])
{

Literal lit = new Literal();
//
lit.Text = ((DropDownList)e.Cells[cells].Controls[ctl]).SelectedItem.Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
//
if (e.Cells[cells].Controls[ctl] is CheckBox)
{

((CheckBox)e.Cells[cells].Controls[ctl]).Enabled = (bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly];
break;

}

}

}
//
else if (dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()].GetType().ToString() == "System.Boolean")
{

//
for (int ctl = 0; ctl < e.Cells[cells].Controls.Count; ctl++)
{

//
if (e.Cells[cells].Controls[ctl] is TextBox)
{

//
if ((bool)dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()])
{

Literal lit = new Literal();
//
lit.Text = ((TextBox)e.Cells[cells].Controls[ctl]).Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
//
if (e.Cells[cells].Controls[ctl] is DropDownList)
{

//
if ((bool)dr[dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly].ToString()])
{

Literal lit = new Literal();
//
lit.Text = ((DropDownList)e.Cells[cells].Controls[ctl]).SelectedItem.Text;
e.Cells[cells].Controls.Add(lit);
e.Cells[cells].Controls.Remove(e.Cells[cells].Controls[ctl]);

}
break;

}
if (e.Cells[cells].Controls[ctl] is CheckBox)
{

((CheckBox)e.Cells[cells].Controls[ctl]).Enabled = (bool)dc[i].ExtendedProperties[EMSDataGridExtendedProperties.ReadOnly];
break;

}

}

}

}
#endregion

}
cells++;

}

}

/// <summary>
/// Helper function Used To Set The Selected Value Of The Added DropDown Box
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
private void SetDropDownSelectedValue(DataGridItemEventArgs e, int cells)
{

DataTable dt = ((DataView)this.DataSource).Table;
string strLiteralText = null;
int intRemove = -1;

for (int i = 0; i < dt.Columns.Count; i++)
{

if (!dt.Columns[i].ReadOnly)
{

//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dt.Columns[i].DataType.ToString())
{

case ("System.Guid"):

for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is Literal)
{

strLiteralText = ((Literal)e.Item.Cells[cells].Controls[ctl]).Text;
intRemove = ctl;

}
if (e.Item.Cells[cells].Controls[ctl] is DropDownList)
{

if (strLiteralText.Length > 0)
{

((DropDownList)e.Item.Cells[cells].Controls[ctl]).SelectedValue = strLiteralText;

}

}

}
if (intRemove > -1)
{

e.Item.Cells[cells].Controls.RemoveAt(intRemove);
intRemove = -1;

}
break;

}

}
cells++;

}

}
/// <summary>
/// Helper Function Used To Add Required Field Validator Control
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private RequiredFieldValidator RequiredFieldValidatorControl(string ID)
{

RequiredFieldValidator rfv = new RequiredFieldValidator();
rfv.CssClass = VALIDATORSTYLESHEET;
rfv.Display = ValidatorDisplay.Dynamic;
rfv.ControlToValidate = ID;

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.RequiredErrorMessage], null))
{

rfv.ErrorMessage = this.PropertyCollection[EMSDataGridExtendedProperties.RequiredErrorMessage].ToString();

}
else
{

rfv.ErrorMessage = REQUIREDERRORMESSAGE;

}

return rfv;

}
/// <summary>
/// Helper Function Used Add The Range Validator Control
/// </summary>
/// <param name="ID"></param>
/// <param name="ValDataType"></param>
/// <param name="MaxValue"></param>
/// <param name="MinValue"></param>
/// <returns></returns>
private RangeValidator RangeValidatorControl(string ID, ValidationDataType ValDataType, object MaxValue, object MinValue)
{

RangeValidator rv = new RangeValidator();
rv.CssClass = VALIDATORSTYLESHEET;
rv.Display = ValidatorDisplay.Dynamic;
rv.Type = ValDataType;
rv.ControlToValidate = ID;
if (!Object.Equals(MaxValue, null))
{

rv.MaximumValue = MaxValue.ToString();

}
else
{

rv.MaximumValue = this.DecimalMaxValue;

}
if (!Object.Equals(MinValue, null))
{

rv.MinimumValue = MinValue.ToString();

}
else
{

rv.MinimumValue = this.DecimalMinValue;

}

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.RequiredErrorMessage], null))
{

rv.ErrorMessage = PropertyCollection[EMSDataGridExtendedProperties.RequiredErrorMessage].ToString();

}
else
{

rv.ErrorMessage = RANGEERRORMESSAGE;

}

return rv;

}
/// <summary>
/// Helper Function To Populate The Drop Down Box
/// </summary>
/// <param name="ddl"></param>
/// <param name="strDefaultData"></param>
/// <param name="columnname"></param>
/// <param name="columncaption"></param>
/// <param name="PropertyCollection"></param>
private void BindDropDown(DropDownList ddl, string strDefaultData, string columnname, string columncaption, System.Data.PropertyCollection PropertyCollection)
{

//string strSelectedValue = string.Empty;

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.DataTable], null))
{

DataTable dt = (DataTable)PropertyCollection[EMSDataGridExtendedProperties.DataTable];

if (!object.Equals(dt.Rows[0][0], DBNull.Value))
{

DataRow dr = dt.NewRow();
dr[0] = DBNull.Value;
dr[1] = DROPDOWNDEFAULTTEXT;
dt.Rows.InsertAt(dr, 0);

}

ddl.DataSource = dt;

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.DataValueField], null))
{

ddl.DataValueField = PropertyCollection[EMSDataGridExtendedProperties.DataValueField].ToString();

}
else
{

throw new Exception(this.NamingContainer.ID + " Following Drop Down List Text Field Not Set For DataTable " + dt.TableName + " Column " + columnname + " i.e. " + columncaption);

}

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.DataTextField], null))
{

ddl.DataTextField = PropertyCollection[EMSDataGridExtendedProperties.DataTextField].ToString();

}
else
{

throw new Exception(this.NamingContainer.ID + " Following Drop Down List Text Field Not Set For DataTable " + dt.TableName + " Column " + columnname + " i.e. " + columncaption);

}
ddl.DataBind();
ddl.CssClass = DROPDOWNSTYLE;
ddl.SelectedValue = strDefaultData;

}
else
{

throw new Exception(this.NamingContainer.ID + " Data Table Not Set For The Drop Down Box " + columnname + " i.e. " + columncaption);

}

}
/// <summary>
/// Reads The Data From The DataItem And updates the bounded datasource
/// </summary>
public void EMSDataGridReadData()
{

//This function is used to update all the Rows from the DataGrid
this.ReadDataGridData(this.EditItemIndex);

}
/// <summary>
/// Reads The Data From The DataItem And updates the bounded datasource
/// </summary>
/// <param name="row"></param>
private void ReadDataGridData(int row)
{

object DBValue;
//Update The DataSource With Latest Information
DataTable dt = ((DataView)this.DataSource).Table;
int Cell, BaseCell;
int Item;
if (object.Equals(dt, null)) return;

if (row == -1)
{

row = 0;
BaseCell = 1;
Cell = BaseCell;
Item = 0;

}
else
{

BaseCell = 2;
Cell = BaseCell;
Item = row;

}

//foreach(DataGridItem datagridItem in this.Items)
for (; Item < this.Items.Count; Item++)
{

DataRow dr = dt.Rows[row];
row++;
for (int col = 0; col < dt.Columns.Count; col++)
{

if (!dt.Columns[col].ReadOnly)
{

switch (dt.Columns[col].DataType.ToString())
{

case ("System.Guid"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is DropDownList)
{

DBValue = SetValidDBValue(((DropDownList)this.Items[Item].Cells[Cell].Controls[ctl]).SelectedValue);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Not Accept Null Values||");

}
else
{

dr[col] = DBValue;

}
break;

}

}

}
break;

case ("System.String"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

string strData = null;
for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

}
else if (this.Items[Item].Cells[Cell].Controls[ctl] is Literal)
{

DBValue = SetValidDBValue(((Literal)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

}
else if (this.Items[Item].Cells[Cell].Controls[ctl] is DropDownList)
{

DBValue = SetValidDBValue(((DropDownList)this.Items[Item].Cells[Cell].Controls[ctl]).SelectedValue);

}
else
{

DBValue = null;

}
if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

if (!object.Equals(dt.Columns[col].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControl], null))
{

if (!object.Equals(DBValue, null))
{

if (object.Equals(strData, null))
{

strData = DBValue.ToString();

}
else
{

strData = strData + dt.Columns[col].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControlDelimiter].ToString() + DBValue.ToString();

}

}

}
else
{

dr[col] = DBValue;
break;

}

}

}
if (!object.Equals(dt.Columns[col].ExtendedProperties[EMSDataGridExtendedProperties.MultipleControl], null))
{

dr[col] = strData;

}

}
break;

case ("System.Boolean"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is CheckBox)
{

dr[col] = ((CheckBox)this.Items[Item].Cells[Cell].Controls[ctl]).Checked;

}

}

}
break;

case ("System.Int64"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.Decimal"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.Double"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.Int32"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.Int16"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.Byte"):

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}
break;

case ("System.DateTime"):

if (!object.Equals(dt.Columns[col].ExtendedProperties[EMSDataGridExtendedProperties.ConcurrencyState], null))
{

if (!object.Equals(this.ViewState[HIDDENCONCURRENCYSTATE], null))
{

dr[col] = this.DateConvertorConcurrency(this.ViewState[HIDDENCONCURRENCYSTATE].ToString());
this.ViewState[HIDDENCONCURRENCYSTATE] = null;

}

}
else
{

if (this.Items[Item].Cells[Cell].Controls.Count > 0)
{

for (int ctl = 0; ctl < this.Items[Item].Cells[Cell].Controls.Count; ctl++)
{

if (this.Items[Item].Cells[Cell].Controls[ctl] is TextBox)
{

DBValue = this.GetValidDate(this.GetValidValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text));
//DBValue = SetValidDBValue(((TextBox)this.Items[Item].Cells[Cell].Controls[ctl]).Text);

if (!dt.Columns[col].AllowDBNull && object.Equals(DBValue, DBNull.Value))
{

throw new Exception("||" + dt.Columns[col].ColumnName + " Does Accept Null Values||");

}
else
{

dr[col] = DBValue;

}

}

}

}

}
break;

}

}
//Incrementing The Cell
if (this.EditItemIndex == -1)
{

if (Cell == dt.Columns.Count)
{

Cell = BaseCell;

}
else
{

Cell++;

}

}
else
{

Cell++;

}

}
if (this.EditItemIndex != -1)
{

break;

}

}

}
/// <summary>
/// Adds The DataControl For The DataItem If The DataType Is DataTime
/// </summary>
/// <param name="e"></param>
/// <param name="cells"></param>
private void AddDateControl(DataGridItemEventArgs e, int cells)
{

DataTable dt = ((DataView)this.DataSource).Table;

for (int i = 0; i < dt.Columns.Count; i++)
{

string strCellName = this.NamingContainer.ID + "_" + this.ID + "_row" + e.Item.Cells.Count + "_ctr" + dt.Columns[i].Ordinal.ToString();

//Putting The Range Validator To Handle Arthi OverFlow Error
switch (dt.Columns[i].DataType.ToString())
{

case ("System.DateTime"):

TextBox textbox = new TextBox();
for (int ctl = 0; ctl < e.Item.Cells[cells].Controls.Count; ctl++)
{

if (e.Item.Cells[cells].Controls[ctl] is TextBox)
{

if (object.Equals(((TextBox)e.Item.Cells[cells].Controls[ctl]).ID, null))
{

((TextBox)e.Item.Cells[cells].Controls[ctl]).ID = strCellName;

}
//Storing The Textbox Information In ElipseTextBox
textbox = ((TextBox)e.Item.Cells[cells].Controls[ctl]);

if (!object.Equals(textbox, null))
{

e.Item.Cells[cells].VerticalAlign = VerticalAlign.Top;
Literal literal = new Literal();
literal.Text = "&nbsp;"
e.Item.Cells[cells].Controls.Add(literal);
ImageButton ibtnCalendarStartDate = new ImageButton();
ibtnCalendarStartDate.ImageUrl = this.ResolveUrl(System.Configuration.ConfigurationSettings.AppSettings["CalenderImage"]);
ibtnCalendarStartDate.Attributes.Add("onclick", "getCalendar(document.forms[0].item(\"" + textbox.ClientID + "\"), '" + this.ResolveUrl(System.Configuration.ConfigurationSettings.AppSettings["CalenderControl"]) + "'); return false;");
e.Item.Cells[cells].Controls.Add(ibtnCalendarStartDate);

}

}
else if (e.Item.Cells[cells].Controls[ctl] is HtmlInputButton && !object.Equals(textbox, null))
{

((HtmlInputButton)e.Item.Cells[cells].Controls[ctl]).Attributes.Add("onclick", this.NamingContainer.ID + this.ID + dt.Columns[i].ColumnName + "(document.forms[0]." + textbox.ClientID + "," + (e.Item.ItemIndex + 1) + "," + cells + ")");

}

}
break;

}
cells++;

}

}
/// <summary>
/// Adds The Functionality for Each DataItem To Maintain The checkbox state across pages
/// </summary>
/// <param name="e"></param>
private void AddCheckBoxState(DataGridItemEventArgs e)
{

int intRowCount = 0;
int intCurrentPageRowCount = 0;
string strCheckBoxState = string.Empty;
string strCheckBoxStateCount = string.Empty;
HtmlInputHidden hidCheckBoxState = new HtmlInputHidden();
//                                                
//This Part of Code Is Used For Mainting Checkbox State Across Pages                                    
if (this.blnCheckBoxState)
{

if (!object.Equals(this.ViewState[this.strHiddenCheckBoxState], null))
{

//Creating The Instance Of The DataSet
this.dsCheckBoxState = new DataSet();
//Creating The Instance of StringReader Class
StringReader sr = new StringReader(this.ViewState[this.strHiddenCheckBoxState].ToString());
//Loading The DataSet From StringReader Class
this.dsCheckBoxState.ReadXml(sr);

}
//
switch (e.Item.ItemType)
{

case ListItemType.Footer:

break;

case ListItemType.Header:

//this.strHiddenCheckBoxState = e.Item.Cells[this.intCheckBoxColumn].Controls[0].ClientID.Replace("__", ":_");
CheckBox chkHeader = (CheckBox)e.Item.Cells[this.intCheckBoxColumn].Controls[0];
//
//chkHeader.ID = this.ID + e.Item.ItemIndex + e.Item.Cells[this.intCheckBoxColumn];
//
chkHeader.Attributes.Add("onclick", "EMSGridCheckAll(document.all." + this.ClientID + ", document.forms[0]." + chkHeader.ClientID + ");EMSGridCheckboxState(document.all." + this.ClientID + ", " + this.CurrentPageIndex + ", '" + this.strHiddenCheckBoxState + "', '" + this.strNoOfRecordsCheckBoxState + "', '" + this.strCheckBoxStateCount + "', document.forms[0].item(\"" + chkHeader.ClientID + "\")," + this.PageSize + ",'" + this.strHiddenPreviousPage + "');");
//
strHeaderCheckBoxId = chkHeader.ClientID;

if (!this.blnClearGridStatus)
{

//
//Make The Previous Pages Checkbox Checked If Records Exists For Them
if (!object.Equals(this.dsCheckBoxState, null))
{

//
if (this.dsCheckBoxState.Tables.Count == 1)
{

//
if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

DataRow[] dr = this.dsCheckBoxState.Tables[0].Select("PageNumber = " + this.CurrentPageIndex);
//                                        
if ((dr.Length) == this.PageSize)
{

chkHeader.Checked = true;

}
else
{

chkHeader.Checked = false;

}

}

}

}
//
if (!object.Equals(HttpContext.Current.Request[this.strNoOfRecordsCheckBoxState], null))
{

if (!object.Equals(this.dsCheckBoxState, null))
{

if (this.dsCheckBoxState.Tables.Count > 0)
{

if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

//Filtering The DataTable Based on DataRows
DataRow[] dr = dsCheckBoxState.Tables[0].Select("PageNumber" + "='" + this.CurrentPageIndex + "'");
//                                                                                                                                                                                                                                                                                                                                                                                                                                                        
intCurrentPageRowCount = dr.Length;
//
strCheckBoxState = intCurrentPageRowCount.ToString();

}

}

}

}
//
if (!object.Equals(this.dsCheckBoxState, null))
{

if (!object.Equals(HttpContext.Current.Request[this.strCheckBoxStateCount], null))
{

if (this.dsCheckBoxState.Tables.Count > 0)
{

if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

//
intRowCount = this.dsCheckBoxState.Tables[0].Rows.Count - intCurrentPageRowCount;
//
strCheckBoxStateCount = intRowCount.ToString();

}

}

}

}

}
//Adding The Hidden Control To The Page
HtmlInputHidden hid = new HtmlInputHidden();
hid.ID = HIDDENCHECKSTATE;
//
this.Controls.Add(hid);
//Adding The Hidden Control To The Page
hidCheckBoxState.ID = HIDDENNORECORDSCHECKBOXSTATE;
hidCheckBoxState.Value = strCheckBoxState;
//
this.Controls.Add(hidCheckBoxState);
//Adding the Hidden Control to The page
HtmlInputHidden hidCheckBoxStateCount = new HtmlInputHidden();
hidCheckBoxStateCount.ID = HIDDENCHECKBOXSTATECOUNT;
hidCheckBoxStateCount.Value = strCheckBoxStateCount;
//
this.Controls.Add(hidCheckBoxStateCount);
//
//this.Controls.Add(hidCheckBoxState);

HtmlInputHidden hidPreviousPage = new HtmlInputHidden();
hidPreviousPage.ID = HIDDENPREVIOUSPAGE;
//
this.Controls.Add(hidPreviousPage);
break;

case ListItemType.AlternatingItem:

goto case ListItemType.Item;

case ListItemType.Item:

if (e.Item.Cells[this.intCheckBoxColumn].Controls[0] is CheckBox)
{

//
CheckBox chk = (CheckBox)e.Item.Cells[this.intCheckBoxColumn].Controls[0];
//
chk.Enabled = true;
chk.Checked = false;
chk.ID = this.ID + e.Item.ItemIndex + this.intCheckBoxColumn;

if (!this.blnClearGridStatus)
{

if (!object.Equals(HttpContext.Current.Request[this.strNoOfRecordsCheckBoxState], null))
{

if (!object.Equals(this.dsCheckBoxState, null))
{

if (this.dsCheckBoxState.Tables.Count > 0)
{

if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

//Filtering The DataTable Based on DataRows
DataRow[] dr = dsCheckBoxState.Tables[0].Select("PageNumber" + "='" + this.CurrentPageIndex + "'");
//                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
intCurrentPageRowCount = dr.Length;
//
hidCheckBoxState.Value = intCurrentPageRowCount.ToString();

}
else
{

hidCheckBoxState.Value = string.Empty;

}

}
else
{

hidCheckBoxState.Value = string.Empty;

}

}
else
{

hidCheckBoxState.Value = string.Empty;

}

}

//Make The Previous Pages Checkbox Checked If Records Exists For Them
if (!object.Equals(this.dsCheckBoxState, null))
{

//
if (this.dsCheckBoxState.Tables.Count == 1)
{

//
if (this.dsCheckBoxState.Tables[0].Rows.Count > 0)
{

DataRow[] dr = this.dsCheckBoxState.Tables[0].Select("Id ='" + e.Item.Attributes["ID"] + "'");
//                                            
if (dr.Length == 1)
{

chk.Checked = true;

}
else
{

chk.Checked = false;

}

}

}

}

}
//                                                                                                                                                                                                    
chk.Attributes.Add("onclick", "EMSGridCheckboxState(document.all." + this.ClientID + ", " + this.CurrentPageIndex + ", '" + this.strHiddenCheckBoxState + "', '" + this.strNoOfRecordsCheckBoxState + "', '" + this.strCheckBoxStateCount + "', document.forms[0].item(\"" + this.strHeaderCheckBoxId + "\"), " + this.PageSize + ",'" + this.strHiddenPreviousPage + "');");

}
break;

}

}

}
/// <summary>
/// Helper Function Adds The Client Side Functionality For Checkbox State
/// </summary>
private void AddClientSideScript()
{

StringBuilder sbCheckAll = new StringBuilder();
sbCheckAll.Append("<script>");
sbCheckAll.Append("function EMSGridCheckAll(EmsGridId, HeaderCheckBox)");
sbCheckAll.Append("{");
sbCheckAll.Append("for(var row = 1; row < EmsGridId.rows.length; row++)");
sbCheckAll.Append("{");
sbCheckAll.Append("for(var col=0; col < EmsGridId.rows[row].cells.length; col++)");
sbCheckAll.Append("{");
sbCheckAll.Append("for(cells = 0; cells < EmsGridId.rows[row].cells(col).children.length; cells++)");
sbCheckAll.Append("{");
sbCheckAll.Append("if(EmsGridId.rows[row].cells(col).children[cells].type == \"checkbox\")");
sbCheckAll.Append("{");
sbCheckAll.Append("EmsGridId.rows[row].cells(col).children[cells].checked = HeaderCheckBox.checked"); ;
sbCheckAll.Append("}");
sbCheckAll.Append("break;");
sbCheckAll.Append("}");
sbCheckAll.Append("}");
sbCheckAll.Append("}");
sbCheckAll.Append("}");
sbCheckAll.Append("</script>");

StringBuilder sbCheckBoxState = new StringBuilder();

sbCheckBoxState.Append("<script>");
//Adding The Function Attribute
sbCheckBoxState.Append("function EMSGridCheckboxState(EmsGridId, CurrentPageIndex, hidCheckBoxState, hidNoOfRecordsCheckBoxState, hidCheckRecordsCount, HeaderCheckBox, PageSize, PreviousPage)");
//Opening The function Braces
sbCheckBoxState.Append("{");
//Validating If The DataGrid Exisits
sbCheckBoxState.Append("if(EmsGridId == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid DataGrid Name');");
sbCheckBoxState.Append("return");
sbCheckBoxState.Append("}");
//Validating If The CurrentPageIndex Exisits
sbCheckBoxState.Append("if(CurrentPageIndex == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid Page Index');");
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
//Converting hidCheckBoxState To An Object
sbCheckBoxState.Append("hidCheckBoxState = eval('document.forms[0].item(\"' + hidCheckBoxState +  '\")');");
//Converting hidNoOfRecordsCheckBoxState To An Object
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState = eval('document.forms[0].item(\"' + hidNoOfRecordsCheckBoxState +  '\")');");
//PreviousPage
sbCheckBoxState.Append("PreviousPage = eval('document.forms[0].item(\"' + PreviousPage +  '\")');");
//
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState.value = 0;");
//
sbCheckBoxState.Append("hidCheckRecordsCount = eval('document.forms[0].item(\"' + hidCheckRecordsCount +  '\")');");
//Validating if the converted hidCheckBoxState is an object
sbCheckBoxState.Append("if(hidCheckBoxState == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid Check Box State Control');");
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
//Validating if the converted hidNoOfRecordsCheckBoxState is an object
sbCheckBoxState.Append("if(hidNoOfRecordsCheckBoxState == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid No Of Records Check Box State Control');");
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
//Validating if the converted hidNoOfRecordsCheckBoxState is an object
sbCheckBoxState.Append("if(hidCheckRecordsCount == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid Check Records Count Control');");
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
//Validating if the PreviousPage Control Exists
sbCheckBoxState.Append("if(PreviousPage == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("alert('Invalid Previous Page Control');");
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
//Validating if the converted hidCheckBoxState's value is null
sbCheckBoxState.Append("if(hidCheckBoxState.value == \"\")");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("var data = CurrentPageIndex;");
sbCheckBoxState.Append("var pkdata;");
sbCheckBoxState.Append("for(var row = 1; row < EmsGridId.rows.length; row++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("for(var col=0; col < EmsGridId.rows[row].cells.length; col++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("for(cells = 0; cells < EmsGridId.rows[row].cells(col).children.length; cells++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].cells(col).children[cells].type == \"checkbox\")");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].cells(col).children[cells].checked)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(pkdata == null)");
sbCheckBoxState.Append("{");
//sbCheckBoxState.Append("alert(EmsGridId.rows[row].id.length);");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id.length > 0)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pkdata = EmsGridId.rows[row].id;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
//sbCheckBoxState.Append("alert(EmsGridId.rows[row].id.length);");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id.length > 0)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pkdata = pkdata + \"^\" + EmsGridId.rows[row].id;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("break;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("if(pkdata == null)");
sbCheckBoxState.Append("{");
//
sbCheckBoxState.Append("PreviousPage.value = CurrentPageIndex;");
//
sbCheckBoxState.Append("return;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
//
sbCheckBoxState.Append("PreviousPage.value = CurrentPageIndex;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("hidCheckBoxState.value = data +\"~\"+ pkdata;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pagespliter = hidCheckBoxState.value.split(\"|\");");
sbCheckBoxState.Append("var data;");
sbCheckBoxState.Append("for(var page = 0;   page++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pageIndex   = pagespliter[page].split(\"~\");");
sbCheckBoxState.Append("if(pageIndex[0] == CurrentPageIndex)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("for(var row = 1; row < EmsGridId.rows.length; row++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("for(var col=0; col < EmsGridId.rows[row].cells.length; col++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("for(cells = 0; cells < EmsGridId.rows[row].cells(col).children.length; cells++)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].cells(col).children[cells].type == \"checkbox\")");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].cells(col).children[cells].checked)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(data == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id != \"\")");
sbCheckBoxState.Append("{");
//sbCheckBoxState.Append("alert(EmsGridId.rows[row].id.length);");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id.length > 0)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("data = EmsGridId.rows[row].id;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id != \"\")");
sbCheckBoxState.Append("{");
//sbCheckBoxState.Append("alert(EmsGridId.rows[row].id.length);");
sbCheckBoxState.Append("if(EmsGridId.rows[row].id.length > 0)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("data = data + \"^\" + EmsGridId.rows[row].id;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("break;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("if(data == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pagespliter[page] = \"\"");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("pageIndex[1] = data;");
sbCheckBoxState.Append("pagespliter[page] = pageIndex.join(\"~\");");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("break;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("hidCheckBoxState.value = pagespliter.join(\"|\");");
//
sbCheckBoxState.Append("PreviousPage.value = CurrentPageIndex;");
sbCheckBoxState.Append("}");
//Adding The Number Of Rows Checked Across EMS
sbCheckBoxState.Append("var noofrows = hidCheckBoxState.value;");
sbCheckBoxState.Append("var noofrows = noofrows.split(\"~\");");
sbCheckBoxState.Append("if(noofrows.length == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState.value = 0;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("if(noofrows.length == 2)");
sbCheckBoxState.Append("{");
//sbCheckBoxState.Append("alert(noofrows[1]);");
sbCheckBoxState.Append("noofrows[1] = noofrows[1].split(\"^\");");
sbCheckBoxState.Append("if(noofrows[1].length == null)");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState.value = 0;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState.value = noofrows[1].length;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("hidNoOfRecordsCheckBoxState.value = 0;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("}");
//sbCheckBoxState.Append("if(parseInt(hidNoOfRecordsCheckBoxState.value) == 20)");
//sbCheckBoxState.Append("{");
//            sbCheckBoxState.Append("PageSize = PageSize + 1");
//sbCheckBoxState.Append("}");
//sbCheckBoxState.Append("alert(PageSize); alert(hidNoOfRecordsCheckBoxState.value);alert(EmsGridId.rows.length);");
sbCheckBoxState.Append("if((PageSize) == parseInt(hidNoOfRecordsCheckBoxState.value))");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("HeaderCheckBox.checked = true;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else if((EmsGridId.rows.length - 3) == parseInt(hidNoOfRecordsCheckBoxState.value))");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("HeaderCheckBox.checked = true;");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("else");
sbCheckBoxState.Append("{");
sbCheckBoxState.Append("HeaderCheckBox.checked = false;");
sbCheckBoxState.Append("}");
//sbCheckBoxState.Append("alert('Current Records =' + hidNoOfRecordsCheckBoxState.value);");
//sbCheckBoxState.Append("alert('Total Records = ' + hidCheckRecordsCount.value);");
//Closing The function Braces
//sbCheckBoxState.Append("alert(PreviousPage.value);");
//sbCheckBoxState.Append("alert('Hello');");
sbCheckBoxState.Append("}");
sbCheckBoxState.Append("</script>");
this.Page.RegisterClientScriptBlock("sbCheckAll", sbCheckAll.ToString());
this.Page.RegisterClientScriptBlock("sbCheckBoxState", sbCheckBoxState.ToString());

}

#endregion

}
/// <summary>
/// Implementing the DataGrid Template Class
/// </summary>
public class DataGridTemplate : ITemplate
{

#region Member Variable
/// <summary>
/// ListItemType Variable Declaration
/// </summary>
ListItemType listitemtype;
/// <summary>
/// columnnumber Variable Declaration
/// </summary>
int columnnumber;
/// <summary>
/// columnname Variable Declaration
/// </summary>
string columnname;
/// <summary>
/// columncaption Variable Declaration
/// </summary>
string columncaption;
/// <summary>
/// columntype Variable Declaration
/// </summary>
string columntype;
/// <summary>
/// columnmaxlength Variable Declaration
/// </summary>
int columnmaxlength;
/// <summary>
/// allowsort Variable Declaration
/// </summary>
bool allowsort;
/// <summary>
/// headercssclass Variable Declaration
/// </summary>
string headercssclass;
/// <summary>
/// blnFullEditable Variable Declaration
/// </summary>
bool blnFullEditable;
/// <summary>
/// blnReadOnly Variable Declaration
/// </summary>
bool blnReadOnly;
/// <summary>
/// blnAllowDBNull Variable Declaration
/// </summary>
bool blnAllowDBNull;
/// <summary>
/// blnEnhanceEdit Variable Declaration
/// </summary>
bool blnEnhanceEdit;
/// <summary>
///  cellname Variable Declaration
/// </summary>
string cellname;
/// <summary>
/// guid Varaible Declaration
/// </summary>
string guid;
/// <summary>
/// PropertyCollection Variable Declaration
/// </summary>
System.Data.PropertyCollection PropertyCollection;
/// <summary>
/// RequiredFieldValidator style sheet declaration
/// </summary>
const string VALIDATORSTYLESHEET = "RequiredFieldValidator"
/// <summary>
/// RangeValidator Error Message
/// </summary>
const string RANGEERRORMESSAGE = "<BR><BLINK>||Invalid Data||</BLINK>"
/// <summary>
/// Required Field Error Message
/// </summary>
const string REQUIREDERRORMESSAGE = "<BR><BLINK>||Required||</BLINK>"
/// <summary>
/// DropDown List Default Value
/// </summary>
const string DROPDOWNDEFAULTTEXT = "||------SELECT------||"
/// <summary>
/// ReadOnly TextBox Style
/// </summary>
const string READONLYTEXTBOXSTYLE = "ReadOnlyTextBoxStyle"
/// <summary>
/// Range Validator For Decimal field Max Value
/// </summary>
string DecimalMaxValue = System.Configuration.ConfigurationSettings.AppSettings["DecimalMaxValue"];
/// <summary>
/// Range Validator For Decimal field Min Value
/// </summary>
string DecimalMinValue = System.Configuration.ConfigurationSettings.AppSettings["DecimalMinValue"];
/// <summary>
/// CheckBoxState Variable Declaration
/// </summary>
bool blnCheckBoxState;
/// <summary>
/// CheckBox Column Variable Declaration
/// </summary>
int intCheckBoxColumn;
#endregion
#region Public Method Of This Class
/// <summary>
/// contractor
/// </summary>
/// <param name="listItemType">The Type Of Item To Be Added</param>
/// <param name="columnName">Name Of The Column</param>
/// <param name="columnCaption">Column Heading</param>
/// <param name="columnNumber">Column Number</param>
/// <param name="columnType">DataType Of The Column</param>
/// <param name="allowSort">If Sorting Is Enabled</param>
/// <param name="headerCssClass">Style Sheet Class</param>
/// <param name="blnFullEditable">If Fully Editable</param>
/// <param name="blnReadOnly"></param>
/// <param name="PropertyCollection"></param>
/// <param name="AllowDBNull"></param>
/// <param name="blnEnhanceEdit"></param>
/// <param name="strcellname"></param>
/// <param name="columnmaxlength"></param>
/// <param name="blnCheckBoxState"></param>
/// <param name="intCheckBoxColumn"></param>
public DataGridTemplate(ListItemType listItemType, string columnName, string columnCaption, int columnNumber, string columnType, bool allowSort, string headerCssClass, bool blnFullEditable, bool blnReadOnly, System.Data.PropertyCollection PropertyCollection, bool AllowDBNull, bool blnEnhanceEdit, string strcellname, int columnmaxlength, bool blnCheckBoxState, int intCheckBoxColumn)
{

//set the list item type
this.listitemtype = listItemType;
//set the column number
this.columnnumber = columnNumber;
//set the column name
this.columnname = columnName;
//set the column caption
this.columncaption = columnCaption;
//set the column type
this.columntype = columnType;
//set the sort property
this.allowsort = allowSort;
//set the header css class
this.headercssclass = headerCssClass;
//set the FullEditable
this.blnFullEditable = blnFullEditable;
//Used Is A Column Is ReadOnly
this.blnReadOnly = blnReadOnly;
//Any Other Specific Data Column Collection
this.PropertyCollection = PropertyCollection;
//Puts A Required Field Validator Control
this.blnAllowDBNull = AllowDBNull;
//Puts The Appropriate Validator Controls
this.blnEnhanceEdit = blnEnhanceEdit;
//Giving a unique name to a control
this.cellname = strcellname;
//Maxlength Of The Column
this.columnmaxlength = columnmaxlength;
//CheckBoxState
this.blnCheckBoxState = blnCheckBoxState;
this.intCheckBoxColumn = intCheckBoxColumn;

}
/// <summary>
/// implement the InstantiateIn method
/// </summary>
/// <param name="container"></param>
public void InstantiateIn(System.Web.UI.Control container)
{

Literal lc = new Literal();
//for listitem type, set the template style
#region Setting Template Style
switch (listitemtype)
{

//set the header style
case ListItemType.Header:

if (this.blnCheckBoxState)
{

switch (columntype)
{

case "System.Boolean":

if (this.blnCheckBoxState)
{

CheckBox chkHeader = new CheckBox();
container.Controls.Add(chkHeader);

}
else
{

if (!allowsort)
{

lc.Text = "<B>" + columncaption + "</B>"
container.Controls.Add(lc);

}
else
{

LinkButton linkButton = new LinkButton();
linkButton.Text = columncaption;
linkButton.CommandName = "sort"
linkButton.CommandArgument = columnname;
linkButton.CssClass = headercssclass;
container.Controls.Add(linkButton);
//TableCell x = new TableCell();

}

}
break;

default:

if (!allowsort)
{

lc.Text = "<B>" + columncaption + "</B>"
container.Controls.Add(lc);

}
else
{

LinkButton linkButton = new LinkButton();
linkButton.Text = columncaption;
linkButton.CommandName = "sort"
linkButton.CommandArgument = columnname;
linkButton.CssClass = headercssclass;
container.Controls.Add(linkButton);
//TableCell x = new TableCell();

}
break;

}

}
else
{

if (!allowsort)
{

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CustomColumnHeading], null))
{

lc.Text = "||<B>" + PropertyCollection[EMSDataGridExtendedProperties.CustomColumnHeading].ToString() + "</B>||"

}
else
{

lc.Text = "<B>" + columncaption + "</B>"

}
container.Controls.Add(lc);

}
else
{

LinkButton linkButton = new LinkButton();

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CustomColumnHeading], null))
{

linkButton.Text = "||<B>" + PropertyCollection[EMSDataGridExtendedProperties.CustomColumnHeading].ToString() + "</B>||"

}
else
{

linkButton.Text = "<B>" + columncaption + "</B>"

}

linkButton.CommandName = "sort"
linkButton.CommandArgument = columnname;
linkButton.CssClass = headercssclass;
container.Controls.Add(linkButton);
//TableCell x = new TableCell();

}

}
break;

//set the item style
case ListItemType.Item:

if (this.blnFullEditable && !this.blnReadOnly)
{

#region FullyEditable
//check the column type and set the control based on the datatype
switch (columntype)
{

case "System.Guid": //UniqueIdentifier

//Bind Data
lc.DataBinding += new EventHandler(lc_SelectedDropDown);
container.Controls.Add(lc);
DropDownList dp = new DropDownList();
this.BindDropDown(dp);
dp.SelectedValue = lc.Text;
//dp.PreRender += new EventHandler(ddl_SelectedDropDown);
container.Controls.Add(dp);
break;

case "System.String": //varchar

TextBox tb = new TextBox();
//tb.ID = this.cellname;
if (this.columnmaxlength > 0)
{

tb.MaxLength = this.columnmaxlength;

}
tb.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}

container.Controls.Add(tb);
//Adding The Elipse Button If Required
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.ElipseButton], null))
{

HtmlInputButton elipseButton = new HtmlInputButton("Button");
elipseButton.Value = "..."
elipseButton.Attributes.Add("Style", "CustomButtonStyle");
elipseButton.Attributes.Add("title", "||Click Here To Open Popup||");
container.Controls.Add(elipseButton);

}
break;

case "System.Boolean": //Bit

CheckBox cb = new CheckBox();
cb.DataBinding += new EventHandler(cb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

cb.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

cb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(cb);
break;

case "System.Int64": //BigInt

TextBox tb1 = new TextBox();
tb1.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb1.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb1.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb1);
break;

case "System.Decimal": //Decimal, Money, Numeric, SmallMoney

TextBox tb2 = new TextBox();
tb2.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb2.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb2.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
//Adding The TextBox
container.Controls.Add(tb2);
break;

case "System.Double": //Float

TextBox tb3 = new TextBox();
tb3.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb3.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb3.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb3);
break;

case "System.Int32": //Int

TextBox tb4 = new TextBox();
//tb4.ID = this.cellname;
tb4.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb4.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb4.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb4);
break;

case "System.Int16": //smallInt

TextBox tb5 = new TextBox();
tb5.DataBinding += new EventHandler(tb_DataBinding);

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb5.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}

if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb5.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb5);
break;

case "System.Byte": //tinyInt

TextBox tb6 = new TextBox();
tb6.DataBinding += new EventHandler(tb_DataBinding);
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb6.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb6.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb6);
break;

case "System.DateTime": //DateTime

TextBox tb7 = new TextBox();
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb7.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
else
{

tb7.Width = 100;

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb7.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
else
{

tb7.CssClass = READONLYTEXTBOXSTYLE;
tb7.ReadOnly = true;

}
tb7.DataBinding += new EventHandler(tb7_DataBinding);
container.Controls.Add(tb7);
break;

}
#endregion

}
else
{

#region NonEditable
switch (columntype)
{

case "System.Boolean":

CheckBox cb = new CheckBox();
cb.DataBinding += new EventHandler(cb_DataBinding);
cb.Enabled = false;
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

cb.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

cb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(cb);
break;

case "System.Guid":

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataTable], null))
{

lc.DataBinding += new EventHandler(lc_SearchDataBinding);

}
else
{

lc.DataBinding += new EventHandler(lc_DataBinding);

}
container.Controls.Add(lc);
break;

default:

lc.DataBinding += new EventHandler(lc_DataBinding);
container.Controls.Add(lc);
break;

}
#endregion

}
break;

//set the edit item style
case ListItemType.EditItem:

//Validates if the  DB Constraints Need To Be Apply
if (this.blnEnhanceEdit && !this.blnReadOnly)
{

#region Inline Edit Enhanced
//check the column type and set the control based on the datatype
switch (columntype)
{

case "System.Guid": //UniqueIdentifier

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataTable], null))
{

//Bind Data
lc.DataBinding += new EventHandler(lc_SelectedDropDown);
container.Controls.Add(lc);
DropDownList dp = new DropDownList();
container.Controls.Add(dp);

}
break;

case "System.String": //varchar

TextBox tb = new TextBox();
tb.MaxLength = this.columnmaxlength;
tb.DataBinding += new EventHandler(tb_DataBinding);

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb);
//Adding The Elipse Button If Required
if (!object.Equals(PropertyCollection[EMSDataGridExtendedProperties.ElipseButton], null))
{

HtmlInputButton elipseButton = new HtmlInputButton("Button");
elipseButton.Value = "..."
elipseButton.Attributes.Add("Style", "CustomButtonStyle");
elipseButton.Attributes.Add("title", "||Click Here To Open Popup||");
container.Controls.Add(elipseButton);

}
break;

case "System.Boolean": //Bit

CheckBox cb = new CheckBox();
cb.DataBinding += new EventHandler(cb_DataBinding);
//cb.ID = this.cellname;
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

cb.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

cb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(cb);
break;

case "System.Int64": //BigInt

TextBox tb1 = new TextBox();
//tb1.ID = this.cellname;
tb1.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb1.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb1.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb1);
break;

case "System.Decimal": //Decimal, Money, Numeric, SmallMoney

TextBox tb2 = new TextBox();
tb2.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb2.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb2.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb2);
break;

case "System.Double": //Float

TextBox tb3 = new TextBox();
tb3.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb3.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb3.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb3);
break;

case "System.Int32": //Int

TextBox tb4 = new TextBox();
tb4.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb4.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb4.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb4);
break;

case "System.Int16": //smallInt

TextBox tb5 = new TextBox();
tb5.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb5.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb5.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb5);
break;

case "System.Byte": //tinyInt

TextBox tb6 = new TextBox();
tb6.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb6.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb6.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
container.Controls.Add(tb6);
break;

case "System.DateTime": //DateTime

TextBox tb7 = new TextBox();
tb7.DataBinding += new EventHandler(tb_DataBinding);
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.Width], null))
{

tb7.Width = (int)PropertyCollection[EMSDataGridExtendedProperties.Width];

}
else
{

tb7.Width = 100;

}
if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.CssClass], null))
{

tb7.CssClass = PropertyCollection[EMSDataGridExtendedProperties.CssClass].ToString();

}
else
{

tb7.CssClass = READONLYTEXTBOXSTYLE;
tb7.ReadOnly = true;

}

container.Controls.Add(tb7);
break;

}
#endregion

}
else
{

#region Inline Edit
//check the column type and set the control based on the datatype
switch (columntype)
{

case "System.Guid": //UniqueIdentifier

DropDownList dp = new DropDownList();
//Bind Data
container.Controls.Add(dp);
break;

case "System.String": //varchar

TextBox tb = new TextBox();
tb.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb);
break;

case "System.Boolean": //Bit

CheckBox cb = new CheckBox();
cb.DataBinding += new EventHandler(cb_DataBinding);
container.Controls.Add(cb);
break;

case "System.Int64": //BigInt

TextBox tb1 = new TextBox();
tb1.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb1);
break;

case "System.Decimal": //Decimal, Money, Numeric, SmallMoney

TextBox tb2 = new TextBox();
tb2.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb2);
break;

case "System.Double": //Float

TextBox tb3 = new TextBox();
tb3.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb3);
break;

case "System.Int32": //Int

TextBox tb4 = new TextBox();
tb4.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb4);
break;

case "System.Int16": //smallInt

TextBox tb5 = new TextBox();
tb5.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb5);
break;

case "System.Byte": //tinyInt

TextBox tb6 = new TextBox();
tb6.DataBinding += new EventHandler(tb_DataBinding);
container.Controls.Add(tb6);
break;

case "System.DateTime": //DateTime

break;

}
#endregion

}
break;

//set the footer style
case ListItemType.Footer:

container.Controls.Add(lc);
break;

}
#endregion

}

#endregion
#region Events Raised By The InstantiateIn Methods Implementation
/// <summary>
/// Label Binding Data Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lc_DataBinding(object sender, EventArgs e)
{

if (columnnumber != -1)
{

Literal literal = (Literal)sender;
DataRowView container = (DataRowView)((DataGridItem)literal.NamingContainer).DataItem;
literal.Text = container.Row.ItemArray[columnnumber].ToString();
Regex re = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");

if (re.IsMatch(literal.Text)) // for email address add a mailto: hyperlink
{

literal.Text = "<a href=mailto:" + literal.Text + ">" + literal.Text + "</a>"

}

}

}

/// <summary>
/// Event Is Raised To Find The Description Of UniqueIdentifiers
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lc_SearchDataBinding(object sender, EventArgs e)
{

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataColumnSearch], null))
{

Literal literal = (Literal)sender;
DataRowView container = (DataRowView)((DataGridItem)literal.NamingContainer).DataItem;
guid = container.Row.ItemArray[columnnumber].ToString();
literal.ID = guid;
literal.Text = this.SearchDataTable(this.PropertyCollection[EMSDataGridExtendedProperties.DataTable], this.PropertyCollection[EMSDataGridExtendedProperties.DataColumnSearch], this.PropertyCollection[EMSDataGridExtendedProperties.DataTextField], guid);

}
else
{

throw new Exception("Search Data Column Not Set For DataTable " + ((DataTable)this.PropertyCollection[EMSDataGridExtendedProperties.DataTable]).TableName + " For Column " + columnname + " i.e. " + columncaption);

}

}

/// <summary>
/// Event Is Raised To Set The Default Selected Value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lc_SelectedDropDown(object sender, EventArgs e)
{

Literal literal = (Literal)sender;
DataRowView container = (DataRowView)((DataGridItem)literal.NamingContainer).DataItem;
if (!object.Equals(container.Row.ItemArray[columnnumber], Guid.Empty))
{

literal.Text = container.Row.ItemArray[columnnumber].ToString();

}
//this.strSelectedValue = container.Row.ItemArray[columnnumber].ToString();

}

/// <summary>
/// This Event Is Used For Selected DropDown
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ddl_SelectedDropDown(object sender, EventArgs e)
{

DropDownList ddl = (DropDownList)sender;
DataRowView container = (DataRowView)((DataGridItem)ddl.NamingContainer).DataItem;
//ddl.SelectedValue = this.strSelectedValue;
//this.strSelectedValue = string.Empty;

}

/// <summary>
/// Used To Set The Value For The TextBox Based On The DataType
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tb_DataBinding(object sender, EventArgs e)
{

if (columnnumber != -1)
{

TextBox tb = (TextBox)sender;
DataRowView container = (DataRowView)((DataGridItem)tb.NamingContainer).DataItem;

tb.Text = container.Row.ItemArray[columnnumber].ToString();

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.ReadOnly], null))
{

if (PropertyCollection[EMSDataGridExtendedProperties.ReadOnly].GetType().ToString() != "System.Boolean")
{

//TODO: Please Generlize This As Well
if (container.Row[PropertyCollection[EMSDataGridExtendedProperties.ReadOnly].ToString()].GetType().ToString() == "System.Boolean")
{

bool blnFlag = (bool)container.Row[PropertyCollection[EMSDataGridExtendedProperties.ReadOnly].ToString()];

tb.ReadOnly = blnFlag;
//Setting ReadOnly Style Of The TextBox

if (blnFlag)
{

if (!Object.Equals(PropertyCollection[EMSDataGridExtendedProperties.ReadOnlyStyle], null))
{

tb.CssClass = PropertyCollection[EMSDataGridExtendedProperties.ReadOnlyStyle].ToString();

}
else
{

tb.CssClass = READONLYTEXTBOXSTYLE;

}

}

}

}

}

}

}
/// <summary>
/// Used To Set The Value For The TextBox Based On The DataType
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tb7_DataBinding(object sender, EventArgs e)
{

if (columnnumber != -1)
{

TextBox tb = (TextBox)sender;
DataRowView container = (DataRowView)((DataGridItem)tb.NamingContainer).DataItem;

tb.Text = GetValidDate(container.Row.ItemArray[columnnumber]).ToString();
tb.ReadOnly = true;
tb.CssClass = READONLYTEXTBOXSTYLE;

}

}

/// <summary>
/// Used To Set The CheckBox Value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cb_DataBinding(object sender, EventArgs e)
{

if (columnnumber != -1)
{

CheckBox cb = (CheckBox)sender;
DataRowView container = (DataRowView)((DataGridItem)cb.NamingContainer).DataItem;
if (!object.Equals(container.Row.ItemArray[columnnumber], DBNull.Value))
{

cb.Checked = (bool)container.Row.ItemArray[columnnumber];

}

}

}

#endregion
#region Helper Function Used By This Class
/// <summary>
/// Helper Function Used Populate The DropDown Box
/// </summary>
/// <param name="ddl"></param>
private void BindDropDown(DropDownList ddl)
{

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataTable], null))
{

DataTable dt = (DataTable)this.PropertyCollection[EMSDataGridExtendedProperties.DataTable];

if (!object.Equals(dt.Rows[0][0], DBNull.Value))
{

DataRow dr = dt.NewRow();
dr[0] = DBNull.Value;
dr[1] = DROPDOWNDEFAULTTEXT;
dt.Rows.InsertAt(dr, 0);

}

ddl.DataSource = dt;

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataValueField], null))
{

ddl.DataValueField = this.PropertyCollection[EMSDataGridExtendedProperties.DataValueField].ToString();

}
else
{

throw new Exception("Following Drop Down List Text Field Not Set For DataTable " + dt.TableName + " Column " + columnname + " i.e. " + columncaption);

}

if (!object.Equals(this.PropertyCollection[EMSDataGridExtendedProperties.DataTextField], null))
{

ddl.DataTextField = this.PropertyCollection[EMSDataGridExtendedProperties.DataTextField].ToString();

}
else
{

throw new Exception("Following Drop Down List Text Field Not Set For DataTable " + dt.TableName + " Column " + columnname + " i.e. " + columncaption);

}
ddl.DataBind();

}
else
{

throw new Exception("Data Table Not Set For The Drop Down Box " + columnname + " i.e. " + columncaption);

}

}
/// <summary>
/// Helper Function Used To Set The Description For The Guid
/// </summary>
/// <param name="objDataTable"></param>
/// <param name="objDataColumn"></param>
/// <param name="strId"></param>
/// <returns></returns>
private string SearchDataTable(object objDataTable, object objDataColumn, object objDataText, string strId)
{

//Checking if any ID Exists In Column
if (strId.Length == 0)
{

return string.Empty;

}

//
if (!object.Equals(objDataTable, null))
{

if (!object.Equals(objDataColumn, null))
{

DataRow[] dr = ((DataTable)objDataTable).Select(objDataColumn.ToString() + "='" + strId + "'");
if (dr.Length == 0)
{

throw new ArgumentException(" Unable To Replace " + objDataColumn.ToString() + " Column Of DataTable " + ((DataTable)objDataTable).TableName + " With Description In Data Grid");

}
else
{

return dr[0][objDataText.ToString()].ToString();
//return dr[0][1].ToString();                        

}

}
else
{

return string.Empty;

}

}
else
{

return string.Empty;

}

}
/// <summary>
/// Helper Function Used For Date Conversion
/// </summary>
/// <param name="dtDate"></param>
/// <returns></returns>
public DateTime DateConvertor(string strDate)
{

//TODO: Get It From The Ticket
return DateTime.ParseExact(strDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None);

}
/// <summary>
/// Helper Function Used For Date Conversion
/// </summary>
/// <param name="dtDate"></param>
/// <returns></returns>
public string DateConvertor(DateTime dtDate)
{

return dtDate.ToString("dd/MM/yyyy");

}
/// <summary>
/// Helper Function Used For DataRow Value Conversion
/// </summary>
/// <param name="objDate"></param>
/// <returns></returns>
private object GetValidDate(object objDate)
{

if (objDate.Equals(DBNull.Value))
{

return objDate;

}
else
{

return this.DateConvertor((DateTime)objDate);

}

}
/// <summary>
/// Helper Function Used For DataRow Value Conversion
/// </summary>
/// <param name="strValue"></param>
/// <returns></returns>
private object GetValidValue(string strValue)
{

strValue = strValue.ToString().Trim();
if (strValue.Length == 0)
{

return DBNull.Value;

}
else
{

return strValue;

}

}
#endregion

}

}

. . .