i am using vb.net and sql server 2000.
create table mytable(english varchar(20), state varchar(20);
insert into mytable values('he','pronoun')
insert into mytable values('is','verb')
insert into mytable values('running','verb')
insert into mytable values('fast','adjective')
then i have a textbox that accepts inputs that is textbox1.text
textbox1.text="he is running fast"
now i want to display this statement in other textbox that is in textbox2.text
as noun or pronoun first, adjective second, verb last(if we have two verbs,the verb with more character comes first before the verb with few character, is this case, 'running' should come first before 'is'), =
noun or pronoun PLUS adjective PLUS long verb PLUS short verb.
(in here long verb is 'running', short verb 'is', just by compare by their number of characters.)
therefore the above result should be as:
he fast running is.
i can split the statment to words as follow but i got it difficult to do the rest task.
dim mystr() as string =split(textbox1.text," ")

Your help is very appreciated!