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
- 1 Answers
- 3794 Views
- I also Faced
- E-Mail Answers
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
What is misl code?
List the two main parts of .net?
What is stack used for in vb. Net?
Describe about visual basic.net?
Explain how the .net framework performs automatic memory management.
Explain the difference between c# and vb.net?
Define naming convention?
Explain the difference between .dll extension and .exe extension files?
What are the advantages of vb.net and c#?
What is econo-jit?
What is deep copy?
What is the difference between system.applicationexception class and system.systemexception?
Explain the differences between vb.net and c#, related to oops concepts?
my project run very wel in my sytem yhen i am deploying my project on client machine ,after deployment i run my project then it show " can no find server name " what i do .
How to view an assembly?
