Hi,
I can't figure out how to build a string based on the requirements
described below:

First here are my SQL tables:

Fields (FieldId, FieldName)
ConstraintMessage (Id, FieldId, FieldPosition, Message)

Basically, the user can build a ConstraintMessage by dragndropping
FieldNames from a listbox to a textbox. The textbox can also be edited
in order to make the ConstraintMessage more complex.

As you can see, only the FieldId of the dragndropped fields are stored
in [ConstraintMessage] as well as its position in the message.
'Message' is used to store the text entered directely in the textbox.

When a ConstraintMessage is built in order to be displayed on the
screen, it's a matter of inserting the right 'FieldName' at the right
'MessagePosition' in 'Message'.

The difficult thing is that, when you restore the ConstraintMessage, a
Field might have been deleted from Fields or a FieldName might have
change since the day the ConstraintMessage was built.

I hope it's clear enough.  How to do that in Vb.net ?

Thank you.

<samuelberthe***@googlemail.com> wrote in message
A couple of examples would help.

Display the contents of a folder in a listbox?
how to prevent multiple instances of 2nd form?
aggregation simple .net code
column subtotals in a datagrid
reuse query results for multiple object populations? (and dynamic variable names?)
Wordwrap in VB.Net listbox?
How do I extract a page from word and insert into a new word document using VB
OFF TOPIC: Famous failed IT projects
Webbrowser & XML
Reading dll-Functions and execute them