kaisersoze Posted August 9, 2005 Posted August 9, 2005 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? Quote Note: I think as a programmer not as a human, so use my answer at your will
FZelle Posted August 9, 2005 Posted August 9, 2005 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. Quote
kaisersoze Posted August 9, 2005 Author Posted August 9, 2005 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. If i use OleDB then I cannot create Columns with memo and ole datatype. Quote Note: I think as a programmer not as a human, so use my answer at your will
kaisersoze Posted August 10, 2005 Author Posted August 10, 2005 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. Quote Note: I think as a programmer not as a human, so use my answer at your will
FZelle Posted August 11, 2005 Posted August 11, 2005 And if you change the underlying DB you just have to change the strings, not the whole algorythm. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.