取照片

SqlConnectionconnection=newSqlConnection();

stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();

connection.ConnectionString=connstr;

connection.Open();

SqlCommandcmd=newSqlCommand("selectphotofromStudentwhereID=000019",connection);

SqlDataAdapterda=newSqlDataAdapter(cmd);

DataSetds=newDataSet();

da.Fill(ds,"Student");

intc=ds.Tables["Student"].Rows.Count;



if(c>0)

{//BLOBisreadintoBytearray,thenusedtoconstructMemoryStream,

//thenpassedtoPictureBox.

Byte[]byteBLOBData=newByte[0];

byteBLOBData=(Byte[])(ds.Tables["Student"].Rows[c-1]["photo"]);

MemoryStreamstmBLOBData=newMemoryStream(byteBLOBData);

pictureBox1.Image=Image.FromStream(stmBLOBData);

}

connection.Close();







constintbufferSize=100;

byte[]buffer=newbyte[bufferSize];

longcurrIndex=0;

byte[]photoPtr;

using(SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString))

{

conn.Open();

using(SqlCommandcomm=conn.CreateCommand())

{

comm.CommandText="SelectTEXTPTR(photo)FromStudentWhereID=000019";

photoPtr=(byte[])comm.ExecuteScalar();

}

using(SqlCommandcomm=conn.CreateCommand())

{



OpenFileDialogdlg=newOpenFileDialog();

dlg.Filter="JPGfiles|.jpg|Allfiles|.";

dlg.ShowDialog();

comm.CommandText="UPDATETEXTStudent.Photo@Pointer@Offsetnull@Data";

SqlParameterptrParm=comm.Parameters.Add("Pointer",SqlDbType.Binary,16);

ptrParm.Value=photoPtr;

SqlParameterphotoParm=comm.Parameters.Add("Data",SqlDbType.Image);

SqlParameteroffsaetParm=comm.Parameters.Add("Offset",SqlDbType.Int);

offsaetParm.Value=0;

using(FileStreamfs=newFileStream(dlg.FileName,FileMode.Open,FileAccess.Read))

{

intcount=fs.Read(buffer,0,bufferSize);

while(count!=0)

{

photoParm.Value=buffer;

photoParm.Size=count;

comm.ExecuteNonQuery();

currIndex+=count;

offsaetParm.Value=currIndex;

count=fs.Read(buffer,0,bufferSize);

}

MessageBox.Show("PhotographReplaced!!!");

}

}