how to create a table in the database using mfc
-
In my application I have created a propertypage.In that property page I have displayed three edit boxes. For example in that edit boxes the user will enter name,sex,age. Taking those three values as column names I have to create a table in the database. while creating my project I have chosen Database view with file support. I used ODBC to connect to a datasource. Can u plz help me. Thanks in advance.
-
In my application I have created a propertypage.In that property page I have displayed three edit boxes. For example in that edit boxes the user will enter name,sex,age. Taking those three values as column names I have to create a table in the database. while creating my project I have chosen Database view with file support. I used ODBC to connect to a datasource. Can u plz help me. Thanks in advance.
Hi, it seems you have posted the question quite back sometime. ok. you can use CRecordSet like classes to create tables. before that you may need to connect to the data base using CDatabase class. you can see some samples in MSDN itself. IMHO, It's better not to attach the database with some controls. because on every change it will update the database. it will slowup the entire application if your application has enough size and others are accessing the database. you can take the values at the time of update. that would be better. This is not a solution for your problem but I was trying to explain a good practice.
-Sarath. The more you can dream the more you can do - Michael Korda"
My blog - Sharing My Thoughts, An Article - Understanding Statepattern
-
In my application I have created a propertypage.In that property page I have displayed three edit boxes. For example in that edit boxes the user will enter name,sex,age. Taking those three values as column names I have to create a table in the database. while creating my project I have chosen Database view with file support. I used ODBC to connect to a datasource. Can u plz help me. Thanks in advance.
Sometimes this [^]would help you
-Sarath. The more you can dream the more you can do - Michael Korda"
My blog - Sharing My Thoughts, An Article - Understanding Statepattern
-
In my application I have created a propertypage.In that property page I have displayed three edit boxes. For example in that edit boxes the user will enter name,sex,age. Taking those three values as column names I have to create a table in the database. while creating my project I have chosen Database view with file support. I used ODBC to connect to a datasource. Can u plz help me. Thanks in advance.
No need to repost. See here.
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb
-
In my application I have created a propertypage.In that property page I have displayed three edit boxes. For example in that edit boxes the user will enter name,sex,age. Taking those three values as column names I have to create a table in the database. while creating my project I have chosen Database view with file support. I used ODBC to connect to a datasource. Can u plz help me. Thanks in advance.
Thank you very much for all of you