How to store image file in Sql server database?

Answer Posted / y.s.a.naidu

MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms,
pictureBox1.Image.RawFormat);
byte[] img = ms.GetBuffer();

SqlCommand cmd = new SqlCommand("Insert into
tbl_Image(Images) values(@imgs)", cn);
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@imgs";
p1.SqlDbType = SqlDbType.Image;
p1.Value = img;
cmd.Parameters.Add(p1);
cn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Image Inserted ....");
cn.Close();

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is .net and c# the same?

748


Explain the difference between abstract class and interface.

854


Can we write class inside a class in c#?

709


Can we inherit partial class in c#?

679


What are the 3 elements of delegation?

720


Is enum a value type c#?

794


What is meant by desktop application?

687


Explain why do I get an error (cs1006) when trying to declare a method without specifying a return type?

642


Distinguish between a class and struct?

704


What is collection class c#?

695


Why is c# better than java?

685


Why is hashset faster?

687


what is difference between is and as operators in c#?

729


What is a clr (common language runtime)?

679


What is the use of console readkey in c#?

679