如何用SQL语句往数据库的表里加图像文件？？？

[SevenChina]

如何用SQL语句往数据库的表里加图像文件？？？

谢谢了！

[SevenChina]

谢谢了，结贴！

[CMIC]

http://www.csdn.net/Develop/Read_Article.asp?Id=12172

[mmqingfeng]

_updateCommand = new SqlCommand(_sqlUpdate,_connection);
_updateCommand.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 10, "Name"));
_updateCommand.Parameters.Add(new SqlParameter("@Picture", SqlDbType.Image,0, "Picture"));



this._updateCommand.Parameters["@Name"].Value = name;
this._updateCommand.Parameters["@Picture"].Value = data;

bool result = true;

try
{
if(_connection.State!= ConnectionState.Open)
{
this._connection.Open();
}
int row = (int)_updateCommand.ExecuteNonQuery();

result = row>0;

}
catch (Exception e)
{

MessageBox.Show(e.Message);
result = false;
}
finally
{
_connection.Close();
}
return result;

[mmqingfeng]

这是读文件：
FileStream st = File.OpenRead(filePath);
byte[] data= new byte[st.Length];
st.Read(data,0,(int)st.Length-1);

[mmqingfeng]

这是显示图像：
string sql = "SELECT Name, Picture FROM yourTable Where Name='yourName'";

SqlCommand selectCommand = new SqlCommand(sql,_connection);

try
{
sqlConnection.Open();

SqlDataReader reader = selectCommand.ExecuteReader();

if(reader.Read())
{
byte[] data = (byte[])reader.GetSqlBinary(1);

MemoryStream sm = new MemoryStream(data);
Bitmap bmp = new Bitmap(sm);
this.panel.BackgroundImage = bmp;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);

}
finally
{
_connection.Close();
}