Converting Datagrid to Excel sheet in C# - C# Discussion Boards

Phanindra Kumar3-Jul-06 20:33

3-Jul-06 20:33

Yeah, i placed a breakpoint in the dataGridView1_DragDrop method and tested it. But the method is not invoking when files are dragged and dropped from the openFileDialog box.

Phanindra...

jjansen3-Jul-06 21:04

jjansen

3-Jul-06 21:04

Does your DragEnter event handler get invoked? What kind of cursor do you get when you drag from the OpenFileDialog and what kind when you drag from Windows Explorer?

Phanindra Kumar3-Jul-06 22:12

3-Jul-06 22:12

no DragEnter event handler is not invoked for openFileDialog Box. I am getting a rectangle cursor with the pointer when dragged from windows explorer and default cursor like circle with a bar in it when dragged from openFileDialog box

Phanindra...

jjansen3-Jul-06 22:39

jjansen

3-Jul-06 22:39

I think I know what's going on. When I tested my own application I noticed something strange. When I drag from Explorer, the individual controls in my application react to drag-drop events. However, when I drag from an OpenFileDialog the controls do not respond, but the Form they are on does! (I should mention that in my case the Form happens to have AllowDrop set to true.)

What you can do is to add event handlers for DragEnter and DragDrop to your application Form. In these event handlers check which control the mouse cursor is on (e.g. using the position given in the DragEventArgs) and re-route the event to that control.

Phanindra Kumar3-Jul-06 23:02

3-Jul-06 23:02

Actually the thing is here that i am using windows user control. But still DragEnter and DragDrop events are not invoked in my application. I made AllwDrop of user control to True. But no use.

Phanindra...

jjansen4-Jul-06 1:17

jjansen

4-Jul-06 1:17

It seems the application Form is the only "control" that is able to receive drag-drop events when an OpenFileDialog is open (with the OpenFileDialog belonging to that application). If you do not "own" this Form, for instance if you are developing a user control for distribution, then I'm afraid you can't do what you intent to do. Sorry Sniff | :^)

Phanindra Kumar4-Jul-06 1:35

Converting Datagrid to Excel sheet in C#

4-Jul-06 1:35

Thats OK. Thanks U. Thanks for ur cooperation Smile | :)

Phanindra...

aaraaayen3-Jul-06 1:44

aaraaayen

3-Jul-06 1:44

how to convert a contents of datagrid to excel sheet in c#.

Prya

Re: Converting Datagrid to Excel sheet in C#

MCSD-Gandalf3-Jul-06 2:41

MCSD-Gandalf

3-Jul-06 2:41

So...let me get this straight.

You posted this EXACT same message about 1/2 an hour ago, got a response in something like 7 minutes, but posted again....why? Didn't like the response? Didn't understand the response? Did you READ the response?

Gridview to Excel Sheet

aaraaayen3-Jul-06 1:03

aaraaayen

3-Jul-06 1:03

how to convert the details listed in gridview to the excel sheet.
Thanks.

Prya

Re: Gridview to Excel Sheet

psamy3-Jul-06 1:29

psamy

3-Jul-06 1:29

Hi,

refer the following link,
http://www.codeproject.com/aspnet/DAtaGridExportToExcel.asp[^]

use csharp dll in VC dotnet

scorpion_pgm823-Jul-06 0:59

scorpion_pgm82

3-Jul-06 0:59

I am developing an application in VC dotnet.However, the resources used by this project for example menus, toolbars will also be used in other VC applications.Is there any way i can use these resources as a CSharp resource Dll, so then they can be imported to my vc application.

Re: use csharp dll in VC dotnet

stancrm3-Jul-06 1:37

how to Systemtray notification

3-Jul-06 1:37

So... you have a CSharp DLL and this DLL has a resource file. Is that right ?

Then you can use this DLL in your VC++.NET Application. Just use "Reference | Add Reference" then select your CSharp DLL.

lifo.net3-Jul-06 0:50

lifo.net

3-Jul-06 0:50

my project has a phone book.and it has a birthday date. how
i notify by birthday at system tray.plz help.

stancrm3-Jul-06 1:32

3-Jul-06 1:32

Use "NotifyIcon". Just give an icon and text in it.

foysal mamun3-Jul-06 2:01

3-Jul-06 2:01

thanks u.i want that it can auto notify by birthday.

stancrm3-Jul-06 2:26

3-Jul-06 2:26

Then you must have a checking function 1 time / day. If birthday == DateTime.Now, then show notifyIcon.

foysal mamun3-Jul-06 22:24

3-Jul-06 22:24

sorry, i forgate to tell u that, my program is not run all time.. so how it possible.help me.

stancrm3-Jul-06 22:35

3-Jul-06 22:35

If your program is not running, then it is impossible to show notify icon. Just like outlook. If your outlook not running, then you cannot get message whether you get a new message or not.

foysal mamun4-Jul-06 19:10

4-Jul-06 19:10

how can i run a process when windows is start.thank for help.

stancrm4-Jul-06 19:50

4-Jul-06 19:50

Use System.Diagnostics.Process.Start(string filename);
for example : System.Diagnostics.Process.Start(@"C:\WINNT\NOTEPAD.EXE");

lifo.net4-Jul-06 20:29

lifo.net

4-Jul-06 20:29

sorry here windows means operating system. so how can i run my program when os start.thanks.

stancrm4-Jul-06 21:02

4-Jul-06 21:02

You must copy your application to this directory :
C:\Documents and Settings\All Users\Start Menu\Programs\Startup

That directory is for all users. If you want to specific user only, then you must change "All User" to other user, for example (MyAccount):
C:\Documents and Settings\MyAccount\Start Menu\Programs\Startup

foysal mamun4-Jul-06 21:27

4-Jul-06 21:27

can i use windows service for that.thankxs.

foysal mamun4-Jul-06 21:27