小程序:c#实现SQLServer存储照片,并读取照片

建立数据库:wKiom1RF2lDAQIRPAAAOn3FO4as090.jpg

建一张表:wKiom1RF2q_i3NW_AAANUVaL2Wc003.jpgwKiom1RF2t2jg1ZbAACQHHvulIw521.jpg

新建存储过程:create procedure sp_InsertPhoto2

@name AS VARCHAR(50),

@p_w_picpath AS IMAGE

AS

INSERT INTO photps(name,photo)

VALUES(@name,@p_w_picpath)

RETURN @@identity

GO

程序在附件中。