> how can i retrive programicly images stored in an table and put them
> as files on the disk?
>
> tanks
>

"Stefan Delmarco" <StefanDeOnline@fotia.co.uk> wrote in message
news:c030d47217f0f8c8dfc24e9ca876@news.microsoft.com...
> Hello Sam,
>
> Some sample C# code for exporting the GIFs in the pubs database. Should
> all be self-explanatory ;)
>
> using System.Data;
> using System.Data.SqlClient;
> using System.IO;
>
> namespace ExportImages
> {
> public static class Program
> {
> private static void Main(string[] args)
> {
> using(SqlConnection conn = new
> SqlConnection("Server=localhost;Database=pubs;Integrated Security=SSPI"))
> using(SqlCommand cmd = conn.CreateCommand())
> {
> cmd.CommandType = CommandType.Text;
> cmd.CommandText = @"
> select p.pub_name, pi.logo
> from publishers p
> inner join pub_info pi
> on p.pub_id = pi.pub_id";
>
> conn.Open();
> using(IDataReader reader = cmd.ExecuteReader())
> {
> byte[] buffer = new byte[10 * 1024];
> while(reader.Read())
> {
> string filename = string.Format("{0}.gif",
> reader.GetString(0));
> long bytesRead = 0;
> long offset = 0;
> using(FileStream stream = File.Open(filename,
> FileMode.OpenOrCreate))
> {
> while ((bytesRead = reader.GetBytes(1, offset, buffer,
> 0, buffer.Length)) > 0)
> {
> stream.Write(buffer, 0, (int)bytesRead);
> offset += bytesRead;
> }
> }
> }
> }
> }
> }
> }
> }
>
> Cheers,
> Stefan Delmarco
>
> http://www.fotia.co.uk
>
>> how can i retrive programicly images stored in an table and put them
>> as files on the disk?
>>
>> tanks
>>
>
>