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 / 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 |
Write a program for calculator in VB.NET
6 Answers CMC, College School Exams Tests, IBM, NIIT, Practical Viva Questions, Subex,
What is difference between metadata and manifest?
How do you rate yourself in .NET ?
3 Answers Infosys, Seneca Global,
What are the advantages of an assembly?
What is pre-jit?
List the types of generations in garbage collector?
What is intermediate language in .NET ?
20 Answers Digital GlobalSoft,
What are the advantages of vb.net and c#?
What are the parts of the visual basic control?
What is the difference between compiler and interpreter?
What is break mode? What are the options to step through code?
What is JIT(Just In Time) and How it works?
5 Answers Data Entry Operator, Infocons, Siemens,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)