Category Archives:

PeopleCode is an (ool) object-oriented proprietary (case-insensitive) language used to express business logic for PeopleSoft applications. In its fundamentals, PeopleCode syntax resembles other programming languages. Some aspects of the PeopleCode language, however, are specifically related to the PeopleTools environment. However, the fundamentals of objects and classes are the same as in Java language. Definition name […]

In this article, I am going to demonstrate an example on how to populate dropdown based on another dropdown. Database Connection: I am going to use AdventureWorks for this example. Add the following connectionstring element to the web.config. Page Design: I have created a simple page with couple of dropdowns ddlCountry and ddlState. Onselectedindexchanged event […]

In this article I am going to explain how to get stored procedure schema. Basically we are not interested in the result set, just the schema of the result returned. What you do with the schema is, I leave it to your imagination. I am going to use AdventureWorks for my example. So add the […]

It is a shame that we cannot add a row to the top of Grid without explicitly pushing all the remaining rows down. It would have been good if Microsoft provide us way of doing it without this additional plumbing work. Since they are busy Windows 8 launch, we have to do it ourselves. I […]

A Grid can be used to design complicated user interfaces where we need to place multiple elements in a tabular for of rows and columns layout. In this article, I am going to demonstrate an example which would explain how to add rows to grid dynamically. Example Overview: In this example, we fetch list of […]

sp_MSforeachtable allows you to easily process statements against every table in a single database. This could also be done via cursor, but why sweat when we have this stored procedure which has many provisions and options. Parameters sp_MSforeachtable @command1, @replacechar, @command2, @command3, @whereand, @precommand, @postcommand @command1 nvarchar(2000) – is the first command to be executed […]

Be sure to add proper meta tags to your web page, if you would like your page to get higher ranking in search engine results. In this article, I am store meta tags in a table and then dynamically add meta tags to web page based on the page name. What Are Meta Tags? Meta tags […]

The ASP.NET Repeater Control is a data container control that allows you to create custom lists from any data available to the page. It basically repeats the data-bound template without applying any additional formatting. We have to set the format ourselves by explicitly applying templates or html markup. In the following example, I am going […]