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();
}
}
|