How to save RTF file in binary or image field in SQL Server?

Question

hi all, I want to save content of RichTextBox (image, text etc.) to in binary or image field in SQL Server, but I couldn't... Please help me, thank you

Wim Devos · Answer

the data from your file is never stored in de byte array, use inFile.Read(binaryData, 0, length);

Ersin Miman · Answer

Can I use these method to save and read to/from binary field to SQL Server? MemoryStream ms_memStream = new MemoryStream (); BinaryWriter br_binaryWriter = new BinaryWriter (ms_memStream); br_binaryWriter.Write( "sample text" ); But, I don't know how will to use it? sqlCommand1.CommandText = "INSERT INTO tbT_Soru(SoruBinary) VALUES(" + ms_memStream.ToString() + ")" ; ????????

nguyen huu tho · Answer

nnnn

Ersin Miman · Answer

FileStream inFile; Byte [] binaryData; try { inFile = new FileStream ( "ersin miman" , FileMode .Open, FileAccess .Read); binaryData = new Byte [inFile.Length]; } catch ( Exception exp) { // Error creating stream or reading from it. System. Console .WriteLine( "{0}" , exp.Message); return ; } sqlConnection1.ConnectionString = "Data Source=localhost;Initial Catalog=dbSoru;User ID=sa;Password=xxxxxx" ; sqlConnection1.Open(); SqlTransaction trs = null ; try { trs = sqlConnection1.BeginTransaction(); sqlCommand1.Connection = sqlConnection1; sqlCommand1.CommandText = "INSERT INTO tbT_Soru(SoruBinary) VALUES('" + binaryData + "')" ; sqlCommand1.Transaction = trs; sqlCommand1.ExecuteNonQuery(); trs.Commit(); } catch ( Exception e1) { if (trs != null ) { trs.Rollback(); } } sqlConnection1.Close();

Wim Devos · Answer

how did you tried to do that?

How to save RTF file in binary or image field in SQL Server?

Answers (5)