G
Guest
Can someone please, please tell me how I get a progress bar to work with a
binary file upload!
I have the following code that uploads files into an SQL Database using a
Stored Procedure but I want to add a progress bar so users can see how long
the file takes to upload!
This would varey greatly depending on the size of the file! I would be very
grateful for any advice...
I'm reasonably new to ASP.NET but trying hard to learn so hope this isn't
too much of a stupid question...
I had a look at the following:
http://www.farsidestudios.com/Products/ProgressBar/
But don't know how to work it into my sub!
Thanks
CODE....
Sub UploadData(ByVal sender As Object, ByVal e As EventArgs)
Dim imgstream As Stream = ImageFile.PostedFile.InputStream
Dim imgdata(ImageFile.PostedFile.ContentLength) As Byte
imgstream.Read(imgdata, 0, ImageFile.PostedFile.ContentLength)
Dim MyConn As New
SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Dim cmd As New SqlCommand("fileUpload", MyConn)
cmd.CommandType = CommandType.StoredProcedure
Dim titleparam As New SqlParameter("@fileTitle", SqlDbType.NVarChar,
255)
Dim descriptionparam As New SqlParameter("@fileDescription",
SqlDbType.NVarChar, 255)
Dim Ownerparam As New SqlParameter("@fileOwner", SqlDbType.NVarChar,
255)
Dim Officeparam As New SqlParameter("@officeID", SqlDbType.Int)
Dim typeparam As New SqlParameter("@fileType", SqlDbType.NVarChar,
100)
Dim dataparam As New SqlParameter("@fileData", SqlDbType.Image)
titleparam.Value = ImageTitle.Text
descriptionparam.Value = fldDescription.Text
Ownerparam.Value = fldOwner.Text
Officeparam.Value = ddlOffice.SelectedIndex
typeparam.Value = ImageFile.PostedFile.ContentType
dataparam.Value = imgdata
cmd.Parameters.Add(titleparam)
cmd.Parameters.Add(descriptionparam)
cmd.Parameters.Add(Ownerparam)
cmd.Parameters.Add(Officeparam)
cmd.Parameters.Add(typeparam)
cmd.Parameters.Add(dataparam)
MyConn.Open()
cmd.ExecuteNonQuery()
MyConn.Close()
End Sub
binary file upload!
I have the following code that uploads files into an SQL Database using a
Stored Procedure but I want to add a progress bar so users can see how long
the file takes to upload!
This would varey greatly depending on the size of the file! I would be very
grateful for any advice...
I'm reasonably new to ASP.NET but trying hard to learn so hope this isn't
too much of a stupid question...
I had a look at the following:
http://www.farsidestudios.com/Products/ProgressBar/
But don't know how to work it into my sub!
Thanks
CODE....
Sub UploadData(ByVal sender As Object, ByVal e As EventArgs)
Dim imgstream As Stream = ImageFile.PostedFile.InputStream
Dim imgdata(ImageFile.PostedFile.ContentLength) As Byte
imgstream.Read(imgdata, 0, ImageFile.PostedFile.ContentLength)
Dim MyConn As New
SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Dim cmd As New SqlCommand("fileUpload", MyConn)
cmd.CommandType = CommandType.StoredProcedure
Dim titleparam As New SqlParameter("@fileTitle", SqlDbType.NVarChar,
255)
Dim descriptionparam As New SqlParameter("@fileDescription",
SqlDbType.NVarChar, 255)
Dim Ownerparam As New SqlParameter("@fileOwner", SqlDbType.NVarChar,
255)
Dim Officeparam As New SqlParameter("@officeID", SqlDbType.Int)
Dim typeparam As New SqlParameter("@fileType", SqlDbType.NVarChar,
100)
Dim dataparam As New SqlParameter("@fileData", SqlDbType.Image)
titleparam.Value = ImageTitle.Text
descriptionparam.Value = fldDescription.Text
Ownerparam.Value = fldOwner.Text
Officeparam.Value = ddlOffice.SelectedIndex
typeparam.Value = ImageFile.PostedFile.ContentType
dataparam.Value = imgdata
cmd.Parameters.Add(titleparam)
cmd.Parameters.Add(descriptionparam)
cmd.Parameters.Add(Ownerparam)
cmd.Parameters.Add(Officeparam)
cmd.Parameters.Add(typeparam)
cmd.Parameters.Add(dataparam)
MyConn.Open()
cmd.ExecuteNonQuery()
MyConn.Close()
End Sub