Html Code
<asp:DropDownList ID="ddlLangauge" runat="server" AutoPostBack="true">
<asp:ListItem Text="English" Value="1">
</asp:ListItem>
<asp:ListItem Text="French" Value="2"></asp:ListItem>
</asp:DropDownList>
<asp:Label ID="lblLangauge" runat="server"></asp:Label>
Code
protected void Page_Load(object sender, EventArgs e)
{
this.lblLangauge.Text = this.GetText("HomePage", "Body");
}
private string GetText(string pageId, string name)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select value from PageTexts where PageId= @pageId and Id= @id and name = @name", con);
cmd.Parameters.AddWithValue("@pageId", pageId);
cmd.Parameters.AddWithValue("@id", this.ddlLangauge.SelectedItem.Value);
cmd.Parameters.AddWithValue("@name", name);
con.Open();
string value = cmd.ExecuteScalar().ToString();
con.Close();
return value;
}
Namespaces
using System;
using System.Data.SqlClient;
using System.Configuration;