System.IO.FileStream fs = new System.IO.FileStream("file path and name", IO.FileMode.Open, IO.FileAccess.Read);
请参考:
byte[] imgData = new byte[fs.Length];
fs.Read(imgData, 0, fs.Length);
SqlConnection conn = new SqlConnection("...");
SqlDataAdapter da = new SqlDataAdapter("select ... ", conn);
DataSet ds = new DataSet();
da.Fill(ds);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
ds.Tables[0].Rows[0]["img"] = imgData;
da.Update(ds);
其中,img字段为Image类型
请参考:
byte[] imgData = new byte[fs.Length];
fs.Read(imgData, 0, fs.Length);
SqlConnection conn = new SqlConnection("...");
SqlDataAdapter da = new SqlDataAdapter("select ... ", conn);
DataSet ds = new DataSet();
da.Fill(ds);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
ds.Tables[0].Rows[0]["img"] = imgData;
da.Update(ds);
其中,img字段为Image类型
SELECT ImageField FROM table1
WHERE ...
UPDATE table2 SET ImageField=table1.ImageField
FROM table1
WHERE ...