Old windows forms application which will allow the program to attach a file and save it to the database on button click

Question

1.00/5 (1 vote)

See more:

, +

Is there any suggestions or links that i can use in order to create such a thing? I have a Form with a lot of textboxes and comboboxes in which when you enter a criteria inside those textboxes and select a criteria from the comboboxes gets saved to an ACCESS Database. however, i want to have something which will allow the user to save an attachment and save the attachment to the database on the click of a button. Can someone please help me with this as i did a lot of search but found absolutely nothing.

What I have tried:

I tried googling but i am running out of ideas and not sure what to do.

Posted 15-Aug-16 5:06am

JT1992

Updated 15-Aug-16 7:34am

Add a Solution

Comments

[no name] 15-Aug-16 11:36am

Do you mean a Form that supports Drag-N-Drop functionality?

JT1992 15-Aug-16 11:37am

yes and even a file upload feature if thats possible.

Richard MacCutchan 15-Aug-16 12:27pm

Your question is tagged VB and Windows so where are you planning to upload a file from or to? I have a feeling that your question needs to be made more clear.

2 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)

User 11061201 · Answer 1 · 2016-08-15T07:34:00

Solution 2

First of all learn how to handle a file that is moved to your Form via Drag-And-Drop. The tutorial below explains how to get the name, path etc. from the respective file.
Implementing Drag and Drop in Visual Basic .NET[^]

Once you got it, learn how to upload files to the Database.
Uploading Files to a Database in VB - DB Tutorials | Database Tutorials, Tips, and Articles[^]

Posted 15-Aug-16 7:34am

User 11061201

Comments

JT1992 15-Aug-16 13:35pm

you rock thank you will accept this solution as soon as i am able to get this done.

Richard MacCutchan · Answer 2 · 2016-08-15T05:38:00

Solution 1

What exactly do you mean by "saving an attachment"? If you mean saving a file to be associated with some database record, then it is a simple matter to copy the file to some fixed location, and save the location details in the database.

Posted 15-Aug-16 5:38am

Richard MacCutchan

Comments

JT1992 15-Aug-16 11:38am

is there a code example that i can use for this?

Richard MacCutchan 15-Aug-16 11:43am

Are you saying that you do not know how to copy a file, or insert/update the database?

JT1992 15-Aug-16 12:11pm

i am not sure how to do this.

Richard MacCutchan 15-Aug-16 12:25pm

Use File.Copy.

JT1992 15-Aug-16 12:27pm

but is there a feature or tool that i need to use from the toolbox in order to do so?

Richard MacCutchan 15-Aug-16 12:29pm

As I stated in my comment above, your question is not clear. You need to explain exactly what files you are referring to, where they come from, and where you are trying to store them.

JT1992 15-Aug-16 12:30pm

so basically i want to have an image of an attachment, that will be a file upload kind of feature which will save the file uploaded into a database.

Richard MacCutchan 15-Aug-16 12:43pm

Sorry, but that does not mean anything. What is "an image of an attachment"? Where are you trying to upload files from?