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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about rapid application development tool?

518


Explain managed code?

536


Explain namespace?

574


Explain the advantages of vb.net?

529


What is a static class?

600






What is the main purpose of garbage collector?

511


Is vb.net a programming language?

540


how to get dynamic control array position or its index position?

2055


What is the difference between manifest and metadata?

552


Explain jit?

552


What are the differences between vb.net and c#, related to oops concepts

576


How do you call a stored procedure in Visual Basic?

587


Explain about the keyword must inherit?

583


What are nested classes?

542


Explain the difference between an xml "fragment" and an xml "document."

505