C / C++ / MFC

Re: How to connect a database(MS Access)to the MFC application.

17-Oct-07 1:30

Hi all,

Can you guys tell me how to connect a Access database to a MFC application. What are the steps I have to involve with.

Thanks.

I appreciate your help all the time...
Eranga Smile | :)

ThatsAlok17-Oct-07 1:42

ThatsAlok

17-Oct-07 1:42

Eranga Thennakoon wrote:
Can you guys tell me how to connect a Access database to a MFC application. What are the steps I have to involve with.

Connecting MS Access to MFC app[^]

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Re: How to connect a database(MS Access)to the MFC application.

CodingLover17-Oct-07 18:34

Re: How to connect a database(MS Access)to the MFC application.

17-Oct-07 18:34

Thanks, I'll be back if I got any issue. Wink | ;)

I appreciate your help all the time...
Eranga Smile | :)

ThatsAlok17-Oct-07 20:28

ThatsAlok

17-Oct-07 20:28

Eranga Thennakoon wrote:
I'll be back if I got any issue

you are always welcome!

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Re: How to connect a database(MS Access)to the MFC application.

Hamid_RT17-Oct-07 1:50

Hamid_RT

17-Oct-07 1:50

See Retrieving, Writing, and Creating Data in a Microsoft Access File (CDaoDatabase and CDaoRecordset)[^].

Re: How to connect a database(MS Access)to the MFC application.

chandu00417-Oct-07 2:04

Re: How to connect a database(MS Access)to the MFC application.

17-Oct-07 2:04

hai eranga,
you have started a new thread means, your previous problem is solved! Big Grin | :-D

lets see how long does it take for this thread to be completed. Sigh | :sigh:

and to your question, many articles are here in this codeproject.com. you can pick up the best one and look into. D'Oh! | :doh:

i think, already you got some replies.
gud luck. Laugh | :laugh:

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

ThatsAlok17-Oct-07 20:24

ThatsAlok

17-Oct-07 20:24

chandu004 wrote:
i think, already you got some replies.

offcourse he have got many reply.. don't he!!! [ Smile | :)

]

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Re: How to connect a database(MS Access)to the MFC application.

CodingLover18-Oct-07 1:47

Re: How to connect a database(MS Access)to the MFC application.

18-Oct-07 1:47

May be I'm the luckiest person on this forum Big Grin | :-D

Actually straighter way I have a question. Lots of database are available for our work,

MS Access
MySql

So, which one is th most powerful and easy to use in MFC applications.

I appreciate your help all the time...
Eranga Smile | :)

David Crow18-Oct-07 2:32

David Crow

18-Oct-07 2:32

Eranga Thennakoon wrote:

So, which one is th most powerful and easy to use in MFC applications.

Each has their own strengths and weaknesses.

"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

Re: How to connect a database(MS Access)to the MFC application.

CodingLover18-Oct-07 18:10

Re: How to connect a database(MS Access)to the MFC application.

18-Oct-07 18:10

That mean it is depend on the application going to develop, isn't it?

I appreciate your help all the time...
Eranga Smile | :)

David Crow18-Oct-07 2:33

David Crow

18-Oct-07 2:33

I tried this once here.

Re: How to connect a database(MS Access)to the MFC application.

CodingLover18-Oct-07 19:37

Bitwise operations (Masking)

18-Oct-07 19:37

Thanks. But I think it is better to go with SQL. Do you use such any...

I appreciate your help all the time...
Eranga Smile | :)

cydd17-Oct-07 0:26

17-Oct-07 0:26

Hello everyone...
Good day to you....

Is there any way to dynamically mask a group of bits to retrieve certain values from them?

0000 0000 0000 0000 0000 0000 0000 0001 0000 0000 0111 0010 0001
MSB LSB

There are a total of 52 bits .
Now there is a variable say "x" depending on which I should divide this bits to calculate two values.

I am using shift operators and masking to get this job done.

Suppose x is 20
0000 0000 0111 0010 0001 would give me the first value and
0000 0000 0000 0000 0000 0000 0000 0001 would give me the second value.

I am able to do it only for a predefined value for x i.e only for 20.

I have to mask these 52 bits in such a way that I am able to get the answer for the varying vlaues of x.
Is there a way to do this anyway.

Please help me if anyone knows to do this.

Thanks

cyjoy

chandu00417-Oct-07 0:42

17-Oct-07 0:42

u mean, you want to return first x bits in value 1 and remaining 52-x bits in value 2 right?

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

cydd17-Oct-07 0:54

17-Oct-07 0:54

Yes you are correct..
If you could let me know how to do it.

thank you

cyjoy

chandu00417-Oct-07 1:00

17-Oct-07 1:00

give me few minutes iam working on it.
and is your variable a 64 bit integer?

---------------------------------------

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

chandu00417-Oct-07 1:09

17-Oct-07 1:09

and here is what you require.
UINT64 value,value1,value2,maskval;
maskval=0xfffffffffffffff;//assigning the 8 byte integer to all 1s.
maskval=maskval<<x;<i>//x is the number of bits you want to mask.
maskval=~maskval;//toggling the bits from 0 to 1 and vice versa.
value1=value&maskval;
value2=value>>x;

----------------------------------------

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

cydd17-Oct-07 1:46

17-Oct-07 1:46

Thank you very much for your help.

I ll be obliged if you could illustrate me with the example which I have mentioned on my question.

0000 0000 0000 0000 0000 0000 0000 0001 0000 0000 0111 0010 0001
MSB LSB

There are a total of 52 bits .
Now there is a variable say "x" depending on which I should divide this bits to calculate two values.

Nelek17-Oct-07 1:57

Nelek

17-Oct-07 1:57

Try coding it and giving a few values to X while debugging or printing them in the screen to know if adapt to your needs

Greetings.

--------
M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?

Help me to understand what I'm saying, and I'll explain it better to you

Wink | ;)

cydd17-Oct-07 2:05

17-Oct-07 2:05

I ll do it....
Thanks .. Smile | :)

chandu00417-Oct-07 1:58

17-Oct-07 1:58

why not, definitely.
value=0000 0000 0000 0000 0000 0000 0000 0001 0000 0000 0111 0010 0001
first, you will define a maskval with all 1s.
1111 1111 1111 1111 ........upto 64 bits.
then, shift the bits left, x many number of times.
for example, if x is 6, the lsb portion of ur maskval looks like this
1111 1111 1100 0000
if you not this value,
1 s become 0s and 0 s become 1s. something like this
0000 .......0000 0000 0011 1111.
now if you and this maskval with ur original val, then
first 6 bits will get filtered into value1.
to get value 2 right shift ur actual value by x bits.
thats it.

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

cydd17-Oct-07 2:03

17-Oct-07 2:03

You are wonderful Smile | :)

That was of great help.

I ll defenitely get back to you if I need any further assistance...
Hope you ll help me Smile | :)

Thanks a lot.....
Have a nice day..
Happy computing.

cyjoy

chandu00417-Oct-07 2:08