Hi, Rahul
Following is the code to upload image:
<form method="POST" action="saveFile.asp"
enctype="multipart/form-data" name="UploadForm">
<center>
Employee Name : <INPUT TYPE="TEXT" NAME="USERNAME" SIZE="30"><br>
<INPUT TYPE="FILE" NAME="UPLOADFILE1" SIZE="50">
</center>
<br>
<center><INPUT TYPE="SUBMIT" VALUE="Upload"
id=SUBMIT1 name=SUBMIT1></center>
</form>
Code to save the image in the database:
Dim myupload
'declare variables..
intCount=0
' Create Upload Component
Set myupload = Server.CreateObject("aspSmartUpload.SmartUpload")
myupload.Upload
'Create Connection
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("data.mdb")
Set Rs = Server.CreateObject("ADODB.recordset")
Rs.Open "SELECT user_id,user_name,user_photo FROM users", Conn,3,3
'Select each file
For each file In myupload.Files
If not file.IsMissing Then 'Check for missing file
'Add the current file in database
Rs.AddNew
file.FileToField Rs.Fields("user_photo")
Rs("user_name") = myupload.Form("USERNAME")
Rs.Update
intCount = intCount + 1
End If
Next
Response.Write(intCount & " file(s) uploaded.")
'Destroy the objects...
Posted On:
10-Mar-2015 00:57