Posted on: 10/17/2015 6:49:25 AM | Views : 1176

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 ...