How to Insert Urdu Language Using Dataset Insertion c#

Hussain Mansoor

Hi i tired to insert data in urdu language using dataset insertion but its showing ??? in Table Narration column. The field datatype is Nvarchar.

Here is the code that i am trying to insert

Here is the dataset

Here is the parameters

What i am missing?.. This process still showing ????? when trying to insert urdu language in Narration column.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Hi

Bellow is a example to add nvarchar type
SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn);
catDA.UpdateCommand = new SqlCommand("UPDATE Categories SET CategoryName = @CategoryName " +
"WHERE CategoryID = @CategoryID" , nwindConn);
catDA.UpdateCommand.Parameters.Add("@CategoryName", SqlDbType.NVarChar, 15, "CategoryName");
SqlParameter workParm = catDA.UpdateCommand.Parameters.Add("@CategoryID",
qlDbType.Int);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;
DataSet catDS = new DataSet();
catDA.Fill(catDS, "Categories");
DataRow cRow = catDS.Tables["Categories"].Rows[0];
cRow["CategoryName"] = "New Category";
catDA.Update(catDS);
Thanks and regards
0
Farhan Ahmed6y ago
https://www.aspsnippets.com/Articles/Insert-Hindi-Marathi-Gujarati-Urdu-Persian-Arabic-Tamil-and-Telugu-languages-Text-characters-in-MySql-database-using-ASPNet-C-and-VBNet.aspx
0