Using databases in vc++
-
hi i am making a appliocation which facialates the procedure of student admission in a college... i hav made a database name "Students" which has 3 tables "student","fees","course" the objective of each table is clear by its name i suppose... now i have made a odbc object to link the databse in my mfc project... i want to know that how i use the data of all the 3 tables at the same time... ie i have designed 3 forms in the same project for each of the 3 tables...now i want to link the tables with the forms...how to do so???please help.... i wud b thankful...this is my first question...so please sorry for making it a long one!!!! thanks manav
Your post is a little confused. Do you want to populate each form with data from the matching database table or do you want to select data from multiple tables and display in one form? Which Database classes are you using? CDatabase? ADO? I recommend you use ADO, which you can use your ODBC connection with. Have a look at these classes[^], as they'll make it easier. Michael CP Blog [^] Development Blog [^]
-
Your post is a little confused. Do you want to populate each form with data from the matching database table or do you want to select data from multiple tables and display in one form? Which Database classes are you using? CDatabase? ADO? I recommend you use ADO, which you can use your ODBC connection with. Have a look at these classes[^], as they'll make it easier. Michael CP Blog [^] Development Blog [^]
thanks a lot Micheal i am usinf Cdatabase ya i want to actually carry out both these jobs....i have 3 forms one each for the 3 tables...for eg student form for student table...but student form will have link to the course form and will be linked by courseid....u r getting it na.... and similarly fees table will b linked to student by regno field... and i am not able to populate data in the usual way i do it for one table... consider the foll: RFX_Text(pFX, _T("[Student].[FatherName]"), m_FatherName); this is the for linking m_FatherName varaible with the FatherName field in student table... is this correct??? please help thanks
-
i am in noida branch of stpi.... ya i have reached this site by googling only!!!
smartymanav wrote: i am in noida branch of stpi.... There are three Stpi in Noida, One in Sec 29 Ganga Shopping Complex, Second Logix Park Sector 16 and Last One Electronic City Sec 62-63. In which One are you working :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
-
hi i am making a appliocation which facialates the procedure of student admission in a college... i hav made a database name "Students" which has 3 tables "student","fees","course" the objective of each table is clear by its name i suppose... now i have made a odbc object to link the databse in my mfc project... i want to know that how i use the data of all the 3 tables at the same time... ie i have designed 3 forms in the same project for each of the 3 tables...now i want to link the tables with the forms...how to do so???please help.... i wud b thankful...this is my first question...so please sorry for making it a long one!!!! thanks manav
smartymanav wrote: i want to know that how i use the data of all the 3 tables at the same time... Search MSDN for examples of INNER JOIN.
"Ideas are a dime a dozen. People who put them into action are priceless." - Unknown
-
smartymanav wrote: i am in noida branch of stpi.... There are three Stpi in Noida, One in Sec 29 Ganga Shopping Complex, Second Logix Park Sector 16 and Last One Electronic City Sec 62-63. In which One are you working :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
hey u know a lot!!! i am in ganga shopping complex sec 29.....
-
hey u know a lot!!! i am in ganga shopping complex sec 29.....
smartymanav wrote: am in ganga shopping complex sec 29..... So u are in birlaSoft :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
-
smartymanav wrote: am in ganga shopping complex sec 29..... So u are in birlaSoft :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
do u live nearby!!!! no actually birla soft is also here... i am in stpi only....they have a training division....they give out projects there byeee
-
smartymanav wrote: am in ganga shopping complex sec 29..... So u are in birlaSoft :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
hey do u live near by!!!! ya u r rite...birla soft is also here but i am in stpi only they have a training division and they give out projects here byeeee
-
hey do u live near by!!!! ya u r rite...birla soft is also here but i am in stpi only they have a training division and they give out projects here byeeee
smartymanav wrote: hey do u live near by!!!! Nope Work NearBY :) smartymanav wrote: they have a training division and they give out projects here Ok nice
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
-
smartymanav wrote: hey do u live near by!!!! Nope Work NearBY :) smartymanav wrote: they have a training division and they give out projects here Ok nice
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta
where????
-
where????
smartymanav wrote: where???? Thats Secret :)
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers, Alok Gupta