If you code in JavaScript, you will notice that the display of dates and times in this programming language is not standard. Numbers are displayed as integers, not characters. But how to display zeros in front of the numbers down 10? We will answer this question by a simple example.…
If you create custom controls in ASP.NET, you will probably, sooner or later, be dealing with HtmlTextWriter. This tool allows you to generate HTML tags. It is better, comparing to StringBuilder, because it allows to build a nicely indented markup. In this example, we’ll show you how to debug it, in order…
While analyzing or debugging an application, you surely already had to search for a certain column, or field, referring to a database. The common task is to find all the tables, having that exact column name, to which the code is pointing to. If you’ll search for it manually throughout…
If you are a journalist, a student, or a business oriented person, you are probably have a need to take notes, and document them. Taking notes in our daily life can be done in various ways, from the simple handwriting to audiovisual recording. Text documents, however, are still the most popular…
In this article we will show you how to display the current year in the footer section of your website. If you have a website, you certainly have an area dedicated to copyright, somewhere at the bottom of the page. It may happen that the year, that is shown there,…
For developers and analysts working with large databases, there is often a need to examine the structure of the database. In this article, we will show you how to do this using SQL queries. Although we can use visual objects explorer to see the contents of our database, we can…
When programming in object-oriented, it is good practice to have in each entity class the method that will display the contents of our object. This method is named ToString (). Although it already exists by default in modern languages high level as Java or C #, it is not representative. So…
Sometimes we can face database blocking issue in SQL Server when trying to perform some job or do a safety backup. Most often we are told that the database is in use, when in truth nothing and no one uses it. To remedy the problem, we can just run two…
When working with large volumes of data, it happens to have duplicates at the tables level in the database. Therefore it could lead to exceptions in the code and incorrect statistics. In the following lines we show you how to detect duplicates and how to remove them. How to manage…