How to access properties of Access Database Table using C# ADOX?

Posted by Sachin G on Stack Overflow See other posts from Stack Overflow or by Sachin G
Published on 2009-07-20T19:39:24Z Indexed on 2010/06/07 1:02 UTC
Read the original article Hit count: 245

Filed under:
|
|
|

I have created MS Access Database using C# ADOX library. I have created one table with several columns. What I want to achieve is when I insert date in one column, the date format should be YYYY-MM-DD and not MM-DD-YYYY. I know its just display format, but I want to access the property which we set when we open access table in design mode, and for column with date data type, set format as Custom (YYYY-MM-DD). I want this to be set at runtime while creating table only. I wanted to know what should be property name that I should use in order to access and set the format property of column?

© Stack Overflow or respective owner

Related posts about c#

Related posts about .NET