Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 975
  • Last Modified:

ADO.NET DataColumn enumeration

Dear all,

Let us assume that one of my MySQL tables has an enum column, defined as follows:


status ENUM( 'open', 'accepted', 'rejected' ) NOT NULL


I would like to define a DataColumn in my DataTable that matches this type. Unfortunately, a DataColumn cannot be of type ‘enumeration’. How am I going about this? How can I match this MySQL data type?

Many thanks in advance.

Best wishes,

Christian
0
csetzkorn
Asked:
csetzkorn
  • 2
2 Solutions
 
Bob LearnedCommented:
VarChar (8)?

Bob
0
 
csetzkornAuthor Commented:
VarChar(8)

Sure, but I would like to make it more strongly typed, to enforce that the value can only be 'open', 'accepted', 'rejected'.

BTW could someone recomend a good book, tutorial etc. on ADO.NET? I am a bit confused that I have to replicate the whole structure of the database structure in the DataSet object in order to update etc. I know that this has advantages, because the DataSet object can exist independently from the database.

Christian
0
 
Bob LearnedCommented:
You will not be able to do this with a typed DataColumn.  Your code will have to handle that validation.

Essential ADO.NET
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=YG5kAlBAaK&isbn=0201758660&itm=4

Bob
0
 
Farshid-ZakerCommented:
the better way is adding a column dynamically to your dataset of type int or byte. Have a mapping between your enumeration values and numbers 1, 2 and 3. Then add a constraint on that column, indicating it's range should be between 1 and 3.

Farshid.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now