unicode problem

Question

How we insert Unicode data in database by asp .net . insert into table (name) values (N' ? ???? ') this code is working when im inserting in sql server how we insert it bu asp.page.

Rajeev Kumar · Answer

insert into hinditbl values(N'???') using this code i am getting '???' in my database and i want to get the same by sending ??? through textbox

Hanook · Answer

Did you enter ??????? ( Hindi word) or english Danyavad ? I just copied Hindi word from the below URL and entered into text box then click on Button... http://www.codeproject.com/Questions/541935/Insertplusnon-EnglishplusdataplusintoplusSqlplusse M ine is working as expected.. inserted into database too....... What is the Datatype you have in DB?

Sanjay Kumar · Answer

http://www.codeproject.com/Articles/67944/Hindi-Marathi-Transliteration-ASP-NET-Custom-Contr

Rajeev Kumar · Answer

data is still inserting in engilsh .

Hanook · Answer

not workng in the sense incorrect data or error

Rajeev Kumar · Answer

it is not working??

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

dear i m crating a News site like as Navbhartahtimesnews in hindi. my problem is occure here i have already done . but when it is inserting on the code behind page it is not in return niter hindi nor inserting the database in hindi formate

Hanook · Answer

hi Rajeev http://stackoverflow.com/questions/18932038/how-to-insert-unicode-string-into-sql-server-using-c-sharp http://www.c-sharpcorner.com/uploadfile/eb5fab/insert-hindi-font-in-Asp-Net-web-page-to-sql-database/ http://forums.asp.net/t/1831385.aspx

Sanjay Kumar · Answer

Hi try this http://www.dotnetfunda.com/articles/show/1132/insert-hindi-font-from-aspnet-web-page-to-sql-server-database

Rajeev Kumar · Answer

i need insert data in hindi form the database by asp .net page .

Hanook · Answer

Hi Rajeev Sample example to insert unicode data..... SqlCommand cmd = new SqlCommand(Insert into News (Newstitle) values (@news@title) conn); string news = TextBox1.Text; string title = TextBox2.Text; cmd.Parameters.Add(@news SqlDbType.NVarChar  100).Value = news; cmd.Parameters.Add(@title SqlDbType.NVarChar  100).Value = title;