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
}