|
filename contains:
c:\work\filename.xls
The problem still remains.
modified on Wednesday, October 7, 2009 10:18 AM
|
|
|
|
|
Which is a local-machine path. So unless Sql Server and the web server are both on the same machine that isn't going to work. (You didn't say if they are.)
It shouldn't be necessary to mention this, and please don't take offense: If the file is on the client computer it's obviously also not going to work. You can of course let a user upload a file to the web server and then use it there.
In general, the spreadsheet file needs to be in a location where Sql Server can reach it, and referred to with the correct path from Sql Server's point of view. In general, you probably want your application to work whether the Sql Server instance is running locally or on another computer (your app after all probably only knows what connection string it is using).
If it is an uploaded file you may want to create a shared folder on the web server, set up with the right permissions so Sql Server can access it. You can go the other way and put the file on the machine Sql Server is on, but I believe this would require impersonation since by default the asp.net user is a local machine user that cannot use any network resources (for security reasons; should your app be compromised in some way, at least the entire network isn't at risk).
|
|
|
|
|
Btw did you remove the catch block? If so, what's the stacktrace in the exception you're getting? Just to know if it even gets to the "Execute" step...
|
|
|
|
|
There is no error in the code.
It just returns failure (As mentioned before).
|
|
|
|
|
The method returns void, not failure. So there must be an exception if you get any notice of a failure. Attach a debugger and find out what's happening.
|
|
|
|
|
If you look closely you will see, results.ToString();
It returns failure or success.
I step through t he code and see the failure.
|
|
|
|
|
protected void btnExecute_Click(object sender, EventArgs e)
It returns void. It assigns a value to the text of a label, if it ever gets to that statement.
If you cannot be bothered to do simple things I ask for so that I can help you, like remove the catch block and tell me if you get an exception and if so what the stack trace is, I am not sure I can see why I should bother trying to help.
|
|
|
|
|
I am developing on a local machine with both sql server and visual studio installed.
Any thoughts?
|
|
|
|
|
Not as long as I have no idea what the error is. All I know is that "it doesn't work".
|
|
|
|
|
Ok, I did remove the try catch statement.
There is no exception.
I step through the code and runs line by line.
You notice that in the first post I said it executes the ssis package which means that result returns success.
Ten as I explained before, I modified the ssis and now it result.tostring() returns failure.
No exception.
Thanks
|
|
|
|
|
How to prevent deletion of files on the client side?like my documents in win xp to nt delete by user
|
|
|
|
|
azamt wrote: How to prevent deletion of files on the client side?like my documents in win xp to nt delete by user
Why would any ASP.Net application do that?
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
If at first you don't succeed, repost the question
only two letters away from being an asset
|
|
|
|
|
Buy a book on ASP.NET. Look for books with the word 'dummies' in the title. Read it, and try to get a basic understanding of what ASP.NET is, and does. When you have a clue what you're working with, you'll know why there's no way you could ever hope to do this.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Greetings ..
I sit for several hours before the problem and still can not find a suitable answer.
Javascript is not exactly my forte, so I just ask once.
I want to do the following:
I have a matrix with various Checbox. This will be filled by a database in C #. If a checkbox has been clicked, ie onclick, an inquiry should be sent to the database to read from the DataBase If click the checkbox in the matrix on C #, now is the time a database query with a WHERE = presentValue be started.
http://img17.imageshack.us/img17/760/unbenanntpw.jpg
From the database should be read out what people can C #.
My problem is mainly in the transfer the collected values of javascript in ajax so that the database sends the request to obtain an answer?
I am grateful for any information
|
|
|
|
|
Create a string contains the values using javascript and submit to server as a query string. In the server, you have to implement the logic to filter the values.
|
|
|
|
|
thanks for the answer
I create a string contains the values using javascript and submit to server as a query string. In the server, you have to implement the logic to filter the values.
I collect my values with a JavaScriptFunction
function GetAllChecked() {
var checkboxes = document.getElementsByName("skill");
var s = ""
for (var i = 0; i < checkboxes.length; i++)
if (checkboxes[i].checked)
s += checkboxes[i].value + ";"
;
;
document.getElementById("hhidAcrobat").value = S;
}
exactly what I'm doing wrong?
|
|
|
|
|
Did you debug this code? what is the value of variable s after the loop? how you submit this value to server?
|
|
|
|
|
the value of my string in Js contain "43;44;45;46;47;48;49;50;51;52;53;54;"
how should i tranfer this string to my database?
|
|
|
|
|
Post this string as a query string to the target URL using XMLHttpRequest object.
|
|
|
|
|
thx for ya idea, will try it
|
|
|
|
|
I don't know what element "skill" is, but there is no HTML element that represents a "checkboxlist" so I'm guessing it's a container for the checkboxes.
Try changing the first line to
var checkboxes = document.getElementsByName("skill").children;
If it still doesn't work, attach your debugger and use the watches to see what's in the variables. If you don't know how to do this, take the time to learn it as it'll save you a huge amount of time in the long run.
|
|
|
|
|
|
It's not very clear (at least to me) what exactly the problem is. Nor can we know what AJAX implementation you are using - and there are many available.
You could of course create your own ajax implementation, but it may be a good idea to take a look at what's out there first since you'll probably find something that fits your needs and can handle more than you need too, which is good since you'll then be less likely to have to find another as requirements evolve (and they *always* evolve, unless the app is so unsuccessful that it's scrapped right away).
In general, what you're describing would consist of the following steps:
1) Collect the information that is necessary in order to query the database from the UI. Since the UI is in the browser, you'll most likely do this in JavaScript.
2) Send a request to the web server that indicates an operation and includes the above information. This too is in JavaScript, but how exactly depends on what AJAX implementation you're using.
3) On the web server, build an IDbCommand (e.g. an SqlCommand) to query the database or call a stored procedure, and execute it to get the information you need and/or do any other work the operation includes.
4) Return something to the client.
What to return depends entirely on your requirements. You should always include some indication of success or failure, so the client can inform the user in the event of an error. It may be useful to include debugging information at least in your dev environment, such as an exception stack trace. If the UI is going to display data as a result of the operation, you have the choice of returning the data and use DHTML and JavaScript to modify the UI (more scalable), or rendering the HTML server-side and return it to the client (more powerful if you use an AJAX framework that allows you to do this).
There is a "default" ajax-implementation of asp.net, and although it's not very high performance it may be a good choice (and probably fast enough). Google for "asp.net callbacks" and "asp.net updatepanel" to find tons of tutorials, documentation and code. The great thing about this implementation is that it plays nice in combination with normal postbacks. (Changing almost anything on the client with js can cause problems (related to viewstate), but asp.net callbacks do not, which is both why it may be good and why it's slower than some "pure" ajax implementations.)
If you are already using some third-party ajax framework or a custom implementation of your own, at least clarify what step in this process you're struggling with and what (if anything) you are doing, errors you are getting, and so on.
|
|
|
|
|
That there is a updateplanel I have seen. It loads only a portion of the site. And my portion, the user should be having my skills.
|
|
|
|