We are In many sites to save HINDI data in SQL data base. But is too difficult to insert HINDI font in data base. I am tried to solve this problem. Then he work exactly .
Firstly create one table tbhindi in sql 2000
Firstly create columns sno , username, fullname
In fullname column I store Hindi (UNICODE)
Fullname column DATA TYPE (nvarchar), after then create new WEBSITE.
In A Website
Firstly u add Google API for translate English to any language . on this location click on this link
http://code.google.com/p/google-language-api-for-dotnet/downloads/detail?name=GoogleTranslateAPI_0.1.zip
on this link you download GoogleTranslateAPI_0.1.zip folder. Then create in website bin folder and put GoogleTranslateAPI.dll & Newtonsoft.Json.dll. After adding bin folder with .dll then you create your .aspx page
In .aspx page
Firstly Add control one textbox , Button , Label , Girdview, After Naming on control write code on Button.
On a Button1_Click
protected void Button1_Click(object
sender, EventArgs e)
{
string
Text = TextBox1.Text;
Console.WriteLine("Before Translation:{0}", Text);
Text = Google.API.Translate.Translator.Translate(Text, Google.API.Translate.Language.English,
Google.API.Translate.Language.Hindi);
Label1.Text = Text;
string
constr1;
IFormatProvider
culture = new CultureInfo("fr-Fr", true);
constr1 = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
con = new
SqlConnection(constr1);
con.Open();
// IN Realtime application, use parameterized statement to insert data into database
string
sql = "insert into tbHindi(username,Fullname)
values('" + TextBox1.Text + "',N'"
+ Label1.Text + "')";
cmd = new
SqlCommand(sql, con);
int
res;
res = cmd.ExecuteNonQuery();
res = 1;
con.Close();
GridView1.DataBind();
}
Conclusion
I think this solution shall help some of you. Thanks