I started in 1983, in 2007 i still on a case!

public DataSet LoadPicture(string sql_connect, string sql_command, DataSet sql_dataSet)

I started in 1983, in 2007 i still on a case!

[quot автор]string sql_connectString = 
            "Data Source=????????????"; // строка подключения
              string sql_select = "select  picture from Picture where ttype=1"; // picture поле типа Image
              SqlConnection sql_conn = new SqlConnection(sql_connectString);
              sql_conn.Open();

              SqlCommand sql_comm = new SqlCommand(sql_select, sql_conn);
              DataSet sql_ds = new DataSet();
              SqlDataAdapter sql_da = new SqlDataAdapter(sql_select, sql_connectString);
              sql_da.Fill(sql_ds, "test"); // либо sql_da.Fill(sql_ds);

              toolStripDropDownButton2.DropDownItems.Clear();
              //    ToolStripDropDownButton2.DropDownItems.Add("Все ")
              //    For i =  0  To mRs.RecordCount -  1 
              //        ToolStripDropDownButton2.DropDownItems.Add(Trim(mRs.Fields("Groups").Value))
              //        '    ListView2.Groups.Add(Trim(mRs.Fields("Groups").Value), Trim(mRs.Fields("Groups").Value))
              //        mRs.MoveNext()
              //    Next



              //MemoryStream ms = new MemoryStream((byte[])table1.Image);
              //Bitmap image = new Bitmap(ms);
              //pictureBox1.Image = image;
             //MemoryStream ms = new MemoryStream((byte[]) sql_ds.Tables[ 0 ].Rows[ 0 ][ 0 ].im

             // sql_ds.Tables[ 0 ].image;[/quot]

sql_dataSet.Tables[ 0 ].Rows[ 0 ][ 0 ] 

I started in 1983, in 2007 i still on a case!

MemoryStream ms = new MemoryStream((byte[]) sql_ds.Tables[ 0 ].Rows[ 0 ].im

I started in 1983, in 2007 i still on a case!

[quot автор]SqlConnection pubsConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=pubs;");
SqlCommand logoCMD = new SqlCommand("SELECT pub_id, logo FROM pub_info", pubsConn);

FileStream fs;                          // Writes the BLOB to a file (*.bmp).
BinaryWriter bw;                        // Streams the BLOB to the FileStream object.

int bufferSize =  100 ;                   // Size of the BLOB buffer.
byte[] outbyte = new byte[bufferSize];  // The BLOB byte[] buffer to be filled by GetBytes.
long retval;                            // The bytes returned from GetBytes.
long startIndex =  0 ;                    // The starting position in the BLOB output.

string pub_id = "";                     // The publisher id to use in the file name.

// Open the connection and read data into the DataReader.
pubsConn.Open();
SqlDataReader myReader = logoCMD.ExecuteReader(CommandBehavior.SequentialAccess);

while (myReader.Read())
{
  // Get the publisher id, which must occur before getting the logo.
  pub_id = myReader.GetString( 0 );  

  // Create a file to hold the output.
  fs = new FileStream("logo" + pub_id + ".bmp", FileMode.OpenOrCreate, FileAccess.Write);
  bw = new BinaryWriter(fs);

  // Reset the starting byte for the new BLOB.
  startIndex =  0 ;

  // Read the bytes into outbyte[] and retain the number of bytes returned.
  retval = myReader.GetBytes( 1 , startIndex, outbyte,  0 , bufferSize);

  // Continue reading and writing while there are bytes beyond the size of the buffer.
  while (retval == bufferSize)
  {
    bw.Write(outbyte);
    bw.Flush();

    // Reposition the start index to the end of the last buffer and fill the buffer.
    startIndex += bufferSize;
    retval = myReader.GetBytes( 1 , startIndex, outbyte,  0 , bufferSize);
  }

  // Write the remaining buffer.
  bw.Write(outbyte,  0 , (int)retval -  1 );
  bw.Flush();

  // Close the output file.
  bw.Close();
  fs.Close();
}

// Close the reader and the connection.
myReader.Close();
pubsConn.Close();[/quot]

I started in 1983, in 2007 i still on a case!

            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            ms.Write((byte[])sql_dataSet.Tables[ 0 ].Rows[ 1 ][ 0 ],  0 , 10000 );
            Bitmap btm = new Bitmap(ms);
            pictureBox1.Image = btm;

            mstream.Write(VRS.Fields("Bytes").Value,  0 , VRS.Fields("Bytes").ActualSize)