public void readExcelFromDB() { SqlConnection conn = new SqlConnection(@"My Connection String"); conn.Open(); SqlCommand Cmd = new SqlCommand("select ExcelSheet from Test_Excel where ExcelID = 1", conn); Cmd.CommandType = CommandType.Text; //SqlCommand Cmd = new SqlCommand("select Attachment from Requests where RequestsID = 27", conn); SqlDataReader Reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection); // string DocumentName = null; FileStream FStream = null; BinaryWriter BWriter = null; // // // byte[] Binary = null; const int ChunkSize = 100; int SizeToWrite = 0; MemoryStream MStream = null; // while (Reader.Read()) { DocumentName = Reader["ExcelSheet"].ToString(); // Create a file to hold the output. FStream = new FileStream(@"D:\Mathi_Working\" + DocumentName, FileMode.OpenOrCreate, FileAccess.Write); BWriter = new BinaryWriter(FStream); Binary = (Reader["ExcelSheet"]) as byte[]; SizeToWrite = ChunkSize; MStream = new MemoryStream(Binary); // for (int i = 0; i < Binary.GetUpperBound(0) - 1; i = i + ChunkSize) { if (i + ChunkSize >= Binary.Length) SizeToWrite = Binary.Length - i; byte[] Chunk = new byte[SizeToWrite]; MStream.Read(Chunk, 0, SizeToWrite); BWriter.Write(Chunk); BWriter.Flush(); } BWriter.Close(); FStream.Close(); } FStream.Dispose(); conn.Close(); Process.Start(@"D:\Mathi_Working\" + DocumentName); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)