Asp.NET, SharePoint, Workflow

Jan Lokpal bill in IT Style

2011-08-27T07:48:32-07:00

Application Pages V/s. Site Pages in SharePoint

2011-06-30T00:41:58-07:00

Site pages are pages which live in the Sharepoint database.

Application pages are pages which live on the server's file system. Application pages usually also execute code, but not always.

More @ https://sharepoint.washington.edu/windows/Lists/Posts/Post.aspx?ID=93

Content Types in SharePoint 2010

2011-06-30T00:36:17-07:00

A content type is a reusable collection of metadata (columns), workflow, behavior, and other settings for a category of items or documents in a Microsoft SharePoint Server 2010 list or document library. Content types enable you to manage the settings for a category of information in a centralized, reusable way.

More : http://technet.microsoft.com/en-us/library/cc262735.aspx

Create all SharePoint List's Template Automatically

2011-02-26T03:15:10-08:00

SPWeb web = workflowProperties.Web;
string[] listnames = (from SPList lst in web.Lists
                        select lst.Title).ToArray();

foreach (string s in listnames)
{
    web.Lists[s].SaveAsTemplate(s, s, string.Empty, false);
}

Coding Standards with Example for C++ and C#

2010-11-15T21:16:13-08:00

Coding Standards C & C#

SharePoint STSADM Commands

2010-10-15T00:27:41-07:00

stsadm -o activatefeature {-filename | -name | -id } [-url ] [-force]
stsadm -o activateformtemplate -url [-formid
] [-filename ]
stsadm -o addalternatedomain -url -incomingurl -urlzone -resourcename
stsadm -o addcontentdb -url -databasename [-databaseserver ] [-databaseuser ] [-databasepassword ] [-sitewarning ] [-sitemax ]
stsadm -o adddataconnectionfile -filename [-webaccessible ] [-overwrite ] [-category ]
stsadm -o add-ecsfiletrustedlocation -Ssp -Location -LocationType SharePoint|Unc|Http -IncludeChildren True|False [-SessionTimeout ] [-ShortSessionTimeout ] [-MaxRequestDuration ] [-MaxWorkbookSize ] [-MaxChartSize ] [-VolatileFunctionCacheLifetime ] [-DefaultWorkbookCalcMode File|Manual|Auto|AutoDataTables] [-AllowExternalData None|Dcl|DclAndEmbedded] [-WarnOnDataRefresh True|False] [-StopOpenOnRefreshFailure True|False] [-PeriodicCacheLifetime ] [-ManualCacheLifetime ] [-MaxConcurrentRequestsPerSession ] [-AllowUdfs True|False] [-Description ]
stsadm -o add-ecssafedataprovider -Ssp -ID -Type Oledb|Odbc|OdbcDsn [-Description ]
stsadm -o add-ecstrusteddataconnectionlibrary -Ssp -Location [-Description ]
stsadm -o add-ecsuserdefinedfunction -Ssp -Assembly -AssemblyLocation GAC|File [-Enable True|False] [-Description ]

stsadm -o addexemptuseragent -name

stsadm -o addpath -url -type

stsadm -o addpermissionpolicy -url -userlogin -permissionlevel [-zone ] [-username ]

stsadm -o addsolution -filename [-lcid ]

stsadm -o addtemplate -filename

stsadm -o adduser -url -userlogin -useremail <someone@example.com> -role / -group -username [-siteadmin]

stsadm -o addwppack -filename [-lcid ] [-url ] [-globalinstall] [-force] [-nodeploy]

stsadm -o addwppack -name [-lcid ] [-url ] [-globalinstall] [-force]

stsadm -o addzoneurl -url -urlzone -zonemappedurl -resourcename

stsadm -o allowuserformwebserviceproxy -url -enable

stsadm -o allowwebserviceproxy -url -enable

stsadm -o associatewebapp -title [-default | -parent] -url [-all]

stsadm -o authentication -url -type [-usebasic (valid only in windows authentication mode)] [-usewindowsintegrated (valid only in windows authentication mode)] [-exclusivelyusentlm (valid only in windows authentication mode)] [-membershipprovider ] [-rolemanager ] [-enableclientintegration] [-allowanonymous]

stsadm -o backup -url -filename [-overwrite]

stsadm -o backup -directory -backupmethod [-item ] [-percentage ] [-backupthreads ] [-showtree] [-quiet]

stsadm -o backuphistory -directory [-backup] [-restore]

stsadm -o binddrservice -servicename -setting

stsadm -o blockedfilelist -extension -add [-url ]

stsadm -o blockedfilelist -extension -delete [-url ]

stsadm -o canceldeployment -id

stsadm -o changepermissionpolicy -url -userlogin [-zone ] [-username ] [{ -add | -delete } -permissionlevel ]

stsadm -o copyappbincontent

stsadm -o createadminvs [-admapidname ] [-admapidtype ] [-admapidlogin ] [-admapidpwd ]

stsadm -o createcmsmigrationprofile -profilename [-description ] [-connectionstring ] -databaseserver -databasename -databaseuser [-databasepassword ] [-auth windowsauth|sqlauth] -destination [-rootchannel ] [-destinationlocale ] [-migrateresources onlyused|all] [-migrateacls yes|no] [-emailto ] [-emailon success|failure|none|both] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]

stsadm -o creategroup -url -name -description -ownerlogin [-type member|visitor|owner]

stsadm -o createsite -url -owneremail <someone@example.com> [-ownerlogin ] [-ownername ] [-secondaryemail <someone@example.com>] [-secondarylogin ] [-secondaryname ] [-lcid ] [-sitetemplate ] [-title ] [-description ] [-hostheaderwebapplicationurl ] [-quota ]

stsadm -o createsiteinnewdb -url -owneremail <someone@example.com> [-ownerlogin ] [-ownername ] [-secondaryemail <someone@example.com>] [-secondarylogin ] [-secondaryname ] [-lcid ] [-sitetemplate ] [-title ] [-description ] [-hostheaderwebapplicationurl ] [-quota ] [-databaseuser ] [-databasepassword ] [-databaseserver ] [-databasename ]

stsadm -o createssp -title -url -mysiteurl -ssplogin -indexserver -indexlocation [-ssppassword ] [-sspdatabaseserver ] [-sspdatabasename ] [-sspsqlauthlogin ] [-sspsqlauthpassword ] [-searchdatabaseserver ] [-searchdatabasename ] [-searchsqlauthlogin ] [-searchsqlauthpassword ] [-ssl ]

stsadm -o createweb -url [-lcid ] [-sitetemplate ] [-title ] [-description ] [-convert] [-unique]

stsadm -o databaserepair -url -databasename [-deletecorruption]

stsadm -o deactivatefeature {-filename | -name | -id } [-url ] [-force]

stsadm -o deactivateformtemplate -url [-formid ] [-filename ]

stsadm -o deleteadminvs

stsadm -o deletealternatedomain -url -incomingurl

stsadm -o deletecmsmigrationprofile -profilename

stsadm -o deleteconfigdb

stsadm -o deletecontentdb -url -databasename [-databaseserver ]

stsadm -o deletegroup -url -name

stsadm -o deletepath -url

stsadm -o deletepermissionpolicy -url -userlogin [-zone ]

stsadm -o deletesite -url -deleteadaccounts

stsadm -o deletesolution -name [-override] [-lcid ]

stsadm -o deletessp -title [-deletedatabases]

stsadm -o deletessptimerjob -title -jobid

stsadm -o deletetemplate -title

stsadm -o deleteuser -url -userlogin [-group ]

stsadm -o deleteweb -url

stsadm -o deletewppack -name [-lcid ] [-url ]

stsadm -o deletezoneurl -url -urlzone -resourcename

stsadm -o deploysolution -name [-url ] [-allcontenturls] [-time ] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid ] [-force]

stsadm -o deploywppack -name [-url ] [-time ] [-immediate] [-local] [-lcid ] [-globalinstall] [-force]

stsadm -o disablessc -url

stsadm -o displaysolution -name

stsadm -o editcmsmigrationprofile -profilename [-description ] [-connectionstring ] [-databaseserver ] [-databasename ] [-databaseuser ] [-databasepassword ] [-auth sqlauth|windowsauth] [-emailto ] [-emailon success|failure|none|both] [-excludeschema ] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]

stsadm -o editcontentdeploymentpath -pathname [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no] [-enablecompression yes|no]

stsadm -o editssp -title [-newtitle ] [-sspadminsite ] [-ssplogin ] [-ssppassword ] [-indexserver ] [-indexlocation ] [-setaccounts ] [-ssl ]

stsadm -o email -outsmtpserver -fromaddress <someone@example.com> -replytoaddress <someone@example.com> -codepage [-url ]

stsadm -o enablecmsurlredirect -profilename -off

stsadm -o enablessc -url [-requiresecondarycontact]

stsadm -o enumalternatedomains -url -resourcename

stsadm -o enumcontentdbs -url

stsadm -o enumdataconnectionfiledependants -filename

stsadm -o enumdataconnectionfiles [-mode ]

stsadm -o enumdeployments

stsadm -o enumexemptuseragents

stsadm -o enumformtemplates

stsadm -o enumgroups -url

stsadm -o enumroles -url

stsadm -o enumservices

stsadm -o enumsites -url -showlocks -redirectedsites

stsadm -o enumsolutions

stsadm -o enumssp -title [-default | -parent | -all]

stsadm -o enumssptimerjobs -title

stsadm -o enumsubwebs -url

stsadm -o enumtemplates [-lcid ]

stsadm -o enumusers -url

stsadm -o enumwppacks [-name ] [-url ] [-farm]

stsadm -o enumzoneurls -url -resourcename

stsadm -o execadmsvcjobs

stsadm -o export -url -filename [-overwrite] [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-versions <1-4> 1= Last major version for files and list items (default), 2= The current version, either the last major or the last minor, 3= Last major and last minor version for files and list items, 4= All versions for files and list items] [-cabsize (default: 25)] [-nofilecompression] [-quiet]

stsadm -o extendvs -url -ownerlogin -owneremail <someone@example.com> [-exclusivelyusentlm] [-ownername ] [-databaseuser ] [-databaseserver ] [-databasename ] [-databasepassword ] [-lcid ] [-sitetemplate ] [-donotcreatesite] [-description ] [-sethostheader] [-apidname ] [-apidtype ] [-apidlogin ] [-apidpwd ] [-allowanonymous]

stsadm -o extendvsinwebfarm -url -vsname [-exclusivelyusentlm] [-apidname ] [-apidtype ] [-apidlogin ] [-apidpwd ] [-allowanonymous]

stsadm -o forcedeleteweb -url

stsadm -o formtemplatequiescestatus [-formid ] [-filename ]

stsadm -o getadminport

stsadm -o getdataconnectionfileproperty -filename -pn

stsadm -o getformsserviceproperty -pn

stsadm -o getformtemplateproperty [-formid ] [-filename ] -pn

stsadm -o getproperty -propertyname [-url ] (SharePoint cluster properties: avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties: alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)

stsadm -o getsitedirectoryscanschedule

stsadm -o getsitelock -url

stsadm -o geturlzone -url

stsadm -o import -url -filename [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-updateversions <1-3> 1= Add new versions to the current file (default), 2= Overwrite the file and all its versions (delete then insert),3= Ignore the file if it exists on the destination] [-nofilecompression] [-quiet]

stsadm -o installfeature {-filename | -name } [-force]

stsadm -o listlogginglevels [-showhidden]

stsadm -o listregisteredsecuritytrimmers -ssp

stsadm -o localupgradestatus

stsadm -o managepermissionpolicylevel -url -name [{ -add | -delete }] [-description ] [-siteadmin ] [-siteauditor ] [-grantpermissions ] [-denypermissions ]

stsadm -o migrateuser -oldlogin -newlogin [-ignoresidhistory]

stsadm -o osearch [-action ] required parameters for 'start' (if not already set): role, farmcontactemail, service credentials [-f (suppress prompts)] [-role ] [-farmcontactemail ] [-farmperformancelevel ] [-farmserviceaccount (service credentials)] [-farmservicepassword ] [-defaultindexlocation ] [-propagationlocation ]

stsadm -o osearchdiacriticsensitive -ssp [-setstatus ] [-noreset] [-force]

stsadm -o preparetomove {-ContentDB | -Site } [-OldContentDB ] [-undo]

stsadm -o profilechangelog -title -daysofhistory -generateanniversaries

stsadm -o profiledeletehandler -type

stsadm -o provisionservice -action -servicetype [-servicename ]

stsadm -o quiescefarm -maxduration

stsadm -o quiescefarmstatus

stsadm -o quiesceformtemplate [-formid ] [-filename ] -maxduration

stsadm -o reconvertallformtemplates

stsadm -o refreshdms -url

stsadm -o refreshsitedms -url

stsadm -o registersecuritytrimmer -ssp -id <0 - 2147483647> -typename -rulepath [-configprops ]

stsadm -o registerwsswriter

stsadm -o removedataconnectionfile -filename

stsadm -o removedrservice -servicename -setting

stsadm -o remove-ecsfiletrustedlocation -Ssp -Location -LocationType SharePoint|Unc|Http

stsadm -o remove-ecssafedataprovider -Ssp -ID -Type Oledb|Odbc|OdbcDsn

stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp -Location

stsadm -o remove-ecsuserdefinedfunction -Ssp -Assembly -AssemblyLocation GAC|File

stsadm -o removeexemptuseragent -name

stsadm -o removeformtemplate [-formid ] [-filename ]

stsadm -o removesolutiondeploymentlock [-server [-allservers]

stsadm -o renameserver -oldservername -newservername

stsadm -o renameweb -url -newname

stsadm -o restore -url -filename [-hostheaderwebapplicationurl ] [-overwrite]

stsadm -o restore -directory -restoremethod [-backupid ] [-item ] [-percentage ] [-showtree] [-suppressprompt] [-username ] [-password ] [-newdatabaseserver ] [-quiet]

stsadm -o restoressp -title -url -ssplogin -mysiteurl -indexserver -indexlocation [-keepindex] -sspdatabaseserver -sspdatabasename [-ssppassword ] [-sspsqlauthlogin ] [-sspsqlauthpassword ] [-searchdatabaseserver ] [-searchdatabasename ] [-searchsqlauthlogin ] [-searchsqlauthpassword ] [-ssl ]

stsadm -o retractsolution -name [-url ] [-allcontenturls] [-time ] [-immediate] [-local] [-lcid ]

stsadm -o retractwppack -name [-url ] [-time ] [-immediate] [-local] [-lcid ]

stsadm -o runcmsmigrationprofile -profilename [-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime ] [-migrationfolder ] [-exportonly ] [-importonly ] [-htmldiff ]

stsadm -o runcontentdeploymentjob -jobname [-wait yes|no] [-deploysincetime ] ( as "MM/DD/YY HH:MM:SS")

stsadm -o scanforfeatures [-solutionid ] [-displayonly]

stsadm -o setadminport -port [-ssl] [-admapcreatenew] [-admapidname ]

stsadm -o setapppassword -password

stsadm -o setbulkworkflowtaskprocessingschedule -schedule

stsadm -o setconfigdb [-connect] -databaseserver [-databaseuser ] [-databasepassword ] [-databasename ] [-exclusivelyusentlm] [-farmuser] [-farmpassword] [-adcreation] [-addomain ] [-adou ]

stsadm -o setcontentdeploymentjobschedule -jobname -schedule (Schedule Parameter Examples: "every 5 minutes between 0 and 59", "hourly between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00 and Sun 06:00:00", "monthly at 15 15:00:00", "yearly at Jan 1 15:00:00")

stsadm -o setdataconnectionfileproperty -filename -pn -pv

stsadm -o setdefaultssp -title

stsadm -o set-ecsexternaldata -Ssp [-ConnectionLifetime ] [-UnattendedServiceAccountName ] [-UnattendedServiceAccountPassword ]

stsadm -o set-ecsloadbalancing -Ssp [-Scheme WorkbookUrl|RoundRobin|Local] [-RetryInterval ]

stsadm -o set-ecsmemoryutilization -Ssp [-MaxPrivateBytes ] [-MemoryCacheThreshold ] [-MaxUnusedObjectAge ]

stsadm -o set-ecssecurity -Ssp [-FileAccessMethod UseImpersonation|UseFileAccessAccount] [-AccessModel Delegation|TrustedSubsystem] [-RequireEncryptedUserConnection False|True] [-AllowCrossDomainAccess True|False]

stsadm -o set-ecssessionmanagement -Ssp [-MaxSessionsPerUser ]

stsadm -o set-ecsworkbookcache -Ssp [-Location ] [-MaxCacheSize ] [-EnableCachingOfUnusedFiles True|False]

stsadm -o setformsserviceproperty -pn -pv

stsadm -o setformtemplateproperty [-formid ] [-filename ] -pn -pv

stsadm -o setholdschedule -schedule

stsadm -o setlogginglevel [-category < [CategoryName | Manager:CategoryName [;...]] >] {-default | -tracelevel < None; Unexpected; Monitorable; High; Medium; Verbose> [-windowslogginglevel < None; ErrorServiceUnavailable; ErrorSecurityBreach; ErrorCritical; Error; Warning; FailureAudit; SuccessAudit; Information; Success>] }

stsadm -o setpolicyschedule -schedule

stsadm -o setproperty -propertyname -propertyvalue [-url ] (SharePoint cluster properties:, avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties:, alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)

stsadm -o setrecordsrepositoryschedule -schedule

stsadm -o setsearchandprocessschedule -schedule

stsadm -o setsharedwebserviceauthn -ntlm | -negotiate

stsadm -o setsitedirectoryscanschedule -schedule (Schedule parameter examples: "every 5 minutes between 0 and 59", "hourly between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00 and Sun 06:00:00", "monthly at 15 15:00:00", "yearly at Jan 1 15:00:00")

stsadm -o setsitelock -url -lock

stsadm -o setsspport -httpport -httpsport

stsadm -o setworkflowconfig -url {-emailtonopermissionparticipants | -externalparticipants | -userdefinedworkflows }

stsadm -o siteowner -url [-ownerlogin ] [-secondarylogin ]

stsadm -o spsearch [-action ] [-f (suppress prompts)] [-farmperformancelevel ] [-farmserviceaccount (service credentials)] [-farmservicepassword ] [-farmcontentaccessaccount ] [-farmcontentaccesspassword ] [-indexlocation ] [-databaseserver (default: josebda-moss)] [-databasename (default: SharePoint_WSS_Search)] [-sqlauthlogin ] [-sqlauthpassword ] -action list -action stop [-f (suppress prompts)] -action start -farmserviceaccount (service credentials) [-farmservicepassword ] -action attachcontentdatabase [-databaseserver (default: josebda-moss)] -databasename [-searchserver (default: josebda-moss)] -action detachcontentdatabase [-databaseserver (default: josebda-moss)] -databasename [-f (suppress prompts)] -action fullcrawlstart -action fullcrawlstop

stsadm -o spsearchdiacriticsensitive [-setstatus ] [-noreset] [-force]

stsadm -o sync {-ExcludeWebApps | -SyncTiming | -SweepTiming | -ListOldDatabases | -DeleteOldDatabases }

stsadm -o syncsolution -name ] [-lcid ] [-alllcids]

stsadm -o syncsolution -allsolutions

stsadm -o unextendvs -url [-deletecontent] [-deleteiissites]

stsadm -o uninstallfeature {-filename | -name | -id } [-force]

stsadm -o unquiescefarm

stsadm -o unquiesceformtemplate [-formid ] [-filename ]

stsadm -o unregistersecuritytrimmer -ssp -id <0 - 2147483647>

stsadm -o unregisterwsswriter

stsadm -o updateaccountpassword -userlogin -password [-noadmin]

stsadm -o updatealerttemplates -url [-filename ] [-lcid

stsadm -o updatefarmcredentials [-identitytype ] [-userlogin ] [-password ] [-local [-keyonly]]

stsadm -o upgrade {-inplace | -sidebyside} [-url ] [-forceupgrade] [-quiet] [-farmuser ] [-farmpassword ] [-reghost] [-sitelistpath ]

stsadm -o upgradeformtemplate -filename [-upgradetype ]

stsadm -o upgradesolution -name -filename [-time ] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid ]

stsadm -o upgradetargetwebapplication -url -relocationurl -apidname [-apidtype ] [-apidlogin ] [-apidpwd ] [-exclusivelyusentlm]

stsadm -o uploadformtemplate -filename

stsadm -o userrole -url -userlogin -role [-add] [-delete]

stsadm -o verifyformtemplate -filename

Original Source = http://blogs.technet.com/b/josebda/archive/2007/03/22/complete-reference-of-all-stsadm-commands-with-options-in-moss-2007.aspx

Advance Detail About Commands : http://technet.microsoft.com/en-us/library/cc263384(office.12).aspx

Create new site programmatically in workflow

2010-09-23T01:07:35-07:00

private void codeActivity1_ExecuteCode(object sender, EventArgs e)
        {
            SPWeb web = workflowProperties.Web;
            SPSite site = workflowProperties.Site;
            SPListItem lst = workflowProperties.Item;
            string title = lst["Title"].ToString();
            string url = title.Replace(' ', '-');
            if (!web.Webs["title"].Exists)
            {
                SPWeb wb = web.Webs.Add(url);
                lst["weburl"] = wb.Url;
                lst.Update();
                web.Update();
            }
            

        }

Add and Remove user in SharePoint Group

2010-09-13T06:21:09-07:00

Add and Remove user in SharePoint Group

Web.Config Overview for Beginners

2010-09-02T23:35:20-07:00

Web.Config Overview

Sharepoint Overview

2010-08-04T23:44:47-07:00

What is Application-Website Dashboard?

2010-08-02T03:41:04-07:00

A Dashboard is the over view of the particular site's/user's details. Dashboard is steering for the user. Dashboards show visualizations of your data such as charts and graphs and are extremely useful for displaying the results of reports and searches.

Use dashboards to highlight interesting and useful aspects of your data, link to important searches and display common reports.

Information displayed on the dashboard should be reflecting the current value (for reports/charts). So that user can notice every change at a glance by that user can get any decision early. Dashboard should not be filling with only reports. a dashboard is a form of report, but not all reports are dashboards

Dashboard is one type of the Railway Station. Where user come get train detail and travel if he/she wants. In easy words user should get all the details and links in the dashboard so user can travel to the destination (required page) via dashboard.

Dashboard contains Charts, Tables, Links, Reports, notifications etc.

Source: http://www.codeproject.com/KB/architecture/DashboardsAreForDriving.aspx

Excel all Worksheet Column Case Change Macro

2010-06-16T23:48:33-07:00

Sub UpCase()

Dim dbSheet As Worksheet
Dim LastRowColC
For i = 1 To Worksheets.Count
    Set dbSheet = Worksheets(i)
    LastRowColC = dbSheet.Range("B" + CStr(dbSheet.Rows.Count)).End(xlUp).Row
    For j = 1 To LastRowColC
        dbSheet.Cells(j, "B").Value = StrConv(dbSheet.Cells(j, "B").Value, vbUpperCase)
    Next j
Next i
End Sub

Read CSV with oledb to dataset - datatable

2010-05-07T03:54:03-07:00

string csvDirectory = Server.MapPath("~/media/");
        string CsvFile = "SampleDirectory.csv";
        DataSet ds = new DataSet();
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + csvDirectory + ";Extended Properties='text;HDR=Yes;FMT=Delimited'");
        OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter("SELECT * FROM " + CsvFile, con);
        con.Open();
        ExcelAdapter.Fill(ds);
        con.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();

Resize Image with javascript

2011-06-01T02:01:12-07:00

function resizeImageByWidth(img,MaxWidth) {
    try {
        if (img != null && img.src != "") {
            img.attributes.removeNamedItem("width");
            img.attributes.removeNamedItem("height");

            var oW = img.width;
            var oH = img.height;

            if (oW > MaxWidth) {
                var rW = parseFloat(oW) / parseFloat(MaxWidth);
                img.width = parseInt(oW / rW);
                img.height = parseInt(oH / rW);
            }
        }
    }
    catch (ex) {
        img.width = MaxWidth;
    }
}

function resizeImage(img, maxHeight, MaxWidth) {
    try {
        if (img != null && img.src != "") {
            img.attributes.removeNamedItem("width");
            img.attributes.removeNamedItem("height");

            var oW = img.width;
            var oH = img.height;

            if (oW > MaxWidth || oH > maxHeight) {
                var rW = parseFloat(oW) / parseFloat(MaxWidth);
                var rH = parseFloat(oH) / parseFloat(maxHeight);
                var ratio = Math.max(rW, rH);
                img.width = parseInt(oW / ratio);
                img.height = parseInt(oH / ratio);
            }
        }
    }
    catch (ex) {
        img.height = maxHeight;
        img.width = MaxWidth;
    }
}

To use in the image just add onload event event on image

any size is given automatically removed.

Convert decimal to currency format string

2010-05-05T22:46:29-07:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CurrnecyDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            decimal money = 200m;
            CurrencyTranslator currencyTranslator = new CurrencyTranslator();
            string currency = currencyTranslator.TranslateCurrency(money, "Rupee", "Paisa");
        }
    }

    public class CurrencyTranslator
    {
        // Array of sting to hold the words from one to nineteen
        private string[] _arrayOfOnes = { string.Empty, "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", 
"Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen",
"Nineteen" };
        // Array of string to hold the words of tens - 10, 20,.., 90
        private string[] _arrayOfTens = { string.Empty , "Ten", "Twenty", "Thirty", "Forty", "Fifty", "Sixty",
"Seventy", "Eighty", "Ninety"};

        // Converts the decimal to currency
        public string TranslateCurrency(decimal currencyValue, string dollarString, string centString)
{
string numericCurrency = currencyValue.ToString().Trim();
//Check for the max capacity limit of the input
if (numericCurrency.Length > 18)
return "Invalid input format";

string leftValue, decimalWord;
//Right align the charecters with padding of "0" to length the of 18 charecters
if (numericCurrency.IndexOf(".") >= 0)
{
leftValue = numericCurrency.Substring(0, numericCurrency.IndexOf(".")).PadLeft(18, Convert.ToChar("0"));
decimalWord = numericCurrency.Substring(numericCurrency.IndexOf(".") + 1).PadRight(2, Convert.ToChar("0"));
decimalWord = (decimalWord.Length > 2 ? decimalWord.Substring(0, 2) : decimalWord);
}
else
{
leftValue = numericCurrency.PadLeft(18, Convert.ToChar("0"));
decimalWord = "0";
}

string quadrillionWord, trillionWord, billionWord, millionWord, thousandWord, hundredWord;
quadrillionWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(0, 3))); // One Quadrillion - Number of zeros 15
trillionWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(3, 3))); // One Trillion - Number of zeros 12
billionWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(6, 3))); // One Billion - Number of zeros 9
millionWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(9, 3))); // One Million - Number of zeros 6
thousandWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(12, 3)));
hundredWord = TranslateHundreds(Convert.ToInt32(leftValue.Substring(15, 3)));
decimalWord = TranslateDecimal(decimalWord);

// Start building the currency
StringBuilder currencyInEnglish = new StringBuilder();
currencyInEnglish.Append((quadrillionWord.Trim() == string.Empty ? string.Empty : quadrillionWord + " Quadrillion "));
currencyInEnglish.Append((trillionWord.Trim() == string.Empty ? string.Empty : trillionWord + " Trillion "));
currencyInEnglish.Append((billionWord.Trim() == string.Empty ? string.Empty : billionWord + " Billion "));
currencyInEnglish.Append((millionWord.Trim() == string.Empty ? string.Empty : millionWord + " Million "));
currencyInEnglish.Append((thousandWord.Trim() == string.Empty ? string.Empty : thousandWord + " Thousand "));
currencyInEnglish.Append((hundredWord.Trim() == string.Empty ? string.Empty : hundredWord));

currencyInEnglish.Append(currencyInEnglish.ToString() == string.Empty ? string.Format("Zero {0}s ", dollarString) : string.Format(" {0}s", dollarString));
if (currencyInEnglish.ToString().StartsWith(string.Format("One {0}s", dollarString)))
{
currencyInEnglish.Replace(string.Format("One {0}s", dollarString), string.Format("One {0}", dollarString));
}
currencyInEnglish.Append((decimalWord == string.Empty ? string.Format(" and Zero {0}", centString) : " and " + decimalWord + string.Format(" {0}", centString)));
return currencyInEnglish.ToString();
}


        #region Private Functions


        private string TranslateHundreds(int value)
{
string result;
// If the value is less than hundred then convert it as tens
if (value <= 99)

{
result = (TranslateTens(value));
}
else
{
result = _arrayOfOnes[Convert.ToInt32(Math.Floor(Convert.ToDecimal(value / 100)))];
// Math.Floor method is used to get the largest integer from the decial value
result += " Hundred ";
// The rest of the decimal is converted into tens
if (value - Math.Floor(Convert.ToDecimal((value / 100) * 100)) == 0)
{
result += string.Empty;
}
else
{
result += string.Empty + TranslateTens(Convert.ToInt32(value - Math.Floor(Convert.ToDecimal((value / 100) * 100))));
}
}
return result;
}


        private string TranslateTens(int value)
{
string result;
// If the value is less than 20 then get the word directly from the array
if (value < 20)

{
result = _arrayOfOnes[value];
value = 0;
}
else
{
result = _arrayOfTens[(int)Math.Floor(Convert.ToDecimal(value / 10))];
value -= Convert.ToInt32(Math.Floor(Convert.ToDecimal((value / 10) * 10)));
}
result = result + (_arrayOfOnes[value].Trim() == string.Empty ? string.Empty : "-" + _arrayOfOnes[value]);
return result;
}

        // Translates the decimal part of the currency to words
        private string TranslateDecimal(string value)
        {
            string result = string.Empty;
            // Check whether the decimal part starts with a zero. Example : 12.05
            if (value != "0")
            {
                if (value.StartsWith("0"))
                {
                    result = "Zero ";
                    result += _arrayOfOnes[Convert.ToInt32(value.Substring(1, 1))];
                }
                else
                {
                    result = TranslateTens(Convert.ToInt32(value));
                }

            }
            return result;
        }
        #endregion
    }
}

Resize Image High Quality C#.Net with Size Ratio and File Upload Control

2010-04-24T03:22:55-07:00

public bool SaveThumbnailImageHQ(System.Web.UI.WebControls.FileUpload fu, string FullSavePath, int HeightMax, int WidthMax)
{
    try
    {
        if (fu.HasFile)
        {
            Size newSize = new Size(WidthMax, HeightMax);
            using (Bitmap bmp = new Bitmap(fu.PostedFile.InputStream))
            {
                double ratioWidth = (double)bmp.Size.Width / (double)newSize.Width;
                double ratioHeight = (double)bmp.Size.Height / (double)newSize.Height;
                double ratio = Math.Max(ratioHeight, ratioWidth);
                int newWidth = (int)(bmp.Size.Width / ratio);
                int newHeight = (int)(bmp.Size.Height / ratio);
                newSize = new Size(newWidth, newHeight);
                using (Bitmap thumb = new Bitmap((System.Drawing.Image)bmp, newSize))
                {
                    using (Graphics g = Graphics.FromImage(thumb)) // Create Graphics object from original Image
                    {
                        g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
                        g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
                        g.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
                        System.Drawing.Imaging.ImageCodecInfo codec = System.Drawing.Imaging.ImageCodecInfo.GetImageEncoders()[1];
                        System.Drawing.Imaging.EncoderParameters eParams = new System.Drawing.Imaging.EncoderParameters(1);
                        eParams.Param[0] = new System.Drawing.Imaging.EncoderParameter(System.Drawing.Imaging.Encoder.Quality, 100L);
                        g.DrawImage(bmp, new Rectangle(0, 0, thumb.Width, thumb.Height));
                        if (System.IO.File.Exists(FullSavePath))
                        {
                            try { System.IO.File.Delete(FullSavePath); }
                            catch { }
                        }
                        thumb.Save(FullSavePath, codec, eParams);
                        //setError(false, string.Empty);
                        return true;
                    }
                }
            }
        }
        else
        {
            //setError(true, "No file input found.");
            return false;
        }
    }
    catch (Exception ex)
    {
        //setError(true, ex.Message);
        return false;
    }
}

All Font Preview Microsoft Word Macro

2010-04-19T02:34:13-07:00

Sub Generate_Font_Preview()
Dim doc As Word.Document
Dim objRange As Range
Dim oTable  As Word.Table
Dim iCnt  As Integer
Dim s1 As Range
Dim str As String

Set doc = Application.Documents.Add
Set objRange = doc.Range()
str = InputBox("Please enter Preview Text", "Preview Text")

doc.Tables.Add objRange, Application.FontNames.Count, 2
Set oTable = doc.Tables(1)


For iCnt = 1 To FontNames.Count
    If (IsEmpty(str)) Then
        str = Application.FontNames(iCnt)
    End If
    oTable.Cell(iCnt, 1).Range.Text = Application.FontNames(iCnt)
    oTable.Cell(iCnt, 1).SetWidth ColumnWidth:=InchesToPoints(1.5), RulerStyle:=wdAdjustSameWidth
    With oTable.Cell(iCnt, 2).Range
        .Text = str
        .Font.Name = Application.FontNames(iCnt)
        .Font.Size = 25
        .Font.Color = WdColor.wdColorBlack
    End With
Next iCnt
End Sub

Split string-value with delimeter in Sql Server via XML

2010-04-09T22:33:54-07:00

Declare @xml as xml
declare @str as varchar(100)
declare @delimiter as varchar(10)
SET @str=',A,B,C,D,E,,,'
SET @delimiter =','
SET @xml = cast((''+replace(@str,@delimiter ,'')+'') as xml)
select @xml
SELECT N.value('.', 'varchar(max)') as value 
FROM @xml.nodes('x') as T(N) where N.value('.', 'varchar(max)')<>''

Master Page - Content Page Life Cycle

2010-03-02T23:39:34-08:00

Content page PreInit event.
Master page controls Init event.
Content controls Init event.
Master page Init event.
Content page Init event.
Content page Load event.
Master page Load event.
Master page controls Load event.
Content page controls Load event.
Content page PreRender event.
Master page PreRender event.
Master page controls PreRender event.
Content page controls PreRender event.
Master page controls Unload event.
Content page controls Unload event.
Master page Unload event.
Content page Unload event.
The sequence of events in master

Programatically copy worksheet via VBA in Excel

2010-04-09T22:44:48-07:00

Dim oBook As Workbook

Excel.Application.DisplayAlerts = False

Application.ScreenUpdating = False

Me.btnExportWorkSheet.TakeFocus<nClick = False

' Delete the Old File

Kill "c:\FileName.xls"

' Create a new blank workbook:

Set oBook = Application.Workbooks.Add

Application.SheetsInNewWorkbook = 1

' Add a defined name to the workbook

' that RefersTo a range:

oBook.Names.Add Name:="tempRange", RefersTo:="=Sheet1!$A$1"


' Save the workbook:

oBook.SaveAs "c:\FileName.xls"


' Select the Workbook where the Worksheet to be copied is located

Workbooks("Old File.xls").Activate

Workbooks("Old File.xls").Worksheets("Work Sheet A").Activate


' Copy the Worksheet to the Workbook

Worksheets("Work Sheet A").Copy Before:=Workbooks("New Work

Book.xls").Sheets(1)

Dim xRange As Range, adr As String

Workbooks("New Work Book.xls").Worksheets("Work Sheet A").Activate

Workbooks("New Work Book.xls").Worksheets("Work Sheet A").Range("a1:z100").Activate

' Remove Links and Replace with Cell Values

With Workbooks("New Work Book.xls").Worksheets("Work Sheet A")

Dim cCell As Range

Dim strValue As String

Set xRange = .Range("a1:z100")

For Each cCell In xRange

' Save the value to use as a means to identify what cells

to change

strValue = CStr(cCell.Value)

If InStr(strValue, "/") > 0 Then

cCell = CStr(cCell.Value)

End If

Next

End With

' Select the next Workbook where the Worksheet to be copied is located

Workbooks("Old File.xls").Activate

Workbooks("Old File.xls").Worksheets("Work Sheet B").Activate

' Copy the Worksheet to the Workbook

Worksheets("Work Sheet B").Copy Before:=Workbooks("CashFlowInput&DollarChart.xls").Sheets(1) ', UpdateLinks:=0

Workbooks("New Work Book.xls").Worksheets("Work Sheet B").Activate

Workbooks("New Work Book.xls").Worksheets("Work Sheet B").Range("a1:z100").Activate

' Remove Links and Replace with Cell Values

With Workbooks("New Work Book.xls").Worksheets("Dollars Chart")

Set xRange = .Range("a1:z100")

For Each cCell In xRange

' Save the value to use as a means to identify what cells to change

' cCell.Formula will show the link back to the Original

Workbook

strValue = CStr(cCell.Formula)

If InStr(strValue, "!") > 0 Then

cCell = CStr(cCell.Value)

' If cCell = .Range("b51") Or cCell = .Range("m4") Then

' Stop

' End If

End If

Next

End With

MsgBox ("Your Worksheets have been copied to C:\New Work Book.xls")

End Sub

Sort Excel workbook sheet alphabatically

2010-04-09T22:45:59-07:00


Sub Sort_Active_Book()
Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
'
' Prompt the user as which direction they wish to
' sort the worksheets.
'
iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
& "Clicking No will sort in Descending Order", _
vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
For i = 1 To Sheets.Count
For j = 1 To Sheets.Count - 1
'
' If the answer is Yes, then sort in ascending order.
'
If iAnswer = vbYes Then
If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
Sheets(j).Move After:=Sheets(j + 1)
End If
'
' If the answer is No, then sort in descending order.
'
ElseIf iAnswer = vbNo Then
If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
Sheets(j).Move After:=Sheets(j + 1)
End If
End If
Next j
Next i
End Sub

MIME - File Context Types

2010-04-09T23:22:48-07:00

Ai  application/postscript
aif  audio/x-aiff
aifc  audio/x-aiff
aiff audio/x-aiff
asc  text/plain
atom  application/atom+xml
au   audio/basic
avi   video/x-msvideo
bcpio   application/x-bcpio
bin   application/octet-stream
bmp   image/bmp
cdf   application/x-netcdf
cgm   image/cgm
class   application/octet-stream
cpio   application/x-cpio
cpt   application/mac-compactpro
csh   application/x-csh
css   text/css
dcr   application/x-director
dif   video/x-dv
dir   application/x-director
djv   image/vnd.djvu
djvu   image/vnd.djvu
dll   application/octet-stream
dmg   application/octet-stream
dms   application/octet-stream
doc   application/msword
dtd   application/xml-dtd
dv   video/x-dv
dvi   application/x-dvi
dxr   application/x-director
eps   application/postscript
etx   text/x-setext
exe   application/octet-stream
ez   application/andrew-inset
gif   image/gif
gram   application/srgs
grxml   application/srgs+xml
gtar   application/x-gtar
hdf   application/x-hdf
hqx   application/mac-binhex40
htm   text/html
html   text/html
ice   x-conference/x-cooltalk
ico   image/x-icon
ics   text/calendar
ief   image/ief
ifb   text/calendar
iges   model/iges
igs   model/iges
jnlp   application/x-java-jnlp-file
jp2   image/jp2
jpe   image/jpeg
jpeg   image/jpeg
jpg   image/jpeg
js   application/x-javascript
kar   audio/midi
latex   application/x-latex
lha   application/octet-stream
lzh   application/octet-stream
m3u   audio/x-mpegurl
m4a   audio/mp4a-latm
m4b   audio/mp4a-latm
m4p   audio/mp4a-latm
m4u   video/vnd.mpegurl
m4v   video/x-m4v
mac   image/x-macpaint
man   application/x-troff-man
mathml  application/mathml+xml
me   application/x-troff-me
mesh   model/mesh
mid   audio/midi
midi   audio/midi
mif   application/vnd.mif
mov   video/quicktime
movie   video/x-sgi-movie
mp2   audio/mpeg
mp3   audio/mpeg
mp4   video/mp4
mpe   video/mpeg
mpeg   video/mpeg
mpg   video/mpeg
mpga   audio/mpeg
ms   application/x-troff-ms
msh   model/mesh
mxu   video/vnd.mpegurl
nc   application/x-netcdf
oda   application/oda
ogg   application/ogg
pbm   image/x-portable-bitmap
pct   image/pict
pdb   chemical/x-pdb
pdf   application/pdf
pgm   image/x-portable-graymap
pgn   application/x-chess-pgn
pic   image/pict
pict   image/pict
png   image/png
pnm   image/x-portable-anymap
pnt   image/x-macpaint
pntg   image/x-macpaint
ppm   image/x-portable-pixmap
ppt   application/vnd.ms-powerpoint
ps   application/postscript
qt   video/quicktime
qti   image/x-quicktime
qtif   image/x-quicktime
ra   audio/x-pn-realaudio
ram   audio/x-pn-realaudio
ras   image/x-cmu-raster
rdf   application/rdf+xml
rgb   image/x-rgb
rm   application/vnd.rn-realmedia
roff   application/x-troff
rtf   text/rtf
rtx   text/richtext
sgm   text/sgml
sgml   text/sgml
sh   application/x-sh
shar   application/x-shar
silo   model/mesh
sit   application/x-stuffit
skd   application/x-koan
skm   application/x-koan
skp   application/x-koan
skt   application/x-koan
smi   application/smil
smil   application/smil
snd   audio/basic
so   application/octet-stream
spl   application/x-futuresplash
src   application/x-wais-source
sv4cpio application/x-sv4cpio
sv4crc  application/x-sv4crc
svg   image/svg+xml
swf   application/x-shockwave-flash
t    application/x-troff
tar   application/x-tar
tcl   application/x-tcl
tex   application/x-tex
texi   application/x-texinfo
texinfo application/x-texinfo
tif   image/tiff
tiff   image/tiff
tr   application/x-troff
tsv   text/tab-separated-values
txt   text/plain
ustar   application/x-ustar
vcd   application/x-cdlink
vrml   model/vrml
vxml   application/voicexml+xml
wav   audio/x-wav
wbmp   image/vnd.wap.wbmp
wbmxl   application/vnd.wap.wbxml
wml   text/vnd.wap.wml
wmlc   application/vnd.wap.wmlc
wmls   text/vnd.wap.wmlscript
wmlsc   application/vnd.wap.wmlscriptc
wrl   model/vrml
xbm   image/x-xbitmap
xht   application/xhtml+xml
xhtml   application/xhtml+xml
xls   application/vnd.ms-excel
xml   application/xml
xpm   image/x-xpixmap
xsl   application/xml
xslt   application/xslt+xml
xul   application/vnd.mozilla.xul+xml
xwd   image/x-xwindowdump
xyz   chemical/x-xyz
zip   application/zip

Read - Write SMTP settings Web.Config with Asp.net runtime

2010-04-09T22:48:25-07:00

//Read SMTP Settings

System.Configuration.Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
System.Net.Configuration.MailSettingsSectionGroup settings = (System.Net.Configuration.MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings");
txtSmtpHostAddr.Text = settings.Smtp.Network.Host;
txtSmtpUserName.Text = settings.Smtp.Network.UserName;
txtSmtpPortNo.Text = settings.Smtp.Network.Port.ToString();
txtSmtpEmail.Text = settings.Smtp.From;

//Write SMTP Settings

System.Configuration.Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
System.Net.Configuration.MailSettingsSectionGroup settings = (System.Net.Configuration.MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings");
settings.Smtp.Network.Host = txtSmtpHostAddr.Text.Trim();
settings.Smtp.Network.UserName = txtSmtpUserName.Text.Trim();
settings.Smtp.Network.Password = txtSmtpPassword.Text.Trim();
settings.Smtp.Network.Port = txtSmtpPortNo.Text == "" ? 25 : Convert.ToInt32(txtSmtpPortNo.Text.Trim());
settings.Smtp.From = txtSmtpEmail.Text.Trim();
config.Save();

Read,Write,Edit Resource File Asp.Net C#

2009-08-26T22:08:11-07:00

//READ RESOURCE

ResXResourceReader reader = new ResXResourceReader(Server.MapPath("~/App_GlobalResources/test.resx"));

IDictionaryEnumerator ide = reader.GetEnumerator();

int i = 0;

//COUNTING FOR THE RESOURCE KEYS

while (ide.MoveNext())

{

i++;

}

//ASSIGN THE DICTIONARY ENTRY ARRAY FOR STORING KEYS

DictionaryEntry[] de = new DictionaryEntry[i];

i = 0;

//RESET DICTIONARY TO INITIAL POSITION

ide.Reset();

while (ide.MoveNext())

{

de[i] = ide.Entry;

Response.Write(ide.Key + " - " + ide.Value);

}

reader.Close();

//WRITE RESOURCE

ResXResourceWriter writer = new ResXResourceWriter(Server.MapPath("~/App_GlobalResources/test.resx"));

foreach (DictionaryEntry del in de)

{

//YOUR CODE HERE IF YOU WANT TO CHANGE VALUES

writer.AddResource(del.Key.ToString(), del.Value.ToString() + "*");

}

//SAVE CHANGES

writer.Generate();

//CLOSE RESOURCE FILE

writer.Close();

//DESPOSE RESOURCE

writer.Dispose();

Drop Everything in SQL Server 2005 Database

2010-04-09T23:06:51-07:00

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = 'DROP PROCEDURE [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Procedure: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP VIEW [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped View: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP FUNCTION [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Function: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = 'ALTER TABLE [' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
EXEC (@SQL)
PRINT 'Dropped FK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
END
GO
/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = 'ALTER TABLE [' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
EXEC (@SQL)
PRINT 'Dropped PK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
END
GO
/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP TABLE [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Table: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO