Working with data in databases could be very intensive and complex especially if you do not have experience and routine.
We still grow our knowledgebase with real-life examples that you could use. One of our favorite SQL tips and tricks is how to delete duplicate records in SQL.
Inforbiro is an Information Technology and Marketing Agency with its own Internet marketing network BlicKlik. We have a lot of experience in software development as well as in Internet marketing and advertising. We constantly try not only to develop great web sites, mobile, desktop or facebook applications but also to share our knowledge.
In one of our previous articles we described how to add values to ComboBox together with Ids in C# using class for keeping Id and Value.
Simillar to this logic, you can easily find yourself in a situation that you need to sort values in the list by some of the class property.
Here is, by our opinion, the easiest way for sorting a list collection of classes by some of its properties in C#. In this example we'll use "Name" as a class' property.
Combobox is a C# class that displays values in a dropdown list. Usually, it keeps simple string data only, but often we need to know an identificator of selected string value.
This article contains information how to add values with Id to combobox in C#. The trick is to use a class with properties, Id and Name and to add an instance of the class as the combobox item.
A very common question regarding integer datatype in MySQL is: "Are INT(1) and INT(10) the same?" or "What is difference between INT(1) and INT(10)?"
The answer is YES, they are actually exactly the same!
An unsigned int uses 4 bytes of data and it has the max value of 4294967295. It doesn't matter whether it is represented as INT(1) or INT(10)