retrieve data in multiple languages from sql server

You cannot convert some data on the fly from one language to other. You are storing the data in English and so retrieving in any language would give you English text only. Even if you localize your database - it will just hole the data in that localized language and not convert anything coming into it from another language.

If you need translation of data then you need to do it by yourself in code and then store the same. Or translate it before showing back. Generally, defined words or sentences can be easily localized but translating a free form text which can be anything entered by the user would be difficult to do.

For one of my projects i once used google translate services. Though not very accurate, as long as your grammar is very strict on your website "da beatz is jammin on da streetz" will most likely not work.

But this way you dont need to set up a database as it is constantly improved.

But if you are going for the multilingual option and doing it yourself. you are going to need to for each content variation include a foreign key to language and combine the foreign key with the current primary key.

eg:

Content table
Fields:
id (pk)
langid (fk)(pk)
content


Language table
Fields:
langid(pk)
name

Try this. Hope it works..

Using System.Data.SqlClient;

1.)

string constr ="server=your_server_name; DataBase=database_name; uid=; pwd=;" ;
SqlConnection conn = new SqlConnection(constr);
string cmdstr = "select *from table";
SqlDataAdapter da = new SqlDataAdapter(cmdstr,conn);
DataSet ds = new Dataset();
da.Fill(ds,"table");
Datatable dt = ds.Tables["table"];

dt.Rows[0][0] = TextBox1.Text;

con.Dispose();

2.)
Then Use the same code, just modify the statement:

TextBox1.Text = dt.Rows[0][0].ToString();