How to convert a text File into ntext (sql datat type) in c#

Question

Hello Everyone I would like to save a file into the MS SQL database as ntext datatype. Please help...how can i convert any file to ntext format  same time i want to save in database as well as retrive alsoso that i can get the file again back from database without any corruption in file.

Vishal Jadav · Answer

Hi buddy Its little bit simple to save unicode data to Nchar/Ntext/Nvarchar datatyped field in Ms Sql . Simply Put N infront of your field when u save to DB. like insert into DBname values N' Your Text '; That's it.. I hope it will work coz currently i m also doing the same with multilingual project. Keep in Touch buddy...