Multi language

[alwinSCH]

Hi, Could anyone help me with: I have a table that has the following fields * Name --> the name of a label on my asp.net page * French --> the text that has to become in the text property of the label * English I get all my information through a datareader But i don't know how i could in a loop call all the labels on my page then check if the name of the label is the same as the name in the table If this is true then fill the text property of the label So my question is how do i have to call all the labels in one statemen ==> if object.id= datareader("name") then object.id.Text=datareader("french") endif Object.id has to be replaced by what??? Thanks, A.

[minhpc_bk]

If you are not familiar with the DataReader object, you can see MSDN[^]. In your case, the sample code can be something like this:

while (reader.Read())
{
string lblName = reader.GetString(0)// Assuming the Name is the first column.
Label label = Form1.FindControl(lblName);//Get reference to the label.

//Depending on which language is currenly selected, you can either choose English or French.
label.Text = reader.GetString(1) or reader.GetString(2);//For French.

}