One of the feature of the application I’m working on these days is allowing the user to import data from Excel 2003 and 2007 files. After some research I found out that OLEDB is the only way to read both Excel formats without any problems.
When a GridView is used to display and manipulate data, the Delete button can be displayed next to each record to easily delete a single record, or at the bottom of the GridView to delete multiple records at once. I will show in this post 2 ways to implement the former.
In most cases some sections of the web.config file of an ASP.NET project need to be encrypted before moving project to a production server. The most important section to encrypt is the connectionString, because of the login information it contains. Here is a quick way to encrypt the sections you want, without adding or changing […]
One of the least documented features in ASP.NET is the way to move the user access and profiles tables in aspnetdb.mdf to a production SQL Server. Although aspnetdb.mdf can be used in production, it is not recommended. This is done in 2 steps, first create the structure (tables, views and stored procedures) in the database, […]
Travian the well known browser game has a downloadable file for developers in each of its servers that provides details of all the players of the server. The file contains a list of SQL INSERT statements, one for each player. Although the statement doesnt provide military or attack information, that can be used to cheat […]
The Microsoft Office Document Imaging library that is provided with Office 2003 and Office 2007, has Optical Character Recognition (OCR) that can extract text and layout from image files. As you can see from the code below, it doesnt need much to use it.
I thought of this solution when I was developing a website, and I was testing the contact us page. It was supposed to send an email with the details the user filled. But the emails were always late. So I created a table in the database of the application and saved the sent data there. […]