C#

f_textinenglish,f_language_code,f_texttranslated<br />
<br />
welcome             101            welcome<br />
welcome             102            bienvenida<br />
welcome             103            welkom

Arunkumar.Koloth wrote:

Hai thank you for your answers guys

Arunkumar.Koloth wrote:

can anyone Help me by a small exmple?

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SQLite;

namespace sample
{
    class translation
    {

        private SQLiteConnection sql_con;
        private SQLiteCommand sql_cmd;
        private SQLiteDataAdapter DB;
        private SQLiteDataReader dr;

        public void LoadTranslations(int languagecode)
        {
            string[] TextinTranslatedArray = new string[200];
            string[] TextinEnglishArray = new string[] { "Admin","User","ZHome","UserName"};

            for (int i = 0; i < TextinEnglishArray.Length; i++)
            {
                string sql;
                sql = "SELECT f_text_translated FROM t01_text_translation WHERE f_text_english='" + TextinEnglishArray[i] + "'AND f_language_code='" + languagecode + "'";
                sql_cmd = sql_con.CreateCommand();
                sql_cmd.CommandText = sql;
                dr=sql_cmd.ExecuteReader();
                TextinTranslatedArray[i] = dr.GetValue(0).ToString();
            }

            sql_con.Close();
        }
         private void SetConnection()
        {
            sql_con = new SQLiteConnection("Data Source=DATA.sl3;Version=3;New=False;Compress=True;");
        }


    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace sample
{
    class tr=new translation();
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
    }
}

Error	3	{ expected	C:\Users\arun\Documents\Visual Studio 2005\Projects\sample\sample\Form1.cs	11	13	sample<br />
Error	4	Invalid token '=' in class, struct, or interface member declaration	C:\Users\arun\Documents\Visual Studio 2005\Projects\sample\sample\Form1.cs	11	13	sample<br />
Error	5	Class, struct, or interface method must have a return type	C:\Users\arun\Documents\Visual Studio 2005\Projects\sample\sample\Form1.cs	11	18	sample<br />
Error	6	} expected	C:\Users\arun\Documents\Visual Studio 2005\Projects\sample\sample\Form1.cs	24	2	sample

Arunkumar.Koloth wrote:

class tr=new translation();

public partial class Form1 : Form
{
    translation tr = new translation();

    public Form1()
    {
    }
}

overloaded Name wrote

SQL

CREATE PROCEDURE [dbo].[ShowStudent] AS
SELECT * FROM StudentInfo

...

C#

SqlConnection connection = new SqlConnection("Data Source=MUZE-LAPTOP\\SQLEXPRESS; Initial Catalog=StudentInfo;Integrated Security=SSPI;");

public partial class Trophy

Trophy tp1 = new Trophy();
Trophy tp2 = new Trophy();

tp1.theTrophyLevel = Trophy.TrophyLevel.Platinum;
tp2.theTrophyLevel = Trophy.TrophyLevel.Silver;

String level = tp1.theTrophyLevel.ToString();