how insert null value in image column in sqlserver table.. like id int, name varchar(20), addrs varchar(100), contno bigint, photo image i want to save some record without upload image.... when i click on insert button i facing an error input path is null this is my code: FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); byte[] x; x = br.ReadBytes((int)(fs.Length)); cmd.Connection = cn; SqlParameter p1, p2, p3, p4, p5, p6, p7,p8; cmd.CommandText = @insert into studentreg values(@rgno1, @sname1, @dob1, @bloodgroup1, @gender1, @imark11, @imark12, @photo1); p1 = cmd.Parameters.Add(@rgno1, SqlDbType.VarChar, 100); p2 = cmd.Parameters.Add(@sname1, SqlDbType.VarChar, 100); p3 = cmd.Parameters.Add(@dob1, SqlDbType.Date); p4 = cmd.Parameters.Add(@bloodgroup1, SqlDbType.VarChar, 10); p5 = cmd.Parameters.Add(@gender1, SqlDbType.VarChar, 10); p6 = cmd.Parameters.Add(@imark11, SqlDbType.VarChar, 100); p7 = cmd.Parameters.Add(@imark12, SqlDbType.VarChar, 100); p8 = cmd.Parameters.Add(@photo1, SqlDbType.Image); so plz give me any solution....
Posted on: Thu, 13 Nov 2014 15:56:08 +0000
Trending Topics
Recently Viewed Topics
© 2015