Thanks for your reply, much appreciated. So based on your logic could I not say that all my times are stored in Italian time but not in UTC, then try to convert them to UTC and back to the English time just for the tours in England?

First of all my apologies if this is in the wrong forum, i'm sure i will find out very quickly if it is :doh: So basically i am writing an API that needs to return the running date and time of tours including the offset, this format "2016-12-05T10:00:00+02:00", these tours can be in England or Italy so they run in two different timezones and should have a different offset. Our API and DB run on servers in the US, all the running times are stored in the db as a datetime, without any offset, without anything to distinguish the timezones they run in bar the fact they are linked to different countries. I'm just wondering what the coorect process is here, i have spent ages reading up on this and i think I'm more confused than when i started. I am thinking that maybe i need to get the running date as a universal datetime and decrease this datetime for the English tours but i'm not sure how i can update the date to have a different offset, how to set/change the date so it knows its in a different timezone. Any guidance, advice or suggestions of an appropriate blog/article to put me on the correct track would really be appreciated, thanks very much in advance.

thanks very much for taking the time to reply gentlemen, i will be investigating further when i have some more time to spend on this... cheers again!!!

Hi All, I have just written a console app to add booking info to a database based on emails pulled from an inbox. The app seems to work fine but I would like to write some tests to allow me to regularly/quickly test the functionality when somebody decides to send a surprise email format. The app is pretty basic, an Import class to represent each of the possible client emails and an Importer class to handle the actual creating of the booking in the db both of which have an interface defined to set a base of functionality required by each(IImport and IBookingImporter). Pic of project structure below. http://www.imagebam.com/image/a1cf9a322230061[^] I have a basic understanding of testing and have briefly used NUnit before but I'm just wondering if anyone has a good articles or resource(more specific than google) to help set me on the correct road to writing some tests for each of the Imports. A specific concern would be how i am going to represent/mock i guess, the email service and retrieve the mails. Although any help or advice would really be appreciated, thanks in advance

Hi All, I have added a new web service that creates an object in a database but I'm not sure what type I should be returning from the WS method as I need to access data from the newly created object and any error info that may be returned instead of an object. Any help or guidance would really be appreciated and yes i have had a look through the forums and googled this but I'm not quite sure how to phrase what I need to ask, thanks again. Tadhg

Hi, I have developed a user control that consists of a label and a datalist populated from a datatable passed to the control. This control is dynamically added to a content holder on another user cotrol on a page which represents a treatment session but on the first execution of the code only the label is populated with data after this though the page works correctly. Any help or ideas would really be appreciated thanks in advance.. Regards Tim

Thanks for ur replies guys.... I managed to find that one "Distance Covered" bug buried deep in the code and got it sorted now but the app is still crashing regularly, i have noticed that the majority of the crashes are happening in the Data Access Layer objects when they try to interact with the db. This is the most common crash i am seeing in Event Viewer. But the prob is this method is run regularly and only crashes sometimes. Event code: 3005 Event message: An unhandled exception has occurred. Event time: 13/01/2009 15:54:39 Event time (UTC): 13/01/2009 15:54:39 Event ID: 9334dc4729694b1a93e5e6d1c8789b75 Event sequence: 50 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/CD-1-128763355768712422 Trust level: Full Application Virtual Path: /CD Application Path: C:\inetpub\wwwroot\CD\ Machine name: MCORION Process information: Process ID: 8876 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object. Request information: Request URL: http://mcorion/CD/Default.aspx?Page=ViewTreatments Request path: /CD/Default.aspx User: MC\Medi Is authenticated: True Authentication Type: Negotiate Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 8 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at SportsAnalysis.DataAccessLayer.ObjectAccess.DatabaseSettings.SelectOne() at blt.BasePage.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details: Regards Tim

The problem is i have spent the last ten mins trying to get the same page to crash again and its running perfect now its doesnt make sense, the method mentioned FillPlayerMaxMinAverage does have statName as a param which may have been set to DistanceCovered but it just will not crash again, the page seems to be fine now so im just waiting for the next crash :( I managed to find the IIS logs, they are very messy, is there some less complicated way to check them ???

I have checked the Event Viewer and the most recent error is: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 13/01/2009 10:21:48 Event time (UTC): 13/01/2009 10:21:48 Event ID: a3413091a18d426ba586ccc714e6be15 Event sequence: 146 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/CD-1-128763154628476497 Trust level: Full Application Virtual Path: /CD Application Path: C:\inetpub\wwwroot\CD\ Machine name: MCORION Process information: Process ID: 10612 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: ArgumentException Exception message: Column 'DistanceCovered' does not belong to table Table1. Request information: Request URL: http://mcorion/CD/Default.aspx?Page=AmiscoPhaseComparison Request path: /CD/Default.aspx Is authenticated: True Authentication Type: Negotiate Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 10 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at blt.SS.View.ProzonePhaseAnalysis.FillPlayerMaxMinAverage(DataTable mainTable, DataTable dataTable, String statName) at blt.SS.View.ProPhaseAnalysis.btnView_Click(Object sender, ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details: The error seems to be that the Column 'DistanceCovered' does not belong to table Table1 but there doesnt seem to be any mention of this column in my code any where. Have not checked the IIS logs will find out how to and see what info that gives me. Thanks for your reply Tim

Hi All, I have a database driven web app written with C#, Asp.NET 2.0 and uses an SQL Server 2005 back-end. The app usually crashes at least once a day but some days does not crash at all and others it crashes much more often, its like it gets stuck in a loop of constantly crashing. An iisreset fixes the problem so is it safe to assume its iis that is the problem but i really need to find out what the cause of the crash is so im just looking for some advice as to where to start, are there some tools i can use or whats the best way to go about this. Any help or advice would really be appreciated Regards Tim

Hi All, I am looking for some advice/direction on software documentation, i work as the only developer in a very small company, its my first job after college so i have no real documentation experience and the company is new so basically there is none at the moment. I am developing a web app using C#, ASP.Net, VS2008 and SQL Server 2005 and have spent the last week trying to find info on where to start but no luck, so im just wondering if anyone could give me some advice or point me in the direction of some examples or anything really. Thanks in advance Tim

yes i need to change it at runtime basically because i need to apply CSS layout to 2 specific user controls but if i change the doctype for every page the entire web app is centered on the page, thanks for your reply ill check out these options Tim

Hi, I am developing an app using C#, asp.net and vs2008, i want to replace the current doctype

[!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ]

with a different version

[!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"]

when specific pages are displayed, so im just wondering if this is possible and if so what i need to be searching for? Thanks in advance Tim

its looking like the project needs to be upgraded to 2005 to have any chance of doing this, thanks for ur replies guys its appreciated Regards Tim

Thank for your reply i see what you mean but do you know is there any other way to upload multiple(up to 30) images quickly without having to place 30 upload controls on the page. Regards Tim

Hi, I am developing a web app using C#, asp.net and vs 2003 but i am having trouble trying to upload a directory of images using a single FileUpload control to select the first file and then loop through files in directory but i have discovered this only saves the first file x many times. So i am just wondering if anyone knows any way to do this, any help or advice would be appreciated Thanks in advance Tim

Obviously i know i can use the datagrid to display my results but what i was actually asking was which would be better/easier to create this format a grid or a repeater or some other control but thanks for your reply anyway

Hi, I am developing a web app using c#, asp.net and vs 2003 but I am having problems trying to create a page like the picture below. I need a grid(any control) to represent each player in the test or a single grid with headers for each player. I have the sql written and at the moment each grid on the pic has its own datatable in a dataset, so I am just wondering what is the best way to go about this I have been trying to use a repeater but I am not sure if this is the correct way. Any idea or suggestions would be appreciated Regards Tim http://img257.imageshack.us/img257/1937/testreviewoo7.jpg

oh ok nice one this is what i need thanks a lot but one last question i am just trying to test the different images on the tooltip but when i try and enter the text needed into a text box and update from there i get the following error A potentially dangerous Request.Form value was detected from the client (_ctl0:tbPic="Tip('.)') Thanks again Tim

thanks for the reply but do you know if it is possible to change the text in onmouseover="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" an example would be different users loggin on to the same page and viewing a pic specific to them in the tooltip