Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Henk1
  • Order by date
  1. Henk1

    How do I set up the proxy for a web request?

    Thanks alot for the answer. I now get another error message saying that the connection was closed. But I think our firewall is blocking my request. I'll try tonight at home. Thanks again.
  2. Henk1

    How do I set up the proxy for a web request?

    Good day, I am using the following code to get the HTML from a web page. But I get a proxy authentication error. How would I set up the proxy details (server, port, username and password) for our proxy server to get past it? // Setup our Web request System.Net.WebRequest request =...
  3. Henk1

    Looking for advice in emigrating to USA doing IT

    Very True, M1ke! I have in the mean time re-thought my situation and decided that I will not be going to america. A couple of other countries are in scope though. Thanks for the help, and sorry for the late response.
  4. Henk1

    How do I add the values of a field that contains a duration?

    Sorry about my post. I got the answer. What I did was write this function : CREATE FUNCTION fnSeconds (@CallTime nVARCHAR(50)) RETURNS DECIMAL(18,2) AS BEGIN DECLARE @CallSeconds DECIMAL(18,2) DECLARE @CallMinutes DECIMAL(18,2) DECLARE @CallHours DECIMAL(18,2) SELECT @CallSeconds =...
  5. Henk1

    How do I add the values of a field that contains a duration?

    Good day, How would I add nVarChar fields with values "00:00:02", "00:00:05", etc, etc, simulating the duration of a telephone call together? I tried using SUM(field) but it cannot add up a nVarChar field. I also tried using SUM(CONVERT(datetime, field)) but that does not work either, saying...
  6. Henk1

    Creating a file with C#

    Well, that was the problem. I want to just thank everyone that was involved in this, as the problem is now resolved. It seems that the anonymous logon just did not have the access to write a file. Now, obviously I cannot give this user ID (anonymous login) admin access. So what kind of access...
  7. Henk1

    How do I get this data(from DB) into a dataset

    Hmmm, This is what I thought. Ok, thanks for the help. I will now start researching into the CommandBuilder Object, as I have never seen this. Will ask again if I cannot figure it out. Thanks again.
  8. Henk1

    How do I get this data(from DB) into a dataset

    oh. Thanks. I have used sqldataadapter before, byut never knew what the diffirence was. I am however free to use SQLDataAdapter at any time, am I not? Whether I am updating, I can still just call my stored procedure, or write inline sql statements? Am I correct in doing it this way? Also...
  9. Henk1

    Creating a file with C#

    ok, the persmissions that is set on my web site virtual directory is as follows. I have anonymous access enabled, with a user called "IUSR_AT007359" with access to the guests group. Also, I am allowing IIS to control the password. Then I also have digest authentication for windows domain...
  10. Henk1

    How do I get this data(from DB) into a dataset

    Good day all, I have been playing around with diffirent ways of getting data from DB's. I have this code: SqlConnection mySQLConn = new SqlConnection("workstation id=AT007359;packet size=4096;user id=sa;data source=AT007359;persist security info=True;initial...
  11. Henk1

    Creating a file with C#

    I would presume so. ASPNET has admin rights to my machine. Do I use the ASPNET account to run the code? I think so. How do I check? Well, if it is the ASPNET account, then I don't think it is permissions based. I am really giving up with this now. I just don't know what to do... Could it...
  12. Henk1

    Creating a file with C#

    Ok, what I tried now, is to create and empty file, called summary.html in the correct directory, and then ran the program again. Now the message it gets is: "Cannot access read-only document 'Summary.html'." And I checked, it is NOT read-only. Why would it do this?
  13. Henk1

    Creating a file with C#

    thanks for all the help. However, I am still getting the same problem. I just don't know what I am doing here. I copied your (obislavu) code for saving and I am still getting the same problem. It seems that the only diffirence is in the way the path is created/set up. The rest of my code looks...
  14. Henk1

    Creating a file with C#

    Well, the problem is that there is no such file. I searched my whole HDD for it, and I cannot find it. It has not been saved yet, as it crashes with this error message before it can get saved. On a sidenote. How do you get those nifty "Quote" and "Code" blocks?
  15. Henk1

    Creating a file with C#

    Thanks alot ChipH! Really good stuff. Just a "fairly" stupid question... After what you typed in there, after this "fileExists = File.Exists(filePath); if (fileExists) { FileAttributes fileAttr = File.GetAttributes(filePath); fileReadOnly = (fileAttr & FileAttributes.ReadOnly) ==...
  16. Henk1

    Creating a file with C#

    Sorry, maybe I should just point out that I am trying to create this file, and overwrite it if it exists. I want to redirect to this page once it is saved. Because of this, the page is saved in my inetpub\wwwroot\applicatation dir on the HDD. Any ideas?
  17. Henk1

    Creating a file with C#

    Good day, I am creating a file with this statement... xlApp.ActiveWorkbook.SaveAs(FilePath + "\\Summary.html", Excel.XlFileFormat.xlHtml, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing...
  18. Henk1

    Basic things that I just don't understand

    Thanks. It really makes sence. I always knew this (in other programming languages) and alwasy done it, just never knew that it was the same as a property get and set. Thanks alot for clearing it all up for me. Did the courses and they just never explained it to me like this.
  19. Henk1

    Basic things that I just don't understand

    Well, thanks again for all the answers. Really learned alot.
  20. Henk1

    Basic things that I just don't understand

    Ahh, ok. I understand the get/set thing now. So it is basically only to get nice structure to your code and make it more amintainable, but in effect does the same job as using variables and using functions or inline code to check for data. That makes sence then. Thanks for the explanation...

Part and Inventory Search

Back
Top