SQL server Table after inserting data
UserId first_name last_name ministry mobile type
30478986-DB76-49A2-96A4-157F26D40ADC samim3 faqiri ????? ??????? 079989898 memeber
C2E974D0-6C0C-4783-B513-2FAC5153D1A1 ali ??? ??? ????? ??????? 2343242434 memeber
my code while using parameter to insert Persian character into sqlserver
conn.Open();
string insertSql = "INSERT INTO aspnet_Profile(UserId,first_name,last_name,ministry,mobile,type) VALUES(@UserId, @fname,@lname,@ministry,@mobile,@type)";
SqlCommand myCommand = new SqlCommand(insertSql, conn);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.Parameters.AddWithValue("@fname", fname);
myCommand.Parameters.AddWithValue("@lname", lname);
myCommand.Parameters.AddWithValue("@mobile", mobile);
myCommand.Parameters.Ad ...
Go to the complete details ...