tig2810

Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …

Hello, Please could someone help me with the syntax to add orderlines to an order in the below? I just cant figure out the syntax for it. many thanks using System; using System.Collections.Generic; namespace ParentChild { class Program { static void Main(string[] args) { var Order = new Order { …

Hi all, I have a problem I always though i knew the answer to. I have a variable with spaces and I want to perform an operation on each. VAR="THIS" "THAT" "THIS AND THAT" "THIS AND THIS" for i in $VAR do echo "$i" done I thought that I should …

Hi all, I have an XML schema which I use to validate inbound and outbound edi files. One of the top level elements is ID. This is the primary-key or the table and is only required on outbound messages. How would I correctly annontate this with my schema? Do i …

Hi all I'm having some trouble with EF and SQL 2008 default values. Firstly, I have a column called 'CreatedDate' and the default value in SQL Server is getdate(). If I add a field in SQL server this works fine. I also have a column called Guid and the default …

Hi all This is not really a coding question but rather I'm looking for the correct term. I was about to write something so I could decorate field as adate and then use softdates or date shortcuts etc like below but on googling for some inspiration I suddenly realised I …

Hi all I'm new to the Entity Framework and trying to get my head around it but struggling somewhat. I'm trying to do something basic like the below but it bombs out with a 'Null reference exception - Object reference not set to an instance of an object." when I …

Hi all I've been trying without sucess to write values back to my app.coonfig. I have put my config and code below as I am having zero luck but I have followed MSDN/google pages. Does anyone know where I am going wrong? thanks [code] config.AppSettings.Settings["FTPHost"].Value = tbFtpHost.Text; config.AppSettings.Settings["FTPUserName"].Value = tbFtpUsername.Text; …

Hi again I thought I had this sorted until I realised the date I needed to convert was 91202 (YmmDD). Also, when specifying the format, I have no idea the relevance of the lower-case/capitalisation of the letters (YmD etc?) Any help appreciated. [code] private static string ConvertDT(string date, string informat, …

Hi all I want to create a method that converts from one time or date format (as a string) to another by specifying the inputformat and the outputformat. I can do the output as below but I'm struggling on how to specify what the input format is. Can anyone help? …

Hi all I'm literally begging for help here. I have a program that as part of other things, executes a batch file. In visual studio 2008,it works fine either either as debug or release. If I execute it fro the debug/release directories it works fine. if I copy the debug/release …

Hi If I have a class that returns a basic set of data such as: varchar Costcode, varchar costdescription, double costamount, double rateofexchange, datetime dateandtime and a few other int fields. All basic stuff. What is the best return type for this class? From reading the web it seems a …

Hi I have a problem with a console app. It will not run methods in sequence but rather runs them all at the same time? I have put some example code below. The problem is it will run the methods below at the same time, without waiting for the frs …