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.
Cause:
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.
Solution:
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
by
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
by
Posted on September 17, 2017
SELECT
NameEN
FROM
Country
ORDER BY
CASE WHEN NameEN = 'Switzerland' THEN 0 ELSE 1 END, NameEN
Read More