Comments by Vic91 (Top 33 by date)

Yes I did. This will improve my coding from now on. They never taught me this at school. Thank you very much!

Thanks. The links to your other answers helped me get a better idea of this. I was taught how to catch exceptions but never was I told when it is best to do so.

All right thanks. I'll see if I can detect the return code in the ssis package somehow

Thanks! I thought something like that. Question though, are negative return codes standard for failure codes? Will my package read the return code as a failure and fail the task? From what I know, I think it wouldn't. Let's say that the main purpose of my application is to be called from an external process to run in the background and not be called from the command line. Should I, in this case, just let the exception terminate the application? I'm just wondering if it's worth getting the "Application Terminadted Unexpectedly" messages so that my packages will work ok, since I'm probably not going to call it regularly from a different source anyways. I thought that there might be a different way to tell that the application failed but still catching the Exceptions

Oh! I get it. Thanks. But do you have any idea why I can't access the parameters? I know it has something to do with security, but I tried adding a user and password to the connection string and the parameters are still not visible.
The parameter 'MyParam' does not exist or you do not have sufficient permissions.

I opened up the project on SSDT and saw that the parameters are configured at project level and not package level, so it kind of makes sense for them not show up, but then, how is it asking for them?

And where do I asign this value? I mean, where do I specify to the package which environment to use? Could you expand on where do I find this and how to use it?
I tried accessing it like this.
EnvironmentInfo env = ssis.Catalogs["SSISDB"].Folders["MyFolder"].Environments["MyEnvironment"]
but this doesn't seem to have that method. And even if I get the values I still can't pass them on to the package because I'm accessing it remotely maybe...

I included the link to the example I'm refering to but I added the code anyways. Still, I don't yet have code for passing on envirenment variables.

Thanks! This is very interesting. I have a different concern now in which I hope you can help. What is the propper way of designing a web site structure, and by this I mean, the relationship between static web pages and dynamic web pages? Say I have a page called view_product.php that I use to access the database and display the information of a certain product, and I use it to view ALL products. Is this right? Because I understand search engines don't like this. I've seen on most web sites that when you access a specific post per say, it usually is a static page, and that makes sense to me, otherwise I don't know how the search engines would find it. I read something that I want to try, and that is caching static pages from the dynamically generate page. Do you have any insight on the subject?

This is embarrasing.. I forgot to change the connection string. I couldn't see this was the problem because I built a class to manage data base connections and the error I got was when instatiating this class. Thanks anyways.

This is embarrasing.. I forgot to change the connection string. I couldn't see this was the problem because I built a class to manage data base connections and the error I got was when instatiating this class. Thanks anyways.

I'm using .net framework 4.0 on a 32 bit OS.
I didn't write the error message because.. well look:
"An exception occurred in initializer type Globals" (Globals is a module).
it basically won't initialize any form or module in the project. And I have used the same instance of the connector for a different application that worked just fine just a couple of months ago. I can't make any sense of it because I keep changing it from sql server to mysql and it works with the first but not with the second.

Thanks, I'll give this a try! I though about this but I just wasn't sure what sort of objects where allowed to be saved in the session variables.

Hey thanks, I didn't see this because is not posted as an answer. Thanks for taking your time though! I tried it again and it did work. I replaced both rams on December and my computer is almost good as new. :)

Thanks for your time guys, really. I've been reading your comments and honestly It's kinda hard for me to understand everything perfectly (specially since English is not my native language) but I think I do. I haven't a strong knowledge of all the tools in .NET programming yet, since most of what I do know I've learned myself. I had worked with threads a bit when trying to write a socket based chat app, but I had never used events and I've been studying them for the last hour and I think it works perfectly for what I'm trying to do. Nonetheless I'll look into threading as well, for future reference. :) Again, thank you all!.

Thanks man I already started looking into this stuff. This is all new to me unfortunately so I will have to do some studying.

try converting it. If the above won't help, (though they should), try
val(n)

Do you think you could provide the vb coding for this please? I tried to translate it But I get an error. I'm guessing I should write this on the sub that awaits for the clients petitions?

Thanks!

Just one more thing, how can I code a description for the properties? So that when I'm coding and I call the property, the tooltip will tell me what it's for?

Yes that is what I though. And AllowEnlargeWhenFocus IS boolean.. I just wasn't sure what the propper way of doing this was. Thank you very much!

I now know what the problem was.. There was a shape (a rectangle) in the background of the button that had a lense effect or something and that seemed transparent while edditing but not when I exported. I removed it and now everything's fine. Thanks for your time though! :D

Wow, this is much much simpler. Thanks!

I fixed it, yes I was sending the right HWND, just not at the right time. I called it on mainform.activate.
Thanks!

I did run into that but I can't make it work when I click the main form. The main form just activates and the "go to" form stays inactive. I tried it in the main form click and got focus events and nothing.

I think it's easier to convert from C# to VB than the other way around... VB is just more cooperative (so to say). You should probably give a try at converting it yourself so you add to your experience.

Thanks a lot! It works perfectly!

Thanks! It makes sense but I just tried it and I have some errors. I've never used timers and I get this error:
"Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on"
Could you please tell me how I should fix this?