Question Fill DataGridView from text field

[zakaryahelal]

Please help me out!
Am using VB.NET 2008 with SQL Sserver DataBase and I have table contain a field like this

ADRB|MBP|ADRB>5>1.680000>50000>1>1.670000>1>14851>2>1.660000>107205>5>1.650000>270000>3>1.640000>55000>2>5>1.700000>50000>1>1.710000>1453>1>1.720000>50000>1>1.740000>35000>2>1.750000>59788>3>

.. Now, I have DataGridView which contain 7 columns which are Name, Kind, Symbole,BidQuantity,BidPrice,AskQuantity and AskPrice.
My headache now is, how to filled the DataGridView by the above textField.
Like this Example in attachement

Is that really possible? Help me out Plz.

Thanks in advance.

The data must be in this format

 

[cjard]

What a headache. Can you edit the db or must the data stay in this format?

 

[zakaryahelal]

Yes the data must be in this format

 

[cjard]

Just so I can get this straight in my mind:

You want to store data in a highly inflexible, unusable format and convert it for display every time display is required? Will the user also edit the data, and you will have to take their edits and store it back in the same highly inflexible format?

i.e. your data must always be stored like that and you want to be able to read and write it or just read it?


It would make far more sense to store it in a more usable format, and then report it in the inflexible format, to whichever system needs it in that format

 

[zakaryahelal]

Exaxtly as you saidthe data must always be stored like that and I just want to be able to read it in order to display in the attachment format

 

[Tom]

The data lines have almost 3 dozen possible fields but gets assigned to only 7 columns. According to your example, it does not appear to be the first 7 field values getting assigned to columns. So what is the determining factor for which field values gets assigned to which columns?