Creating a column of my own datatype in a datatable.

[UJ]

I have a datatype that I want to use as a type for a column (It's an
enumeration.) but I can't get the syntax right.

Can you even do it? Or do I need to do it as a string and convert it back
and forth?

TIA - Jeff.

[Nicholas Paldino [.NET/C# MVP]]

UJ,

Why not just use an integer (or other appropriate data type, depending
on the enumeration) as the underlying data type? You could use a string,
but I would only recommend that if the values behind the names are fluid,
and change often.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"UJ" <fr**@nowhere.com> wrote in message
news:Ou**************@tk2msftngp13.phx.gbl...

I have a datatype that I want to use as a type for a column (It's an
enumeration.) but I can't get the syntax right.

Can you even do it? Or do I need to do it as a string and convert it back
and forth?

TIA - Jeff.

[UJ]

I'm confused - I've got a datatype defined as:

public enum Rebooter
{
NoOne,
WatchDog,
Dispatcher
};

and I would like a column in my datatable that I can use to represent that.
(This datatype get's used in a lot of places in the programs.) So I'm not
sure what your suggesting to do. Store it as an integer and keep converting
it back and forth?

TIA - Jeff.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:OW**************@TK2MSFTNGP09.phx.gbl...

UJ,

Why not just use an integer (or other appropriate data type, depending
on the enumeration) as the underlying data type? You could use a string,
but I would only recommend that if the values behind the names are fluid,
and change often.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"UJ" <fr**@nowhere.com> wrote in message
news:Ou**************@tk2msftngp13.phx.gbl...

I have a datatype that I want to use as a type for a column (It's an
enumeration.) but I can't get the syntax right.

Can you even do it? Or do I need to do it as a string and convert it back
and forth?

TIA - Jeff.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You can use set it as int and cast it back when retrieving the value

at the end you will always need to cast it back to the correct type

additionally you could try
DataColumn( "theColumn", typeof(System.Enum) )

But I have never tried the above, so no idea if it will work or not

an Int is the best option I think
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"UJ" <fr**@nowhere.com> wrote in message
news:Ou**************@tk2msftngp13.phx.gbl...

I have a datatype that I want to use as a type for a column (It's an
enumeration.) but I can't get the syntax right.

Can you even do it? Or do I need to do it as a string and convert it back
and forth?

TIA - Jeff.

[Nicholas Paldino [.NET/C# MVP]]

UJ,

Pretty much. Converting from an integer isn't a big deal at all, you
can just cast it. If you stored it as a string, it would be much, much more
difficult, since you would have to make a method call, and not just perform
a cast.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"UJ" <fr**@nowhere.com> wrote in message
news:uC**************@tk2msftngp13.phx.gbl...

I'm confused - I've got a datatype defined as:

public enum Rebooter
{
NoOne,
WatchDog,
Dispatcher
};

and I would like a column in my datatable that I can use to represent
that. (This datatype get's used in a lot of places in the programs.) So
I'm not sure what your suggesting to do. Store it as an integer and keep
converting it back and forth?

TIA - Jeff.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in message news:OW**************@TK2MSFTNGP09.phx.gbl...

UJ,

Why not just use an integer (or other appropriate data type, depending
on the enumeration) as the underlying data type? You could use a string,
but I would only recommend that if the values behind the names are fluid,
and change often.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"UJ" <fr**@nowhere.com> wrote in message
news:Ou**************@tk2msftngp13.phx.gbl...

I have a datatype that I want to use as a type for a column (It's an
enumeration.) but I can't get the syntax right.

Can you even do it? Or do I need to do it as a string and convert it
back and forth?

TIA - Jeff.