图片信息怎么存入SQL Server中

在SQLSERVER中,有IMAGE类型,是用来存放图片的,在我理解,这个应该是可以存放二进制数据流的吧.因此程序之前,我们要先引用两个命名空间System.Data.SqlClient和System.IO
//存图片
string strConn = "Server=YourServer;uid=sa;pwd=;database=northwind";
SqlConnection conn = new SqlConnection(strConn);
SqlDataAdapter sda = new SqlDataAdapter("Select * From MyImages", conn);
SqlCommandBuilder cb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.MissingSchemaAction = MissingSchemaAction.AddWithKey;
FileStream fs = File.Open(@"C:\xxx.BMP", FileMode.Open, FileAccess.Read);
byte[] byData = new byte[fs.Length];
fs.Read(byData, 0, byData.Length);
fs.Close();
conn.Open();
sda.Fill(ds, "MyImages");
DataRow dr = ds.Tables["MyImages"].NewRow();
dr["photo"] = byData; //photo是我保存图片的字段名
ds.Tables["MyImages"].Rows.Add(dr);
sda.Update(ds, "MyImages");
fs.Dispose();
cb.Dispose();