TryParseExact formats

what does this return?

DateTime.TryParseExact(stringArray[columnNum], "yyyy/MM/dd", dateTimeFormatterProvider, DateTimeStyles.None, out date)  when the value is 1999/02/23?


false

why? because its not a standard format?

the answer : use CultureInfo.InvariantCulture

Warnings in SSIS

apparently fail a package in run time, as opposed to , for e.g. , management studio which just shows a warning

DeletedRowInaccessibleException & linq

I was receiving this even though in the where clause I excluded deleted rows

i had to do this

//to avoid DeletedRowInaccessibleException errors AcceptChanges

            blah.AcceptChanges();

submitdisabledcontrols

submitdisabledcontrols="true" in the form tag will not help for when the server disables the control

simple c# function for stripping non-numeric

  public static string stripNonNumeric(string str)

            {

                Regex digitsOnly = new Regex(@"[^\d]");

                return digitsOnly.Replace(str, "");

            }

Great idea for builds

keep a separate workspace for builds and get the latest :this way you wont create a build from code not checked in.

Using Linq with datatables

you need a reference to datasetextensions.

the interesting thing was that was enough to bring up "where" and "order by"clauses but not group by - for that I needed a using system.linq