Using databases in vc++

ThatsAlok

have a look at this section :- http://www.codeproject.com/database/[^]

"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

thanks a lot but i am unable to find any info regar4ding how to use multiple tables in my application...please help....

ThatsAlok

smartymanav wrote: but i am unable to find any info regar4ding how to use multiple tables in my application Have a Try on this Mr. Manav, http://www.codeproject.com/database/caaadoclass1.asp[^] I Believe it's yours personel project at MNR

"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

thanks again but i am using odbc... no its not my personal project in my college...i am doing training in stpi and they hav given me this project to design for a college(private)..they have said that if they lie it they will recomend it to the private colege... please help... i just want to know how to use multiple tables....i know to make use of the database which only has a single table in vc++ using odbc... thanking u

ThatsAlok

Then Use this:- http://www.codeproject.com/database/caaodbcclass.asp[^] Buddy,Take my advice:- learn Goggling, otherwise it very difficult to survive in Software Field :(. smartymanav wrote: ...i am doing training in stpi STPI : Stands for Software Technology Park or India. AFAIK, there are more than 10 STPI in India. 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

smartymanav

i am in noida branch of stpi.... ya i have reached this site by googling only!!!

Michael P Butler

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 [^]

smartymanav

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

ThatsAlok

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

David Crow

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

hey u know a lot!!! i am in ganga shopping complex sec 29.....

ThatsAlok

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

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

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

ThatsAlok

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

where????

ThatsAlok

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