C#

using (OleDbDataReader reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        string foo = reader[0].ToString();
        string newcolumn = foo.Substring(foo.IndexOf(":") + 1);
                            
        object[] meta = new object[reader.FieldCount];
        reader.GetValues(meta);
        List<string> list = meta.ToList().ConvertAll(o => o.ToString());
    }
}

using (OleDbCommand command = connection.CreateCommand())
{
   int idx = 0;
   command.CommandText = string.Format("select * from [{0}$]", "Report_12251104");
   using (OleDbDataReader reader = command.ExecuteReader())
   {
       while (reader.Read())
       {
          string foo = reader[0].ToString();
          string newcolumn = foo.Substring(foo.IndexOf(":") + 1);
                            
          object[] meta = new object[reader.FieldCount];
          reader.GetValues(meta);
          List<object> list = meta.ToList();
          list.Insert(2,newcolumn);
       }
       OleDbCommand update = connection.CreateCommand();
       //I want 
       update.CommandText = "update ??what exactly?? Can I use idx to id a row by number??";
       update.ExecuteNonQuery();
       idx++;
    }
}

[WebMethod]
public FooBarResult FooBar(FooBarParameters parameters){ //FooBarParameters only if a lot
    FooBarResult result = new FooBarResult();
    try{
        ... do work here
    }
    catch(Exception e1){
        ... Perform logic to determine how much of the exception you can return and
        ... assign that to the result object in a special errors property
    }
    //Sometimes I will add misc. information like run time to the result here
}

TagLib.File tagFile = TagLib.File.Create (mp3Filename);
System.Console.WriteLine ("Album = {0}", tagFile.Album);
System.Console.WriteLine ("Artist = {0}", tagFile.AlbumArtists[0]);

public static ObservableCollection<T> ToObservableCollection<T>(this IEnumerable<T> source)
        {
            ObservableCollection<T> target = new ObservableCollection<T>();
            foreach (T item in source)
                target.Add(item);
            return target;
        }

return new ObservableCollection<T>(source);