insert into table (name) values (N'?????') this code is working when im inserting in sql server, how we insert it bu asp.page.unicode problem
How we insert Unicode data in database by asp .net .
Rajeev KumarPosted Oct 31, 2013, 7:17 AM
HanookPosted Oct 31, 2013, 7:14 AM
???????( 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
Mine is working as expected.. inserted into database too.......
What is the Datatype you have in DB?
Sanjay KumarPosted Oct 31, 2013, 7:13 AM
Rajeev KumarPosted Oct 31, 2013, 7:05 AM
HanookPosted Oct 31, 2013, 6:55 AM
Rajeev KumarPosted Oct 31, 2013, 6:51 AM
HanookPosted Oct 31, 2013, 6:41 AM
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 KumarPosted Oct 31, 2013, 5:57 AM
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"
HanookPosted Oct 31, 2013, 4:31 AM
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 KumarPosted Oct 31, 2013, 4:31 AM
try this
http://www.dotnetfunda.com/articles/show/1132/insert-hindi-font-from-aspnet-web-page-to-sql-server-database
Rajeev KumarPosted Oct 31, 2013, 4:16 AM
HanookPosted Oct 31, 2013, 3:35 AM
Sample example to insert unicode data.....