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 ?