Viewing blogs tagged .NET

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");
}

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);
  }
}