Shannon,
Assuming the column is a binary field (i.e. image), then something like:
// Load stream to byte[]
Stream myStream;
byte[] buffer = new byte[myStream.Length];
myStream.Write(buffer, 0, myStream.Length);
myStream.Close();
string sql = "INSERT INTO MyTable SET blobField=@blob";
SqlCommand cmd = new SqlCommand(sql, ...);
cmd.Parameters.Add("@blob", buffer);
cmd.ExecuteNonQuery();
HTH,
Duncan Smart
============
On Thu, 23 May 2002 13:22:34 -0700, Shannon Carver <[EMAIL PROTECTED]>
wrote:
>How can I write a stream to a sql server database table?
>
>You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
>subscribe to other DevelopMentor lists at http://discuss.develop.com.
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
