C#. How to join in string array of int
We have array of int and want to write it to a variable or to show on display. It’s not so easy to do in one string as you can think at first. Below I wrote one of ways to do it. Read more»
Development
Regular Expressions in C#. Get text before specified character
Regular expressions is one of the best ways to work with text. One popular task for Regexp is to get a part of word or expression.Let’s try to get first part from word “Heli-copter”, the part that before character “-“. Read more»
jQuery. Colorize even and odd rows of table
Tables with at least 20 rows are more readable when its rows look like stripes – even row in one color, odd one in another. Before jQuery we used to add class to each row of table, we made “<tr class=”even”> …</tr>” and “<tr class=”odd”> …</tr>”. Now it’s much easier to do using jQuery. Read more»
Get all IP addresses from text C#
Using “System.Text.RegularExpressions” in C# you have a lot of abilities to work with text. One of practice of using System.Text.RegularExpressions is working with IP addresses. Read more»
Associative arrays in C# via IDictionary
There’re no associative arrays (hash) in common sense. There are Dictionaries for this. It’s a very good tool if you want to use link “key-value”. Using Dictionaries, keys and values can be different types. Read more»
C#. Add new line symbol to string
Each time I forget how to add new line symbol to string. I decided to add to memories. Below how to add new line symbol to string in C#. string message = Label1.Text; message = message.Replace("<br />", System.Environment.NewLine); Read more»
How to select all duplicates from Transact-SQL table on namesakes example
It’s a little tutorial about how to get all duplicate records on namesakes example from your database table. For example, we have a table with columns Id, FullName, Birthdate and Phone. Using ‘GROUP BY’ and ‘HAVING’ we can select all namesakes. Read more»
Concatenating NULL value columns in T-SQL
Concatenating of string columns is not very simple task in T-SQL if you don’t know ANSI standart of it. According to ANSI standart of SQL, concatenating of NULL-value is NULL in the result. It’s not clearly for developer, but it is so. Let’s see some features for work with concatenating NULL-value columns. For example, I […] Read more»
Transact-SQL string functions
This post is about which string functions there are in Transact-SQL. They allow to modify data you have, make custom queries to select records from database tables. To know them is very important for any developer – using string functions is very good way to decrease load from application server without adding it to SQL because […] Read more»
CASE conditions in Transact-SQL
Another way for using conditions in Transact-SQL besides IF…ELSE is CASE operator. The syntax is some different from IF…ELSE but in some cases more readable. CASE also uses the word “THEN”. Read more»