Nebrom 0 Newbie Poster
i want to develop a dictionary and a statement  translator from english language to my  own language that is Amharic.
i am using sql server 2000 and vb.net.
first i created table.
create table mytable(english varchar(100), amharic varchar(100))
then i insert data as
insert into mytable values('pretty','konjo')
i will have not less than 15,000 records .
then when i need english to translate to amharic, i simply  will do
 as  follow if i am not wrong.
dim str as string
str="select amharic from mytable where english =' "&textbox1.text&" ' "
then  when i want to translate statement like
textbox1.text= If I do this translation, we all will be brave.
then  i expect their translated meaning in my own  langauge that  is amharic.
so can you help a brief hint or code how can i develop this language translator using vb.net?
Thanks a lot!
.