Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Writes binary data to a file

using System; using System.Data.SqlClient; using System.Data; using System.IO; public class ConnectionTest {     private static string connectionString = "Data Source=localhost;Initial Catalog=pubs;Integrated Security=SSPI";     private static string SQL = "SELECT pub_id, logo FROM pub_info";     public static void Main()      {         int bufferSize = 100;                           byte[] bytes = new byte[bufferSize];         long bytesRead;         long readFrom;         SqlConnection con = new SqlConnection(connectionString);         SqlCommand cmd = new SqlCommand(SQL, con);         con.Open();         SqlDataReader r = cmd.ExecuteReader(CommandBehavior.SequentialAccess);         while (r.Read())         {             string filename = "logo.bmp";             FileStream fs = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Write);             BinaryWriter bw = new BinaryWriter(fs);             readFrom = 0;             do {                 bytesRead = r.GetBytes(1, readFrom, bytes, 0, bufferSize);                 bw.Write(bytes);                 bw.Flush();                 readFrom += bufferSize;             } while (bytesRead == bufferSize);             bw.Flush();             bw.Close();             fs.Close();         }         r.Close();         con.Close();     } }