Viewing blogs in section Technical

Wednesday, June 29, 2011

Log o' cats

Sunday, February 01, 2009

Enum Members and the .NET Compact Framework

enum ShakeFlavour
{
    Chocolate,
    Strawberry,
    Vanilla
}

Type type = typeof(ShakeFlavour);

// Print the list of enum elements - Public and Static BindingFlags required 
// to skip internal "value__" field
FieldInfo[] fields = type.GetFields(BindingFlags.Public | BindingFlags.Static);
foreach (FieldInfo info in fields)
{
    Console.WriteLine(info.Name);
}

// Parse an enum element from a string
string myFlavour = "Strawberry";
try
{
    ShakeFlavour enumObject = (ShakeFlavour)Enum.Parse(type, myFlavour, true);
    Console.WriteLine("Shake Flavour: {0}", enumObject);
}
catch (Exception ex)
{
    Console.WriteLine("enum element not recognised");
}

Saturday, August 18, 2007

Welcome to joeldixon.com - it's the web 0.9

Wednesday, July 13, 2005

Remember Me! <flaming eyeballs>

Sub PasswordBreaker()
    'Author unknown
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Sunday, July 10, 2005

Checkers

Friday, June 17, 2005

Java Snob

Thursday, April 07, 2005

ADO.NET Strongly Typed Relationships

1. Right-click your Project in the Solution Explorer and select Add > Add New Item...
2. Select "Data Set" from the Templates list, and type the name for your item (CustomersDataSet.cs).
3. In the Server Explorer, navigate to the Northwind database tables. Drag across the Customers and Orders tables.
4. Select the Customers table and select Schema > Add > New Relation... from the File Menu.
5. This is where your relationship is defined. Change the name to CustomersOrders, and change the Child element to Orders. Clicking OK will then create the relationship for you.

DataSet1.Tables["Customers"].Rows[0]

DataSet1.Customers[0]

CustomersDataSet.CustomerDataRow customer
    = myDataSet.Customers.FindCustomerByID(1);
if (customer != null)
{
  // Print out order numbers
  foreach (DataRow orderRow in
    customer.GetChildRows("CustomerOrders"))
  {
    Console.WriteLine(orderRow["OrderID"]);
  }
}

CustomersDataSet.CustomerDataRow customer
    = myDataSet.Customers.FindCustomerByID(1);
if (customer != null)
{
  // Print out order numbers
  foreach (CustomersDataSet.OrderRow orderRow
    in customer.GetOrdersRows())
  {
    Console.WriteLine(orderRow.OrderID);
  }
}

Thursday, February 10, 2005

Dragging and dropping

Saturday, January 29, 2005

A Good (?) Idea

Thursday, January 20, 2005

Draw some shapes - WOW!