Infragistics and Currency Columns

2007-05-27T16:22:00.001-07:00

When using infragistics for columns that should format as currency, set the field format property to "C", without the quotes. No need to used formats as "$#0#.##" or whatnot, this will do it easier.

I've been using these formats and copy pasting them.. thus wasting valuable TIME. :-D

NetTiers and Custom Stored Procedures for Views

2007-05-27T15:53:00.000-07:00

When creating a grid or combo box grid for a list of records, rows a good norm is to do the following:

- Create a VIEW of the records and the layout we want to use for the grid.
- Create a stored procedure that selects all columns in the view by using any set of parameters.

The stored procedure should use the following naming convention so that nettiers will create the proper service and add it to other view services.:
- _{Name of view}_{stored procedure name}

Sample:
VIEW: VIEW_ActiveCustomers
SP: _VIEW_ActiveCustomers_GetByCustomerID

You can then use code like:
VIEW_ActiveCustomersService service = new VIEW_ActiveCustomersService();
VList customersView;
customersView = service.GetByCustomerID(1);

Development Journal

Infragistics and Currency Columns

NetTiers and Custom Stored Procedures for Views