Exporting to CSV with dynamic field type handling

Posted by serhio on Stack Overflow See other posts from Stack Overflow or by serhio
Published on 2010-04-02T10:13:27Z Indexed on 2010/04/02 10:23 UTC
Read the original article Hit count: 203

Filed under:

.NET

|

generics

|

oop

I have to do an export from DB to CSV.

field; fileld; field... etc

Have 3 types of fields: Alpha, Numeric and Bool respresented as "alphaValue",intValue and True/False.

I try to encapsulate this in a fields collection, in order to export if alpha then set "", if Bool=>True/False if numeric let as is.

and try to build a CsvField class:

  Public Structure?Class CsvField(Of T As ???)

  End Structure

  Enum FieldType
    Alpha
    Bool
    Numeric
  End Enum

any suggestions welcomed.

© Stack Overflow or respective owner

Related posts about .NET

Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
12.04: Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
What's New in ASP.NET 4

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved Web development. This document provides an overview of many of the new features that are included… >>> More
.NET Reflector 6, .NET Reflector Pro, TestDriven.NET, .NET 4.0 and Mono

as seen on Simple Talk - Search for 'Simple Talk'
By now you may well have noticed that .NET Reflector 6 and .NET Reflector Pro are out in the wild. The official launch happened today, although we actually put the software out last Thursday as part of a phased release plan to ensure that everything went smoothly today which, so far, it seems to have… >>> More
Redmine on Apache2 with Passenger issue

as seen on Server Fault - Search for 'Server Fault'
I installed Redmine and run it in Apache2 with the Passenger module. Apache2 boots, Passenger module gets loaded and the Redmine welcome page is shown, however when trying to login or navigate to other parts of the Redmine site, the browser keeps loading and loading and loading forever, although the… >>> More

Related posts about generics

Java generics: What is the compiler's issue here?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following methods: public <T> T fromJson( Reader jsonData, Class<T> clazz ) { return fromJson( jsonData, (Type)clazz ); } public <T> T fromJson( Reader jsonData, Type clazz ) { ... } The compiler is saying about the first method: type parameters of <T>T… >>> More
Why does NUnit ignore datapoints when using generics in a theory

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to make use of the TheoryAttribute, introduced in NUnit 2.5. Everything works fine as long as the arguments are of a defined type: [Datapoint] public double[,] Array2X2 = new double[,] { { 1, 0 }, { 0, 1 } }; [Theory] public void TestForArbitraryArray(double[,] array) { // ... } It… >>> More
Instantiating generics type in java

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to create an object of Generics Type in java. Please suggest how can I achieve the same. suppose I have the class declaration as: public class Abc<T> { public static void main(String[] args) { // I want to create an instance of T } } >>> More
.NET converting simple arrays to List Generics

as seen on Stack Overflow - Search for 'Stack Overflow'
This question might seem trivial and also stupid at the first glance, but it is much more than this. I have an array of any type T (T[]) and I want to convert it into a List generic (List<T>). Is there any other way apart from creating a Generic list, traversing the whole array and adding the… >>> More
Instantiating a list of parameterized types, making beter use of Generics and Linq

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm hashing a file with one or more hash algorithms. When I tried to parametrize which hash types I want, it got a lot messier than I was hoping. I think I'm missing a chance to make better use of generics or LINQ. I also don't like that I have to use a Type[] as the parameter instead of limiting… >>> More