Hi , everybody

I have 2 Textbox and 1 Button , and Database containing 3 column (ID,words in English language,words in another language),then
I want code that
When i entered word in English Language in textbox1 then click the button
textbox2 appear on it the word in another langauge
I hope You understand ME .
i Know the idea in this program
the basic thing i use it is "Column ID"
i match between the Word in English Language and the Word in another Language Through "ID"
but i don't know how i write the code?????

Not sure where you are going wrong. Surely you just query the table: As an aside it seems like a poorly designed database schema, what happens if you want to add a language?

--

Joe (Microsoft MVP - XML)

I agree with Joe, your application will not scale well at all.

Consider your given table with this data:

ID English OtherLanguage
1 Fork Bifurcación <--Spanish
2 Fork Fourchette <--French
3 Fork Gabel <--German
*Translations provided from http://babelfish.altavista.com/

If I am a user of the application and I want the German equivelant how will I tell the program that? My guess is that you do something like this to assign the value to the second textbox:

txt2.Text = dt.Rows[0]["word"].ToString()

or you execute a scalar in which case the spanish version of the word would be the row returned (if you executed Joe's query)

You should probably have an additional field in your datatable something like LanguageID_fk (that would relate to a look up table of all languages) and then a combo box on your application to allow the user to select their desired language.

My 2 cents anyway.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========