I'm not able to type anything in the name column. I put the breakpoint on this line of code:
cmd.ExecuteNonQuery()
and when I open the watch window, I am unable to type anything into the name column.
I set the breakpoint and looked through all of the tabs under the breakpoint and don't see any errors.
Here's what I see in my call stack:
App_Web_vt3jqd7q.dll!_Default.SaveToDatabase(String SavePath = "L:\wwwroot\Webfile1\Data\upload.txt'") Line 75 Basic
>...
Ok I inserted a break point at that line. I looked at the output of the code and I looked at the output of the breakpoint. What I see is that where it says "condition" that it says no condition and then at hit count it says break always (currently 0).
Jbenson,
I'm new to debugging and really don't know how to do that. I know that I can insert breakpoints, but I'm sure that's not what you're telling me to do here.
Mark,
The SQL that you see there:
bulk insert dialerresults from '" & SavePath & "' " & _
"with ( fieldterminator = ',', rowterminator = '\n' )"
Is the only SQL that I have (besides the connection string)
If you strip out the SavePath statement, the command is simply...
Can someone please review my code and see where I can be missing information. I get the following error:
Line 1: Incorrect syntax near ','. Unclosed quotation mark before the character string ' )'. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)...
Mark,
You are right, it's not a permissions issue. I modified the machine.config file on the web server and impersonated the admin account to be able to work through this error and was confronted with another error about another line written within the .vb codebehind. That's my next issue. I'm...
I have a page that I've built that does a bulk insert from a file that is stored on a web server. When the user clicks on the submit button, they receive the following error:
Operating system error code 3(The system cannot find the path specified.).
I have made sure that the SQL server has...
Jason,
What I'm asking is ... where is the updatepanel? I was told that the reason that my files weren't uploading is because my "file1" is within an updatepanel. I've looked through my code and don't see where that's located. I'd gladly remove the code if I knew where it was.
I just tried to upload a file that was not in the correct format (the page is only supposed to accept .txt files and I tried to upload a .pdf) and I'm not getting any return errors for that either.
Jason,
Thank you for your response but the reason that I'm displaying the error to the user is that this is going to be used by medical offices and they are known for just sending e mails stating "this web page/link/whatever is broken or not working." The error message I'm giving them is so...
I have a site that I've almost completed and while testing it today noticed that it's not uploading any files or doing the bulk insert in SQL that I need it to. Here is my codebehind:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.