how insert null value in image column in sqlserver table.. like - TopicsExpress



          

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



s="stbody" style="min-height:30px;">
Van alles mis gegaan nadat Facebook Kay Bak II geblokkeerd heeft
A group of professional people posed this question to a group of 4
Visit the Nash Junior Academy! The fishing sessions are held on a

Recently Viewed Topics




© 2015