hello dear friends my problem is that i want to save images that is pictures

hello
dear friends my problem is that i want to save images that
is pictures in SQL server using vb.net can any body help me
to do so please

Question Posted / ijaz_sh

1 Answers
3797 Views
I also Faced
E-Mail Answers

hello dear friends my problem is that i want to save images that is pictures in SQL server using..

Answer / govind

step1) place one fileUpload control from tool box
step2) in it's Button click event
If FileUpload1.PostedFile Is Nothing Then
Response.Write("no file posted")

Else
Here Convert that image as byte and pass it
to function.
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim ds As New DataSet

con = New
SqlConnection(ConfigurationManager.AppSettings("connectionString"))
cmd = New SqlCommand("insert into tablename
values(@image_in), con)
Dim imageByte(FileUpload1.PostedFile.InputStream.Length) As
Byte

FileUpload1.PostedFile.InputStream.Read(imageByte, 0,
imageByte.Length)
cmd.Parameters.AddWithValue("@image_in",
imageByte)
con.Open()
cmd.ExecuteNonQuery()
con.Close()

Response.Write("file is inserted")
End If

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More VB.NET Interview Questions

Write a program that accepts an array of numbers, and two numbers (an element and a position in the array) and inserts the given element into nth position of the array.

2 Answers

Can you please explain the difference between c# and vb.net?

0 Answers

Can you please explain the difference between dataset and datareader?

0 Answers

what is vb.net

1 Answers TCS,

What is strong typing and weak typing?

0 Answers

Tell me which namespace are used for accessing the data?

0 Answers

What is portable executable?