C / C++ / MFC Discussion Boards

David Crow14-Jun-04 10:21

14-Jun-04 10:21

Sridhar Sanikommu wrote:
Did you have any example of Bulk Insert functionality?

Possibly. Assuming the table looks like:

Name Type
---- ----
col1 char(3)
col2 int

Create a file named mydata.txt that looks like:

abc,1;def,2;ghi,3;

Load this file into the table with:

BULK INSERT <table name here>
FROM 'mydata.txt'
WITH
  (DATAFILETYPE = 'char',
  FIELDTERMINATOR = ',', ROWTERMINATOR = ';')

Sridhar Sanikommu wrote:
Does it work with all the databases?

Having not used "all the databases," I couldn't possibly know.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Re: Stored Procedure Concept

Sridhar Sanikommu14-Jun-04 10:50

Sridhar Sanikommu

14-Jun-04 10:50

Hi David,

I appreciate your quick response. This is the first time I posted my question in code project though I opened my account long time back(almost two years) and been following message board Q&A's. Especially, if I encounter responses from yourself, Micheal Dunn, Ravi, Prakash(you people are top of my head) etc I go through the techniques that you guys suggest.

Keep going....pass your knowledge and empower others.

BTW, do you have any generic database module(using CDatabase & CRecordset classes) which I can get?

Thanks,
Sridhar

direct stream copy with AVIFile

Zizilamoroso14-Jun-04 6:32

Zizilamoroso

14-Jun-04 6:32

I have a question regarding copying of whole compressed (DIVX) streams with the AVIFile API.

This code snippet copies the video stream to another file, but that file gets about 10 times bigger than the original. I guess the target stream is uncompressed, but the streaminfo explicitely states DIVX.

How can I copy streams from one file to the other without decompressing/compressing (direct stream copy)?

<br />
	HRESULT hr=S_OK;<br />
<br />
	PAVIFILE pSourceFile=NULL;<br />
	PAVIFILE pTargetFile=NULL;<br />
<br />
	PAVISTREAM pSourceStream=NULL;<br />
	PAVISTREAM pTargetStream=NULL;<br />
<br />
	AVISTREAMINFO streaminfo;<br />
	BITMAPINFOHEADER bitmapinfo;<br />
<br />
	AVIFileInit();<br />
<br />
	//	SOURCE<br />
	hr=AVIFileOpen(&pSourceFile,"test_source.avi",OF_SHARE_DENY_WRITE,0L);<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	hr=AVIFileGetStream(pSourceFile,&pSourceStream,streamtypeVIDEO,0);<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	LONG bitmapinfosize=sizeof(bitmapinfo);<br />
	hr=AVIStreamReadFormat(pSourceStream,0,&bitmapinfo,&bitmapinfosize);<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	hr=AVIStreamInfo(pSourceStream,&streaminfo,sizeof(streaminfo));<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	//	TARGET<br />
	hr=AVIFileOpen(&pTargetFile,"test_target.avi",OF_CREATE|OF_WRITE,0L);<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	hr=AVIFileCreateStream(pTargetFile,&pTargetStream,&streaminfo);<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	hr=AVIStreamSetFormat(pTargetStream,0,&bitmapinfo,sizeof(bitmapinfo));<br />
	if(FAILED(hr))<br />
		...<br />
<br />
	LONG lbuffersize=20000;<br />
	BYTE* buffer;<br />
	buffer=new BYTE[lbuffersize];<br />
<br />
	//	COPY LOOP<br />
	LONG lPos=0;<br />
	LONG lLen=0;<br />
	for(long lPos=AVIStreamStart(pSourceStream);lPos<AVIStreamEnd(pSourceStream);lPos++)<br />
	{<br />
		hr=AVIStreamRead(pSourceStream,lPos,1,buffer,lbuffersize,&lLen,NULL);<br />
		if(FAILED(hr))<br />
			...<br />
<br />
		DWORD dwFlag=0;<br />
		if(AVIStreamIsKeyFrame(pSourceStream,lPos))<br />
			dwFlag=AVIIF_KEYFRAME;<br />
<br />
		hr=AVIStreamWrite(pTargetStream,lPos,1,buffer,lbuffersize,dwFlag,NULL,NULL);<br />
		if(FAILED(hr))<br />
			...<br />
	}<br />
<br />
	//	RELEASE<br />
	if(pTargetStream)<br />
		AVIStreamRelease(pTargetStream);<br />
<br />
	if(pTargetFile)<br />
		AVIFileRelease(pTargetFile);<br />
<br />
	if(pSourceStream)<br />
		AVIStreamRelease(pSourceStream);<br />
<br />
	if(pSourceFile)<br />
		AVIFileRelease(pSourceFile);<br />
<br />
	delete[] buffer;<br />
<br />
	AVIFileExit();

using: [VISUAL STUDIO 6.0 sp5] [WIN98/2]

I shut down explorer.exe but it restarts itself...

Ian Bowler14-Jun-04 5:50

Ian Bowler

14-Jun-04 5:50

I'm using TerminateProcess to shut down explorer.exe (not iexplore.exe). This works, but a few seconds after explorer.exe is terminated, it starts back up. When I terminate explorer though the Windows Task Manager it doesn't restart itself.

I want to control when exporer.exe starts back up. How do I keep it from restarting itself?

(I can post my code if anyone thinks it's necessary.)

Thanks for the help!

Ian

Re: I shut down explorer.exe but it restarts itself...

toxcct14-Jun-04 6:01

toxcct

14-Jun-04 6:01

haven't you ever noticed that when windows freezes and you have no desktop and no taskbar anymore, you can do "New task" (with Crtl+Alt+Del or Ctrl+Shift+Esc for example) and type in the field explorer...

i don't think the way you think is able to controle what you want.

TOXCCT >>> GEII power

Re: I shut down explorer.exe but it restarts itself...

Ian Bowler14-Jun-04 6:16

Ian Bowler

14-Jun-04 6:16

I'm not sure I follow you. I want to shut down explorer.exe. This I have done (I can see it dissapear from the process list in Windows Task Manager).

Now I need to figure out how to keep it from starting itself back up. I know this is possible because I have seen other applications that shut it down and keep it down. I don't suppose they continually shut it down in a separate thread?

Re: I shut down explorer.exe but it restarts itself...

jmkhael14-Jun-04 6:41

jmkhael

14-Jun-04 6:41

HWND hwndShell = FindWindow("Progman", NULL);
PostMessage(hwndShell, WM_QUIT, 0, 0L);

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q137/5/72.ASP&NoWebContent=1[^]

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: I shut down explorer.exe but it restarts itself...

Ian Bowler14-Jun-04 6:50

Ian Bowler

14-Jun-04 6:50

Thank you so much!

Re: I shut down explorer.exe but it restarts itself...

Dan Madden14-Jun-04 9:37

Dan Madden

14-Jun-04 9:37

oooppss, didn't see that you had the answer Frown | :-(

How to show xp toolbar?

JabraJabra14-Jun-04 4:55

JabraJabra

14-Jun-04 4:55

Hi,
i created a toolbar using CreateWindowEx() but i got no XP toolbar (im using xp).
how can i make it so? Confused | :confused:

looking for a tool or utility

Anonymous14-Jun-04 4:55

Anonymous

14-Jun-04 4:55

I am not looking to create, rather I am more looking for advice on something to buy.

I would like to be able to scan in paper forms and use a tool to convert the image into a form that C++ can use.

If such a tool does not exist, can you point me towards a tool that would build HTML or other interface from a paper form.

thanks

How to convert HTML to word DOC?

Tcpip200514-Jun-04 4:31

Tcpip2005

14-Jun-04 4:31

I found that a word doc file can be saved as HTML.
But how can I save a HTML as a word DOC?
Any ideas? Thank you very much!

Alick

Re: How to convert HTML to word DOC?

vcplusplus14-Jun-04 5:09

vcplusplus

14-Jun-04 5:09

Check out this site
http://www.wotsit.org

How to read all (or cell) data from *.xls?

superwolf100814-Jun-04 4:06

superwolf1008

14-Jun-04 4:06

I have a question during providing services to some users.This product should get this result:First,push the button on the dialogue; then the excel form should appear;and last,when I choose any row, the data of this row can be read by the program.Anyone know how to achieve this function? Thanks!

Re: How to read all (or cell) data from *.xls?

CAmelinckx14-Jun-04 4:33

CAmelinckx

14-Jun-04 4:33

From my experience I can tell you I've found two ways to read data from excel files, one is by adding the excel assembly reference to your project and creating an instance of the Excel application object, I suppose this would be the only way to actually 'show' the Excel grid programmatically, beware though, that this requires excel to be installed in any client executing you app. The other way is to use Extended Properties of the OleDbDataAdapter which allows you to get a range of cells or an entire worksheet into a DataTable, thereafter you can manipulate the data, show it in a datagrid or do whatever you need with it.
Chris. Smile | :)

Re: How to read all (or cell) data from *.xls?

CAmelinckx14-Jun-04 4:40

CAmelinckx

14-Jun-04 4:40

Here an msdn search that will give you some articles/samples on doing this with ado.net's dataadapter:

http://search.microsoft.com/search/results.aspx?qu=excel+file+ado.net&View=msdn&st=b&c=0&s=1&swc=0

How to add 24bit BMP to Toolbar

JabraJabra14-Jun-04 3:58

JabraJabra

14-Jun-04 3:58

Hi,
im coding proper SDK now and i did a toolbar with couple of buttons, and each button got a BMP file that i created.
how can i add 24bit bmp and not only 8bit?
Cry | :((

Avi

Re: How to add 24bit BMP to Toolbar

Johan Rosengren14-Jun-04 9:18

Johan Rosengren

14-Jun-04 9:18

In http://www.codeproject.com/docking/#Toolbars[^], you'll get an embarrassing amount of info on toolbars.

Re: How to add 24bit BMP to Toolbar

JabraJabra14-Jun-04 12:24

JabraJabra

14-Jun-04 12:24

yeah, but everything is fine except that im coding only with SDK and no MFC.
do u know the exact way to do it bcuz i searched everywhere and nothing Frown | :(

Re: How to add 24bit BMP to Toolbar

Johan Rosengren14-Jun-04 20:22

Johan Rosengren

14-Jun-04 20:22

I would have downloaded the sample for one of the toolbars, for example http://www.codeproject.com/docking/ctruecolortoolbar_update.asp[^]. Build the sample and singlestep - in this case it's the function LoadTrueColorToolBar that is interesting. Step into the MFC source, where you will see the underlying SDK calls. The main problem with MFC is not that it is complicated, rather that it is a far too thin wrapper of the SDK Smile | :)

View

Poorniselva14-Jun-04 3:03

Poorniselva

14-Jun-04 3:03

Hi,
how can i get the document pointer of CDocument derived class and traverse thru all views of the document?Say i have the caption of the MDI child Frame which should be activated..Currently that frame is inactive and some other frame is active.Now how can i activate that view....Is there any way such that i can get the handle of the child frame and then gets its window text and compare with my own text.If they both match then bring that frame and its view to active state..........how can i do it????

Re: View

David Crow14-Jun-04 3:19

David Crow

14-Jun-04 3:19

Poorniselva wrote:
how can i get the document pointer of CDocument derived class...

From the view class, call the GetDocument() method.

Poorniselva wrote:
Now how can i activate that view...

How about CFrameWnd::SetActiveView()?

Poorniselva wrote:
...and then gets its window text

Use GetWindowText().

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

how display bitmaps files in my app?

kimooo_4_u14-Jun-04 2:59

kimooo_4_u

14-Jun-04 2:59

plz
some one tell me how can i display bitmaps file in my app?

Re: how display bitmaps files in my app?

David Crow14-Jun-04 3:16

David Crow

14-Jun-04 3:16

See if any of these articles help.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Windows Service

jstarr@m-net.arbornet.org14-Jun-04 2:52

jstarr@m-net.arbornet.org

14-Jun-04 2:52

Hello,

I am currently writing a Windows Background Service and have run into some trouble.

So far things have been going well, but the only problem I have is that I need to set the state of the CAPS LOCK to on, which I am unable to achieve.

I have include winable.h and I am using the code:

::keybd_event( VK_CAPITAL, 0x45, KEYEVENTF_EXTENDEDKEY, 0 );
::keybd_event( VK_CAPITAL, 0x45, KEYEVENTF_EXTENDEDKEY | KEYEVENTF_KEYUP, 0 );

Which works in a regular console application, but I can't seem to get it to work in a windows service.

Is there some sort of security restriction that prevents me from changing the key state? Other then that, I have no idea.

Thanks in advance

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.