Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?

0 Answers  


how to connect crystal report with vb.net ?

6 Answers   Patni,


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

0 Answers   CMC,


wht is the use of console application?

3 Answers   MRB,


What is an application domain? how they get created?

0 Answers  


Define manifest?

0 Answers  


What is the source code for display the picture in button click event?

0 Answers  


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

0 Answers  


What is misl code?

0 Answers  


Compare c# and visual basic.net?

0 Answers  


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

0 Answers  


What are the different variables in vb.net?

0 Answers  


Categories