代碼:
OleDbCommand?cmd?=?new?OleDbCommand(cnnstr,?con);cmd.CommandType?=?CommandType.Text;
cmd.CommandText?=?cnnstr;
string?imgPath?=?@"d:/image.jpg";?
FileStream?file?=?new?FileStream(imgPath,?FileMode.Open,?FileAccess.Read);
Byte[]?imgByte?=?new?Byte[file.Length];?
file.Read(imgByte,?0,?imgByte.Length);
file.Close();
cmd.CommandText?=?"?insert?into?imgtable(id,img?)?values?('17',:img)?";
cmd.Parameters.Add("img",?System.Data.OleDb.OleDbType.Binary,?imgByte.Length);
cmd.Parameters[0].Value?=?imgByte;連接字符串:
strConn?=?"Provider=OraOLEDB.Oracle;pools=true;User?ID="?+?uName?+?";Data?Source="?+?linkStr?+?";Password="?+?uPwd?+?";";
並非:Provider=MSDAORA