Blog Posts List

Full Name – get rid of the empty space if middle name is null

by Yugolancer

Posted on March 06, 2016

I see people bother with checking against NULL, using Coalesce, Substring etc. etc.

The solution is pretty simple actually. You just need to replace the two empty space by one if the middle name is null or empty e.g.


FullName = (reader["FirstName"].ToString() + " " + reader["MiddleName"].ToString() + " " + reader["LastName"].ToString()).Replace("  ", " ");


REPLACE(FirstName + ' ' + MiddleName + ' ' + LastName + ' ' + Suffix, '  ', ' ') AS FullName

Read More

The SqlMembershipProvider requires a database schema compatible with schema version 1

by Yugolancer

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);

Read More

System.InvalidOperationException – Eval(), XPath(), or Bind()

by Yugolancer

Posted on February 04, 2016

If you get the following error you are about to get the solution either :)

Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.


Usually it happens when you directly call say an Eval() function in the code-behind.

For example, you may have a GridView control with a label inside of the Template column:

<asp: id=" lblDescription " runat=" server " text="< %# Eval('Description') % >"></asp:>


Then for some reason you decide to move that to the code-behind AS IS so you say:

Dim lblDescription As Label = CType(e.Item.FindControl("lblDescription"), Label)
lblDescription.Text = Eval("Description").ToString()

Your project will compile but as soon as you try to open the certain Page, an exception ‘System.InvalidOperationException’ will be thrown.


Just replace Eval() with DataBinder.Eval() making your code to looks like this:

Dim lblDescription As Label = CType(e.Item.FindControl("lblDescription"), Label)
lblDescription.Text = DataBinder.Eval(dataItem.DataItem, "Description").ToString()

Voila! Your problem has been solved.

Read More

Retrieve data contained in a comma-delimited list of values Warning!


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:

command.CommandText = 
    "SELECT * FROM Users WHERE  CharIndex(CAST(userID AS varchar(8)) + ',', + @userIDs) > 0";
command.Parameters.AddWithValue"@userIDs", userIDs;

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!

Read More

Order By Except certain records


Posted on September 17, 2017

  CASE WHEN NameEN = 'Switzerland' THEN 0 ELSE 1 END, NameEN

Read More

Page 1 of 1

Copyright © ASPNETer 2006 - 2016