How to upload file in VB.NET?

Question

3.00/5 (2 votes)

See more:

VB

How to upload file in vb.net windows application please help me
Sorry guys it is File not Excel File

Posted 20-Jan-11 19:59pm

IndrajitDasgupat

Updated 21-Jan-11 3:55am

Indivara

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Jan-11 2:03am

Are you sure you're asking just about upload? If so, what's the difference what kind of file, excel or not?

Sandeep Mewara 21-Jan-11 3:22am

Nice question! :)

Sandeep Mewara 21-Jan-11 3:24am

I think you want to upload data from excel to DB. Right?

Indivara 21-Jan-11 9:55am

Fixed title

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-01-20T21:17:00

Solution 1

How about My.Computer.Network.UploadFile

Or this may be helpful to you:
An FTP client library for .NET 2.0[^]

Posted 20-Jan-11 21:17pm

Prerak Patel

Sandeep Mewara · Answer 2 · 2011-01-20T21:27:00

Solution 2

For uploading data from Excel to database, look here:
Link 1[^]
Link 2[^]

If needed more, just Google it!

Posted 20-Jan-11 21:27pm

Sandeep Mewara

satrio_budidharmawan · Answer 3 · 2012-03-01T00:11:00

Just do this simply :

<pre lang="vb">If (Not File1.PostedFile Is Nothing) _
   And (File1.PostedFile.ContentLength > 0) Then
   'determine file name
   Dim sFileName As String = _
      System.IO.Path.GetFileName(File1.PostedFile.FileName)
   Try
      If File1.PostedFile.ContentLength <= lMaxFileSize Then
         'save file on disk
         File1.PostedFile.SaveAs(sFileDir + sFileName)
         lblMessage.Visible = True
         lblMessage.Text = "File: " + sFileDir + sFileName + _
            " Uploaded Successfully"
      Else    'reject file
         lblMessage.Visible = True
         lblMessage.Text = "File Size if Over the Limit of " + _
            lMaxFileSize
      End If
   Catch exc As Exception    'in case of an error
      lblMessage.Visible = True
      lblMessage.Text = "An Error Occured. Please Try Again!"
      DeleteFile(sFileDir + sFileName)
   End Try
Else
   lblMessage.Visible = True
   lblMessage.Text = "Nothing to upload. Please Try Again!"
End If

Well, File1 is some control that handle file upload or open. Find it.