Data saving in hindi in sql server 2008

Question

Hi friends ,

I am trying to save hindi data in database. textbox display hindi font but at code behind page it is not in hindi and thus it is not inserting in hindi. I have taken column as nvarchar insert data by implementing 'n' before the texbox.text.

Please help me

sourav mondal 0 · Answer

Save and fetch data into/from sql server database in other language (hindi, bengali, english, marathi, malayalam etc) using ASP.NET C#. http://dotnetawesome.blogspot.com/2013/12/save-and-fetch-other-language-hindi-bangali-marathi-data-into-sql-server.html Video Tutorial : http://youtu.be/TV9U7Adoj_o google.load("elements", "1", { packages: "transliteration" }); function onLoad() { var options = { sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH, destinationLanguage: google.elements.transliteration.LanguageCode.HINDI, // available option English, Bengali, Marathi, Malayalam etc. shortcutKey: 'ctrl+g', transliterationEnabled: true }; var control = new google.elements.transliteration.TransliterationControl(options); control.makeTransliteratable(['txtHindiContent']); } google.setOnLoadCallback(onLoad);

Rajeev Kumar · Answer

sir i have solve this problem in same manner . yet thank you for Help. Rajeev

Sanjay Kumar · Answer

Hi http://www.codeproject.com/Articles/67944/Hindi-Marathi-Transliteration-ASP-NET-Custom-Contr http://www.c-sharpcorner.com/uploadfile/eb5fab/insert-hindi-font-in-Asp-Net-web-page-to-sql-database/

Hanook · Answer

The follwoing code is working for me.. I took One TextBox and one Button... Click of button is for saving data to database... Enter TextBox text is ??????? (Hindi word Dhanyavad) protected void btnSave_Click(object sender, EventArgs e) { string connectionstring = "Data source=SDW2249; Initial Catalog=study; Integrated Security=true"; SqlConnection conn = new SqlConnection(connectionstring); conn.Open(); SqlCommand cmd = new SqlCommand("Insert into TblHindi (val) values (@HindiText)", conn); string HindiText = txtHindi.Text; cmd.Parameters.Add("@HindiText", SqlDbType.NVarChar, 50).Value = HindiText; int rowsInserted = cmd.ExecuteNonQuery(); conn.Close(); }

Rajeev Kumar · Answer

string str = txtcur.Text; SqlCommand cmd = new SqlCommand("insert into hinditbl values(N'"+txtcur.Text+"')", con); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds);

Hanook · Answer

Can you post the INSERT operation code which you have tried ?