Help!! [RESOLVED]

[nokia8210]

i've got a table on sql that holds over 9000 names they are all one string i.e. mr j j Smith, etc.

i need to read the table into a dataset split the string then feed that data into a new dataset can you help me????

once i've done that i need to update another table using the diferent columns.

any idea's have tried the obvious one of filling a dataset the using a split function but i don't know where to go after that any ideas?

[salvelinus]

If I understand you correctly, you're already filling the dataset with the original strings, and then splitting each string from that dataset.
Why not just read the split items into the second table w/o another dataset? If you need it in a dataset, create a new one from the new table.

[Pirate]

How do you want to split the string (the final result of the string)?
Like this ?
Mr.
j
j
...etc

[nokia8210]

yes i need to split it up like that pirate i think i know where i'm going wrong now will post again if i have problems.

[Pirate]

Originally posted by nokia8210
yes i need to split it up like that pirate i think i know where i'm going wrong now will post again if i have problems.

Little hint : You can use Split(" ".ToCharArray)

[nokia8210]

thanks everyone got it working now needed to do it in three steps rather than one.