Padding is often a programmers best friend. If you have ever worked with data then you have received different formats and different datatypes. Whether it’s an integer field, char field, or nvarchar field, padding will help you format the results into a common length for consistent display or storage. For example, you have a Member …
XSD Disconnected data sets can be quite tricky when calling from a web application. In this final post I will show how to call a Crystal Report from a web server using a disconnected XSD datasource. XSD Code Follow-up In my sample code I used several field names to enter in the name of the …
XSD Disconnected Crystal Report DataSource Part 2 Read More »
An XSD disconnected datasource is a datasource that will execute at run time. It will use an XML Schema Definition file. Typically, with SAP Crystal Reports, you create a report with a database connection, a data source and a dataset at design time. The report can be published with the ability to be executed without …
XSD Disconnected Crystal Report DataSource Part 1 Read More »
Although many people may look at a set of zero’s and ones and say “How could anyone know what this means?” I am here to tell you that it is not very hard to read binary. Each binary “number” is a byte, which traditionally contains 8 bits or zeros and ones. A byte can only …
Conditioning can be used by storing lookup values in a database in order to populate a DropDownList control. This allows the use enums. On the code side, creating an enum will enable a quick and easy conditioning for identifying values. What is an Enum? An enum is a value type with a set of related …
Self-redirection in ASP.NET is useful when you want to refresh your page. You can reset a page to it’s initial state in ASP.NET by redirecting to itself. Here are 3 ways you can do it: 3 Self-Redirection Examples A redirect does not do a postback, as a result, I consider it a hard refresh of …
Customizing your web.config is an easy way to make changes to your web site. Not only can you set app values, connection strings and such, but you can also make security configurations to your web site. I’ve listed various examples below. Force your web site to transmit cookies over SSL. Custom Headers, auto-redirect, and same-site …
If you use AJAX in your ASP.NET web site then you’ve probably used the UpdateProgress control to display that some action is processing in the background. I typically like to use a “loading” image or perhaps the company logo along with an animated gif in a modal style box to show some movement that the …
Retrieving binary from a database is often a necessity in online application development. For accessibility reasons you can store PDF files in a database so they can be retrieved quickly without relying on a file system that is not accessible. What is varbinary? In SQL Server I like to store these files in a “varbinary(max)” …