uploading multiple pdf files for each records using BV.net

Question

1.00/5 (1 vote)

See more:

I have an existing Enrollment table with many records on SQL Server 2008 R2 and

I need to browse to upload pdf file/s for each record and show them on Enrollment page.Enrollment page is developed in vb.net.

EnrollmentID is the primary key. So when I open each enrollment, I should see only that enrollmen's uploaded file.

How can I achieve that by using vb.net?

Thanks

Posted 17-Sep-15 9:52am

Member 11829482

Add a Solution

Comments

ZurdoDev 17-Sep-15 16:29pm

By writing a lot of code. Where are you stuck?

1 solution

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)

Dev O'Connor · Answer 1 · 2015-09-17T10:33:00

Without more information i am struggling to understand this, are uploading the files to the database?

You could always rename the PDF sequentially starting with the enrollmentid PK.

For example:

Original File: MyUploadedDocumentForDev.pdf
New File Name: <enrollment_id>_<count_of_pdf_with_this_prefix.pdf>
Enrollment Id: 12345678
Total Docs starting with 12345678 = 4
New File: 12345678_8.pdf.

Then in VB, instead of enumerating all uploaded files, you just enumerate anything that begins with 12345678*.pdf.

If you are inserting a record into the database to show that you have uploaded a pdf, you can add another column in as a ForeignKey which is the Enrollee's Enrolment ID.

SQL

INSERT INTO [MyDB].[dbo].[MyPDFTable] (EnrollmentId, PDFName, PDFDirectory) VALUES ('12345678','12345678_4.pdf','/home/wwwroot/uploads')

Where EnrollmentId is the same enrollment id as the enrollee'

then on your page

SQL

SELECT * FROM [MyDB].[dbo].[MyPDFTable] WHERE EnrollmentId = '12345678'

Without more info struggling to offer more advice.