Genius!:cool:

Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Hey up my lovelies. Here at work we are considering setting up a message board / discussion forum type thing. I mentioned that CP's boards are very useable. Is this a proprietary system, or is a product you can buy or download? Can anyone make any recommendations? Ta

Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Thanks Jesse, you are of course correct! Happily, I have beaten my user group into submission...heh heh, not so sure about them being well trained though. Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Top job, you hit the nail square on the head. Thanks alot. Please see my other post for "warning" about Microsoft.ApplicationBlocks.Data. I am not an expert user of this library, so I may be talking rot - perhaps there is a config file that goes with it allowing you to play with such settings.... Thansk again. Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Thanks for your help with this, the link is very useful, but in this case, it has not solved my problem. I have posted a reply with my eventual solution, and am grateful for you advice. Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Many thanks for your replies everyone. The winning solution is indeed the SqlCommand.CommandTimeout property - changing this allows you to handle those pesky longer running SPs. Its simple when you know it, as usual, but when you don't, its an exercise in banging your head. By word of warning, this has been tricky to identify at first, as the app in question happens to use the Microsoft.ApplicationBlocks.Data, in particular, the SqlHelper class which shields you from a lot of the ADO.NET classes that you may traditionally use. AFAIK ,when you use the SqlHelper class, you are shielded from the instantiation of the SqlCommand class. I don't really need to defend my long running SP (you know I am going to, with an opening phrase like that!), but suffice to say its for a particularly complex management report with a small user set, that rolls up and process a lot of data, and it has been optimised by the relevant DBA. 33 seconds - pretty fierce eh (mild embarassment: :-O)? All in all, I am very grateful for all your prompt responses and advice. Codeproject wins again, yay!:rose: Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Hello everybody-peeps. I have a ghastly problem that I need some help with. I have a stored procedure executing on SQL Server that is serving data to an asp.net webpage. Everything works fine until I try to execute a stored procedure that takes approximately 33 seconds to run. How on earth can I increase the timeout settings for all the potential points (web server, sql server etc, the application itself). Just so you know, I have increased my connection string timeout setting by adding the following phrase:'connection timeout=0;' Lets hope some of lovelies can sort me out on this...its probably straightforward for someone who knows, but that ain't me! :-O Gah! Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Heh heh, sympathy. The other day I received a spoofed email from my account to my account. Most bizarre. I hope my machine isn't a zombie...I do have a firewall and anti-virus software so I should be ok I guess.... Blighters! Profox Jase Co-Author, "Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET" (Apress, 2004, ISBN: 1-59059-330-8) The Book

Thanks Leppie. I will take a look. I remember talking to you earlier this year / last year about graphics libraries and the like. Did you get sorted with what you wanted? Maybe we were just nattering and you didn't need anything at all.... Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Thanks boys an girls, for not hammering me. If any of you have any spare time, please do have a look at the question - I guess its one of those things that you either know, or you don't care, or you want a challenge. Well, I guess I am trying to manipulate you into solving my problem for me. There is just one piece of logic I can't figure out - Ben Peterson's Asmex code is a winner, just I am too dumb to figure out one last crucial element. Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Hi everybody. I posted a question here yesterday regarding the intricacies of the ECMA CLI standard, and how to determine the number of bytes you should read for a particular metadata table. Zoiks, sounds exciting eh? You bet. If anyone has any interest in reading .NET dlls,or any knowledge of Partition 2 of the CLI standards, please check out my question as you may be able to help. To my shame, I have accidentally cross posted this on the C# board - what a numpty! Much appreciated, thanks. Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Heh, just realised I should have posted this on the .NET discussion page. Please don't flame me, please don't flame me!:-O Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Hi everybody. I posted a question here yesterday regarding the intricacies of the ECMA CLI standard, and how to determine the number of bytes you should read for a particular metadata table. Zoiks, sounds exciting eh? You bet. X| If anyone has any interest in reading .NET dlls,or any knowledge of Partition 2 of the CLI standards, please check out my question as you may be able to help. Much appreciated, thanks. Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Hello. I am having a problem understanding the concept of .NET's relative virtual addressing system for elements of an assembly. To explain, I use a binary reader to examine a .NET dll. By reading various bits of data and using Partition 2 of CLI as a guideline, I am able to obtain RVAs of various portions / elements of the dll. My problem is, I don't understand how an item with an RVA of 8200 can exist in a file that has myBinaryReader.BaseStream.Length = 3584. Obviously, this is because I do not understand the concept of relative virtual addressing. I have looked at Ben Peterson's code and article on Codeproject (Asmex Fie Viewer for viewing .net assemblies) but unfortunately, I can't figure it out. Any help much appreciated, I am getting pretty frustrated and have spent days on this.:mad: Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Thanks all for your help. To cut to the chase, I am cancelling my ISP subsription as I now no longer need it (except for their smtp service that is) and will upgrade by hosting package with my site hosts to include smtp (they didn't supply this originally for some reason). When I say upgrade, I mean take one of the new packages rather than the old one I have that they no longer sell..... Out of interest, does anyone know how use the smtp service that comes with IIS? I guess I could use this if only I had the knowledge (sigh).... Anyway, apologies for not returning emails. :rose: Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Hi there Today is a good day, I have received my broadband package and have set it up and it all works....now I just need to figure out where an SMTP server is so I can send mail....anybody got any suggestions? :rose: Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Cool, thanks again. J Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Hey Jerzy, I tried this, but for some reason, none of the flags I pass in seem to make any difference. The sound does play though. Also, for some reason, when I use the enums as per your example, the code won't compile. I have tried subsituting the enums in the example for their values, but still things don't go according to my expectation (ie, makes no difference). Does this declaration look right for c# to you? public static extern long PlaySound(String lpszName, long hModule, long dwFlags); As far as I understand it, my alternatives are: 1. no sound at all 2. use a com object as per my original fox pro code 3. for every sound played, create a new thread, play the sound, kill the thread 4. do some asynch calls with beginInvoke and delegates and stuff. Don't want to do 1., 2. seems a good thing to learn in c#, in fact as does 3 and 4. 4 however I will have to leave until I have learnt a whole lot more or until someone explains the whole delegate thing to me. If you have any more suggestions along the lines of your original, or anything else for that matter, would love to hear 'em. Jase Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Thanks for the advice. I will try to figure out how to make an asynchronous call - I assume this would be different to the flags that Jerzy is talking about? Thanks though, will look into it. Jase Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk

Thanks alot, that's a whole lot of detail. The example clinches it. You are the man :cool:. Cheers J;) Jason King jason.king@profox.co.uk Feel the love at www.profox.co.uk