ASP.NET（非MVC）多语言Web应用开发需求（无需资源文件）

Hey there! Let's figure out how to build your multi-language ASP.NET Web Forms app without relying on resource files—since you mentioned they're too time-consuming for your large set of text content. Below are two practical approaches you can use, depending on whether you prefer hardcoding or database storage:

If your text content doesn't change often, storing translations in a static class is a quick, low-overhead option. Here's how to set it up:

Step 1: Create a static class for language strings #

This class will hold all your translated key-value pairs for each language:

public static class LanguageStrings
{
    // Nested dictionary: [LanguageCode][ContentKey] = TranslatedText
    public static Dictionary<string, Dictionary<string, string>> AllLanguages = new Dictionary<string, Dictionary<string, string>>()
    {
        {
            "en", new Dictionary<string, string>()
            {
                {"WelcomeMessage", "Welcome to our app!"},
                {"SubmitButton", "Submit"},
                {"UserTableHeader", "User Data"},
                {"ErrorMessage", "Please fill in all required fields."}
                // Add all your text keys here
            }
        },
        {
            "fr", new Dictionary<string, string>()
            {
                {"WelcomeMessage", "Bienvenue dans notre application !"},
                {"SubmitButton", "Soumettre"},
                {"UserTableHeader", "Données utilisateur"},
                {"ErrorMessage", "Veuillez remplir tous les champs obligatoires."}
            }
        },
        {
            "nl", new Dictionary<string, string>()
            {
                {"WelcomeMessage", "Welkom bij onze app!"},
                {"SubmitButton", "Indienen"},
                {"UserTableHeader", "Gebruikersgegevens"},
                {"ErrorMessage", "Vul alle verplichte velden in."}
            }
        }
    };

    // Helper method to fetch the right string
    public static string GetString(string languageCode, string key)
    {
        if (AllLanguages.ContainsKey(languageCode) && AllLanguages[languageCode].ContainsKey(key))
            return AllLanguages[languageCode][key];
        return key; // Fallback to the key itself if translation is missing
    }
}

Step 2: Add a language dropdown to your ASPX page #

Include a dropdown that triggers a postback when the user selects a language:

<asp:DropDownList ID="ddlLanguages" runat="server" AutoPostBack="true" 
                  OnSelectedIndexChanged="ddlLanguages_SelectedIndexChanged" 
                  CssClass="language-dropdown">
    <asp:ListItem Value="en" Text="English" Selected="True"></asp:ListItem>
    <asp:ListItem Value="fr" Text="Français"></asp:ListItem>
    <asp:ListItem Value="nl" Text="Nederlands"></asp:ListItem>
</asp:DropDownList>

Step 3: Handle language switching and update page text #

In your code-behind, save the selected language to Session (or Cookie for persistent sessions) and update all control texts when the language changes:

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // Set default language if no session exists
        if (Session["CurrentLanguage"] == null)
            Session["CurrentLanguage"] = "en";
        
        ddlLanguages.SelectedValue = Session["CurrentLanguage"].ToString();
        UpdatePageTexts();
    }
}

protected void ddlLanguages_SelectedIndexChanged(object sender, EventArgs e)
{
    Session["CurrentLanguage"] = ddlLanguages.SelectedValue;
    UpdatePageTexts();
}

// Method to update all text on the page
private void UpdatePageTexts()
{
    string currentLang = Session["CurrentLanguage"].ToString();
    
    // Update labels, buttons, table headers, etc.
    lblWelcome.Text = LanguageStrings.GetString(currentLang, "WelcomeMessage");
    btnSubmit.Text = LanguageStrings.GetString(currentLang, "SubmitButton");
    gvUsers.HeaderRow.Cells[0].Text = LanguageStrings.GetString(currentLang, "UserTableHeader");
    lblError.Text = LanguageStrings.GetString(currentLang, "ErrorMessage");
    
    // Repeat this for every text control on your page
}

If you have a lot of text or need to update translations without redeploying, storing content in a database is the way to go. Here's a step-by-step setup:

Step 1: Create database tables #

First, create two tables to store language metadata and translated content:

-- Table for language definitions
CREATE TABLE Languages (
    LanguageId INT PRIMARY KEY IDENTITY(1,1),
    Code VARCHAR(5) NOT NULL UNIQUE, -- e.g., en, fr, nl
    DisplayName NVARCHAR(50) NOT NULL -- e.g., English, Français, Nederlands
)

-- Table for translated content
CREATE TABLE LanguageContents (
    ContentId INT PRIMARY KEY IDENTITY(1,1),
    LanguageId INT FOREIGN KEY REFERENCES Languages(LanguageId),
    ContentKey VARCHAR(100) NOT NULL, -- Unique key for each text (e.g., WelcomeMessage)
    ContentValue NVARCHAR(MAX) NOT NULL, -- The translated text
    UNIQUE(LanguageId, ContentKey) -- Prevent duplicate keys per language
)

Populate the Languages table with your three languages, then add all your translated content to LanguageContents.

Step 2: Create a helper class to fetch content #

This class will handle database calls (and optional caching to reduce DB load):

public static class LanguageHelper
{
    // Cache to store content and avoid repeated DB queries
    private static Dictionary<string, Dictionary<string, string>> _cachedContent;

    // Initialize cache on first use
    private static void LoadCache()
    {
        if (_cachedContent != null) return;
        
        _cachedContent = new Dictionary<string, Dictionary<string, string>>();
        string connString = ConfigurationManager.ConnectionStrings["YourAppConnectionString"].ConnectionString;
        
        using (SqlConnection conn = new SqlConnection(connString))
        {
            string query = @"
                SELECT l.Code, lc.ContentKey, lc.ContentValue
                FROM LanguageContents lc
                JOIN Languages l ON lc.LanguageId = l.LanguageId";
            
            using (SqlCommand cmd = new SqlCommand(query, conn))
            {
                conn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                
                while (reader.Read())
                {
                    string langCode = reader["Code"].ToString();
                    string contentKey = reader["ContentKey"].ToString();
                    string contentValue = reader["ContentValue"].ToString();
                    
                    if (!_cachedContent.ContainsKey(langCode))
                        _cachedContent[langCode] = new Dictionary<string, string>();
                    
                    _cachedContent[langCode][contentKey] = contentValue;
                }
            }
        }
    }

    // Get translated content from cache (or DB if cache is empty)
    public static string GetContent(string languageCode, string contentKey)
    {
        LoadCache();
        
        if (_cachedContent.ContainsKey(languageCode) && _cachedContent[languageCode].ContainsKey(contentKey))
            return _cachedContent[languageCode][contentKey];
        
        return contentKey; // Fallback to key if translation is missing
    }

    // Optional: Refresh cache if you update content in the database
    public static void RefreshCache()
    {
        _cachedContent = null;
        LoadCache();
    }
}

Step 3: Integrate with your page #

Use the same dropdown from方案1, then update the UpdatePageTexts method to use the database helper:

private void UpdatePageTexts()
{
    string currentLang = Session["CurrentLanguage"].ToString();
    
    lblWelcome.Text = LanguageHelper.GetContent(currentLang, "WelcomeMessage");
    btnSubmit.Text = LanguageHelper.GetContent(currentLang, "SubmitButton");
    gvUsers.HeaderRow.Cells[0].Text = LanguageHelper.GetContent(currentLang, "UserTableHeader");
    lblError.Text = LanguageHelper.GetContent(currentLang, "ErrorMessage");
    // ... update all other controls
}

You can also call LanguageHelper.RefreshCache() in an admin page if you need to update translations without restarting the app.

Bonus Tips #

• Use Cookie instead of Session if you want the user's language preference to persist across browser sessions.
• For very large pages, consider creating a base page class that handles text updates, so you don't repeat code in every page.
• Add a fallback language (like English) to ensure users always see readable text if a translation is missing.

内容的提问来源于stack exchange，提问作者satish ganai