Problem in uploading a file into database

Question

1.00/5 (1 vote)

See more:

Hi all

I am uploading a file into the database whilst checking the schema of the file aswell.
But while uploading a file , in the half way i am getting the error uploading fails and it rolls back.
Please can anyone help me because I am unable to figure out the problem.
When I insert into the database I have three columns clients, prepared and completed which should have same values( example: if there are 1234 clients then all three should have 1234 into the database). But clients and prepared are okay when it comes to completed I am getting -1.

ID LogGuid FileGuid Clients Completed Prepared

473 AFA202BE-682A 15AA042C-7E28-497D 1234 -1 1234

This what I am getting in the database. Please can anyone tell me or guide me please that where I am going wrong.

Posted 3-Jul-13 22:58pm

babli3

Updated 19-Jul-13 3:43am

v5

Add a Solution

Comments

Adarsh chauhan 4-Jul-13 6:42am

Please Provide your table in create mode and sample data so that we can help you.

babli3 4-Jul-13 7:02am

Hi I have debugged my code and found this error
I could not understand why i got this error....
please can you help

""DataPortal.Update failed (System.ApplicationException: An error occurred whilst open a connection to a database. System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Sushil Mate 4-Jul-13 7:15am

Every time you are getting this exception? Reset IIS & Try again. let us know if it is working?

Sushil Mate 4-Jul-13 7:22am

where is your server? go to server machine, log in as a admin & go to run & write iisreset & enter.

babli3 4-Jul-13 11:06am

Thanks the error is gone when i restarted the IIS. Thanks for your help :)

babli3 4-Jul-13 7:22am

thanks alot

RedDk 4-Jul-13 14:44pm

How is this not the origin of a repost?

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)

Sushil Mate · Accepted Answer · 2013-07-04T07:53:00

Solution 1

Log in as admin -> Run -> iisreset -> enter.

Hope this helps.

Posted 4-Jul-13 7:53am

Sushil Mate