ADOX urget help

K

kaisersoze

Well-known member
Joined
Aug 27, 2003
Messages
152
I am able to create a table using ADOX, but not able to change the property of each column. By default all the columns have Required=Yes. but I want to change it to No. Please let me know how to do?
 
Why are you useing ADOX for that?

ADOX is COM and you should avoid that.

Just use a "CREATE TABLE ( ID IDENTITY(1,1), Text VarChar(100), NotNullText VarChar(100) NOT NULL);"

And send this via a OleDbCommand.
 
FZelle said:
Why are you useing ADOX for that?

ADOX is COM and you should avoid that.

Just use a "CREATE TABLE ( ID IDENTITY(1,1), Text VarChar(100), NotNullText VarChar(100) NOT NULL);"

And send this via a OleDbCommand.
Click to expand...

If i use OleDB then I cannot create Columns with memo and ole datatype.
 
it worked...

Actually it worked using Create Table .... and oledb for now. I will test for some time and confirm.

Data types:
1. OLE Object = Binary
2. Double = Number
3. Text = text
4. Memo = Memo
5. Yes/No = Bit
rest is same.
 
And if you change the underlying DB you just have to change the strings, not
the whole algorythm.
 
Back
Top