C# Discussion Boards - CodeProject

Export to Excel From Data Grid In C# Windows Application

ManojKumar195-Jul-09 3:52

5-Jul-09 3:52

I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel .
How do I expoert to excel from data grid view ?

Thanks In advance !!!!!!!!! Smile | :)

Re: Export to Excel From Data Grid In C# Windows Application

Christian Graus5-Jul-09 4:09

Christian Graus

5-Jul-09 4:09

You export your data, the easiest way is to write a csv.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Export to Excel From Data Grid In C# Windows Application

Henry Minute5-Jul-09 4:09

Henry Minute

5-Jul-09 4:09

A simple google search on c# to excel got over 10 million hits.
I assume therefore, that you have read all of the relevant ones, distilled their content and attempted the task yourself.

What have you tried so far?
Where did it go wrong?

Be precise, it's annoying to have to read through lots of irrelevant code. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Export to Excel From Data Grid In C# Windows Application

dan!sh 5-Jul-09 5:24

dan!sh

5-Jul-09 5:24

System.Data.OleDb

Re: Export to Excel From Data Grid In C# Windows Application

ManojKumar195-Jul-09 6:39

ManojKumar19

5-Jul-09 6:39

Finally got solution.......

Export a DataSet to Microsoft Excel without the use of COM objects[^]

Re: Export to Excel From Data Grid In C# Windows Application

FilipKrnjic6-Jul-09 0:22

FilipKrnjic

6-Jul-09 0:22

Hi,

as d@nish said you could use System.Data.OleDb but for faster and easier work you should use some 3rd party component like GemBox spreadsheet component

Re: Export to Excel From Data Grid In C# Windows Application

ManojKumar196-Jul-09 6:23

ManojKumar19

6-Jul-09 6:23

I got the solution

http://www.codeproject.com/KB/dotnet/ExportToExcel.aspx?

request for 70-526

2222222222225-Jul-09 3:26

222222222222

5-Jul-09 3:26

hi all friends.i want to give 70-526 certification.for that i need some tutorials & question,dumps.so pls send me dumps to animashniit@gmail.com.
pls add subject your mail when u send the file to me. Sniff | :^)

animash

Re: request for 70-526

Alan N5-Jul-09 3:44

Alan N

5-Jul-09 3:44

Hi,
This is probably a good a starting place as any [^]

Hope that helps.

Alan.

Re: request for 70-526

OriginalGriff5-Jul-09 3:54

OriginalGriff

5-Jul-09 3:54

Try here: Preparation guide for 70-526[^]

Plus, unless you REALLY like spam, don't post your email address...

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: request for 70-526

Christian Graus5-Jul-09 4:08

Christian Graus

5-Jul-09 4:08

You know, any company worth working for, knows these things are useless and can quickly tell in interviews between programmers and people who got a certification by reading dumps

Re: request for 70-526

Sergey Alexandrovich Kryukov18-Oct-13 5:30

Sergey Alexandrovich Kryukov

18-Oct-13 5:30

Christian, I saw a number of your sayings against certification, as Raja collected them in his answer:
Certification on .Net Web/Windows application[^].

I want to say I could not agree more. This is wasteful, useless, but perhaps it's only useful as a little easy revenue generator for Microsoft. And a way of detection of lousy companies, those requiring or encouraging certifications for job candidates. And this is no so harmless, this is a kind of erosion of the idea of real education.

But my point is simpler than that. I think we should not answer all those questions on certifications posted on the Q&A forum, for example. We should focus more on computer science and software development. And certifications in no more than bureaucracy built around development.

—SA

Sergey A Kryukov

request for sending 70-526 dumps.

2222222222225-Jul-09 3:24

222222222222

5-Jul-09 3:24

animash

Generating a graph with Crystal Report ?

Mohammad Dayyan5-Jul-09 3:04

Mohammad Dayyan

5-Jul-09 3:04

Hi guys.
I have some data and I'm going to generate a Graph with Crystal Report !
Could you guide me, how I can accomplish it ?

Thanks a lot.

Help with webBrowser control resource use

labdakos5-Jul-09 3:02

labdakos

5-Jul-09 3:02

Good Day!

I just have a problem that I would want to be addressed. This is with regards to using multiple webBrowser controls. As you can see, when I use multiple webBrowser controls, they tend to hang the application for a while.

I think this is a threading issue, but I am new to multithreading as well so I am looking for an easier way to fix this if possible. If not, please guide me on how I can fix this, so the webBrowser controls wont hang the application since it is important in my application to let the users manipulate the form while the webBrowser controls are running. Any ideas?

Any help will be greatly appreciated, thanx!

connecting to usb via c# program

majem5-Jul-09 2:17

majem

5-Jul-09 2:17

hi there
im trying to connect to usb port with c#
i'm using the usb_lib
but i can't find my device (a simple D.O.K).
i try to loop the device_index from 0-1000
but i allways get the same strDevicePath seems to be the default one.
but i dont get the strDevicePath of the D.O.K
can anyone help???
thanks.

What is the differentation between Convert.ToInt32() and (int) Casting

dataminers5-Jul-09 1:36

dataminers

5-Jul-09 1:36

My question boundaries in primitive data types, not object.

What is the differentation between Convert.ToInt32() and (int) casting ?

For example;

double test = 5.2;
int var1 = (int)test;
int var2 = Convert.ToInt32(test);

I know if I test variable initialize to 5.5
var1 = 5
var2 = 6

Another difference here?

Thanks...

Re: What is the differentation between Convert.ToInt32() and (int) Casting

dan!sh 5-Jul-09 2:16

dan!sh

5-Jul-09 2:16

Yes there is. If you box the double value, then Convert would work but casting will not. This happens as (int) directly tries to convert test to int without unboxing.

Re: What is the differentation between Convert.ToInt32() and (int) Casting

OriginalGriff5-Jul-09 2:25

OriginalGriff

5-Jul-09 2:25

Convert.ToInt32 (and related int convertions) convert with banker's rounding whenever the argument is of type Decimal, float, or double. (i.e. if the input is between two integers, it returns the even integer.)

The (int) cast will only truncate - ie throw away the fractional part.

In addition, (int) will only work on numeric types while Convert.ToInt32 is overloaded to work with a wide range of data types.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

What is the diffirentation between Stack and Stack<Person>

dataminers5-Jul-09 1:00

dataminers

5-Jul-09 1:00

Person is my class, it contains just get and set property.

What is the diffirentation between following;

Stack stack = new Stack();
Stack<Person> stack = new Stack<Person>();

Already Stack get object type. Why I use <person>

Thanks...

Re: What is the diffirentation between Stack and Stack<Person> [modified]

Luc Pattyn5-Jul-09 1:10

Luc Pattyn

5-Jul-09 1:10

Hi,

since .NET 2.0 we have "generics", so collections can be typed, making it unnecessary to cast when something is gotten from a collection.

When you used to do int a0=(int)myList[0]; (where myList is an old ArrayList), you now can do int a0=myList[0]; where myList is a List<int>. That is easier, safer and faster.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

modified on Sunday, July 5, 2009 7:32 AM

Re: What is the diffirentation between Stack and Stack<Person>

dataminers5-Jul-09 1:29

dataminers

5-Jul-09 1:29

Sorry, I cant understand your example, both of theme same. My question related about stack and generic stack.

Best Regards...

Re: What is the diffirentation between Stack and Stack<Person>

Luc Pattyn5-Jul-09 1:33

Luc Pattyn

5-Jul-09 1:33

typo fixed, sorry.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: What is the diffirentation between Stack and Stack<Person>

OriginalGriff5-Jul-09 1:36

OriginalGriff

5-Jul-09 1:36

To add to what Luc says, it also makes it harder to use the list badly. With the earlier Stack, you could happily say:

Stack li = new Stack();
li.Push(42);
li.Push("Hello");

without complaint.
with the generic lists if you try the same thing:

Stack<int> li = new Stack<int>();
li.Push(42);
li.Push("Hello");

the compiler will complain that you can't add a string to the stack.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Form.Hide() doesn't work

Javango4-Jul-09 23:11

Javango

4-Jul-09 23:11

Hi, I am writing a background application witch you can drop in the autostart of Windows. The application has to work fully in background and should not show the form at startup.
Question: If I write "this.Hide();" just behind the automatically created codeline "InitializeComponent();" in the main form, but the program anyway shows the form!
It looks, like "Application.Run(new MainForm());" shows the form again, but I can't do anything against!?

MainForm.cs:
    public MainForm() {
      InitializeComponent();
      this.Hide();
    }

program.cs
    static void Main() {
      Application.EnableVisualStyles();
      Application.SetCompatibleTextRenderingDefault(false);
->    Application.Run(new MainForm());      
    }

Thanks for every help.

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