Posted on October 31, 2016
If you get this error it means that the default values are missing from your database.
To resolve/fix the issue, just execute the following SQL code against your database:
('common', 1, 1),
('health monitoring', 1, 1),
('membership', 1, 1),
('personalization', 1, 1),
('profile', 1, 1),
('role manager', 1, 1);
Posted on December 09, 2016
In the past you had to retain the expanded state manually when the grid rebinds, but recently Telerik introduced a property named RetainExpandStateOnRebind. If it's true, the expanded state persists automatically.
Posted on June 03, 2017
Say that you have a comma-separated String containing user IDs like following:
String userIDs = "1,2,5,8,23,67,101";
and that you want to fetch those users without splitting and looping their IDs.
Usually you do use CharIndex to search the expression:
"SELECT * FROM Users WHERE CharIndex(CAST(userID AS varchar(8)) + ',', + @userIDs) > 0";
However if you execute the above query the last ID will be omitted YEAH it will be indeed because it checks against value + comma which does not match when it comes to 101.
FIX: add the missing comma to the end of the string:
command.Parameters.AddWithValue"@userIDs", userIDs + ",";
Hope this helps someone!