Drop-down list-of-values populated by database tables are another important component of enterprise-grade web frameworks. Although most frameworks do support them through one technique or other, the ease of implementation is key in this often-used feature.
Continue reading
A powerful database schema is one of the key components of an enterprise application. Using the database to enforce business logic and ensure data integrity enables both flexibility and scalability in application design. By coding business logic in both the database layer and application layer, the database has the flexibility to then also be used by other applications and processes without fear of corrupting data. In addition, other systems can take advantage of stored procedures or views that make future development easier, instead of the platform lock-in created by storing all business logic in the application itself.
Continue reading
Almost every modern programming language tutorial starts out with a short script that simply outputs the phrase “Hello World.” This sample code has been used so much that the phrase has become part of the computer programming lexicon – and its ubiquity has caused the words to lose much of their meaning. A stroll through the annals of programming history, however, give us a pleasant refresher of the true reason many of us started programming.
Continue reading
It’s often useful to import Excel files directly into an ASP.NET web application in order to simplify data entry. Excel makes it easier to manipulate data, and has far better integration with other apps than most web grids. As a result, integrating a web application with Excel lets users leverage the best features of a spreadsheet software, while taking advantage of the RDBMS and business logic in the web application.
Continue reading
ASP.NET is Microsoft’s flagship web development framework. Released together with the .Net framework in the early part of the twenty first century, it’s goal was to revolutionize web development and create a more structured and effective way of web development. Far from reaching its goals, the framework has turned into a bloated caricature of itself, unable to adapt to the times and requirements of modern software.
Continue reading
When developing web-based forms using the ASP.NET platform, one of the basic tools that is lacking from the framework is an effective search mechanism. Custom queries seem to have been neglected due to their apparent complexity, and their non-geometric fit into the ideology of most frameworks. Still, a good search tool is very useful to users for finding relevant data in a large database. As such, we have developed a few tools and methodologies to make search implementation easier in web applications.
Continue reading
