How to concat and find substring in listview

Question

0.00/5 (No votes)

See more:

Hi Expert,

I am developing c sharp application.

Now i am showing database results in Listview.

Like following,

C#

<%# Eval("category1")%>
<%# Eval("category2")%>
<%# Eval("category3")%>

Now I have to concat above 3 results with semicolumn separator and substring starting from 0 to 45.

How i can achieve like this.

Thanksssssssss in advance.

Posted 22-Sep-11 18:14pm

udusat13

Updated 22-Sep-11 18:27pm

Pravin Patil, Mumbai

v2

Add a Solution

2 solutions

Solution 2

Concatenation operator & is used to solve this problem

HTML

<![CDATA[<%= Eval("category1") & ";" & Eval("category2") & ";" & Eval("category3")%>]]>

Posted 22-Sep-11 18:31pm

Ganesan Senthilvel

Comments

udusat13 23-Sep-11 0:44am

Thanksssssssssssssssssss But Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. this exception was thrown;

please help me.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kris444 · Accepted Answer · 2011-09-22T18:29:00

Solution 1

Hi
string.Format("{0},{1},{2}",Eval("category1"),Eval("category2"),Eval("category3")).Substring(0,45)

Posted 22-Sep-11 18:29pm

kris444

Comments

udusat13 23-Sep-11 0:34am

Thanksssssssssssssssssss

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

this exception was thrown;
please help me.

kris444 23-Sep-11 0:43am

oops...
ok, what i suggest is have a property like

public string Categeory
{
get
{
string catText = string.Format("{0},{1},{2}", category1, category2, category3);
return catText.Length > 45 ? catText.Substring(0, 45) : catText;
}
}
and bind
<%= Eval("Categeory")>

udusat13 23-Sep-11 1:03am

thanksssssssssss for ur valuable time.

But still it giving same exception as above

kris444 23-Sep-11 1:06am

Hmmm....when you bind property of type string, it shouldn't give the same issue..

You added property in code-behind right?
and added

<%# Eval("Categeory")%> ?

udusat13 23-Sep-11 1:17am

thnksssss.
i have added the property code in code behind page.

and
<%# Eval("Categeory")%>
above line is added in listview.

then i start to tracing using breakpont but
<%# Eval("Categeory")%>

this line throw exception.

for simple
<%# Eval("categeory1")%><%,%> <%# Eval("categeory1")%><%,%> <%# Eval("categeory1")%>
working for me.but then it is problem to find substring.

kris444 23-Sep-11 2:00am

I guess you just need to specify

<%= Categeory %>

udusat13 23-Sep-11 2:37am

Ok

kris444 23-Sep-11 3:56am

DOes this mean it's working?

udusat13 23-Sep-11 4:59am

No sir/madam its not working.
Exception is gone but its showing blank string.

kris444 23-Sep-11 10:05am

Hmmm...It's working when i tested...Did you checked property Categeory is returning some value?

udusat13 26-Sep-11 3:22am

Thanks .......