version 1.0.2005.1 final (self-servicing) VS2005 asp.net 2.0

hiya,

I have typedList, tListPerson

personId PK personName

I've been asked to display each person in a grid with their skills in the same field as that of their name,

eg "John (builder, baker)"

My schema is as follows:

tblPersonSkill personId PK skillId PK

tblSkill skillId PK skillName

Would it be possible to put these values into a field in a typedList?

Please le t me know if I should clarify.

Many thanks,

yogi

A new expression column would resolve the problem. However I think that isn't supported in 1.0.2005.1. You can still create a DB-View and map that to a LLBLGen TypedView.

Thanks Daelmo,

The thing is, I need to use a variable.Apparently, I can't do that in a view. Should I used a stored procedure instead?

Cheers,

yogi

Another path would be using a dynamic list so you can obtain the dataset in a DataTable and later on create a column in the data that contains that information, this of course would be somehow inefficient if the dataset is too large. May be you should consider upgrading to 2.5.

hiya,

Ok, I'm going to try the "expression" column with v2.5 I can't find "expression column" in the docs.

As I mentioned, I just want to add it as a field to the typedList.

Can anyone point me in the right direction?

many thanks,

yogi

hi, see this thread: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=8110&HighLight=1

hiya Goose,

I had already seen that thread when I was browsing thru, trying to find an answer.

I'm still confused though..When V2.5 was recommended to me, I naturally assumed that I'd be able to go in and add the "expression field" to the typedList via the designer.

I've been playing about with the v2.5 designer and looking at the docs, and I don'tknow if this is the case.

Are you saying that I have to go directly into the partial classes and start changing the code?

Thanks,

yogi

unfortunately this isn't possible through the designer, but it is very straightforward from the code, please give it a try, and let me know how this come up.

hiya Goose,

Ok, thanks for that.I'm a bit further down the road but will have to ask again. I think it's best if I start a new post.

cheers,

yogi