<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStringsemoProjectConnectionString %>" SelectCommand="SELECT LEFT (convert(varchar, DateOn,13),20) as DateOn,
LEFT (convert(varchar, DateOff,13),20) as DateOff,
(SELECT SymbolicTextTranslations.TranslationText FROM DemoProject.dbo.SymbolicTextTranslations WHERE (SymbolicTextTranslations.SymbolicTextID = Alarms.AlarmTypeID AND SymbolicTextTranslations.LanguageID ='%LID%'))As AlarmType,
(SELECT SymbolicTextTranslations.TranslationText FROM DemoProject.dbo.SymbolicTextTranslations WHERE (SymbolicTextTranslations.SymbolicTextID = Alarms.AlarmID AND SymbolicTextTranslations.LanguageID ='%LID%')) As Description

i want to ask if the red color syntax is correct. I want to get a different language from there. As I click a button in different frame, I want to put the value from the button to the asp. Can anyone help me?