mozdev.org – forumzilla: index

General

I’ve been looking around for a nice app to read some of my favourite blogs. I only want to see if a new item gets posted, and so I was pleased to discover forumzilla – an extension for the Mozilla Thunderbird mail client.

It is a fairly basic extension, and it will only reall;y display the title of the post, but for me, for now – that’s enough.

Output the contents of a DataSet in HTML

C# Snippets 
private void PrintRows(DataSet myDataSet)
{
  // For each table in the DataSet, print the row values.
    foreach(DataTable myTable in myDataSet.Tables)
    {
      foreach(DataRow myRow in myTable.Rows)
      {
        foreach (DataColumn myColumn in myTable.Columns)
        {
          Response.Write(myRow[myColumn] + "
");
        }
      }
    }
  }

This method is called with

printRows(<datasetname>)

Populate a DataSet from a table in a database

C# Snippets

// Database is called “MarcTest1″
// Table is called “phonebook”
// DataSet is called “ds”

string m_Connect = “Data Source=(local);integrated security=SSPI;Initial Catalog=MarcTest1;”;
SqlConnection myConn = new SqlConnection(m_Connect);
SqlDataAdapter da = new SqlDataAdapter();
myConn.Open();
DataSet ds = new DataSet();
string sQueryString = “”;
sQueryString = “SELECT * FROM phonebook”;
da.SelectCommand = new SqlCommand(sQueryString,myConn);
da.Fill(ds, “ImportTable”);
myConn.Close();

Shuttie’s Big Adventure…

General

… a couple of years on, I admit, but a big adventure nontheless. There’s this guy I used to work with, you see. His name is Ian Shuttleworth, and a couple of years ago (has it really been that long?? Where does the time go?) he and his wife Debbie took the plunge and moved out to New Zealand. I have just found the link to his site, and I can honestly say that I am insanely jealous of the life he has made for himself out there. Bastard.

Farmer Copleys

General

Farmer Copleys is a lovely little farm shop, about 5 minutes from my house. I don’t really want to pimp businesses here, but I am consistenly inmpressed with the produce I can get from them, as well as their prices.

I’m afraid that they don’t have any online selling capability, but the plus side of this is that I know that the good stock will always be available in the shop itself.