关于数据库存图的问题，各位老大帮我看看啊。

Question

应该先添加参数到oc的Parameters中，再给参数赋值！

Answer 1

http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=185154

Answer 2

你想干什么？
select * from biao
这句sql语句里有参数么？???

Answer 3

FileInfo fileInfo = new FileInfo(pictureFileName);  //文件信息
int fileSize = Convert.ToInt32(fileInfo.Length);
Byte[] pictureByte=new byte[fileSize];
savePictureName=fileInfo.Name;
FileStream fs = new FileStream(pictureFileName,FileMode.Open);  //文件流
fs.Read(pictureByte,0,pictureByte.Length);          //写入二进制数组
fs.Close();                                         //关闭
cmd.Connection=con;
cmd.Parameters.Clear();
cmd.CommandText="PictureLib_AddPicuture";
cmd.CommandType=System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@PictureName",SqlDbType.VarChar,256);
cmd.Parameters.Add("@Picture",System.Data.SqlDbType.Image);
cmd.Parameters[0].Value=savePictureName;
cmd.Parameters[1].Value=pictureByte;
cmd.ExecuteNonQuery();存储过程
use Test
go
create table PictureLib
(
PictureID int identity(1,1) primary key,
PictureName varchar(256),
Picture image
)
go
create procedure PictureLib_AddPicuture
@PictureName varchar(256),
@Picture image
as
insert into PictureLib(PictureName,Picture) values(@PictureName,@Picture)
if(@@error!=0)
begin
return 0
end
return 1
go

Answer 4

先添加参数到Parameters中，再给参数赋值