How easily write the text of connection string
Create empty file and call it “test.udl”. In Windows it be with the icon like in Figure 1. UDL means “Universal data link” and open this file. This post is for registered users only. Read more»
Featured Posts
Recent Posts
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»
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»
Pack and unpack files in linux console using Tar
Some Linux-commands for work with archives from command line. In this tutorial we have this structure (Figure 1 and Figure 2): /home/alexey/Documents/mydir/ – is a directory for adding to archive. 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»