Exporting to Excel takes a very long time - C# Discussion Boards

Package load error in VS2005?

TheGreatAndPowerfulOz10-Nov-05 8:38

10-Nov-05 8:38

I had a similar issue. After installing the VS2005 Pro as well as the VS2005 C++ express, I got a package load error each time I started VS2005 pro OR the vs2005 C++ express editon. I uninstalled and reinstalled several times and got the same result. I also tried using the uninstall exectutable from Microsoft to no avail.

Finally I took the following steps:

1. uninstalled EVERYTHING that had to do with Visual Studio, and .NET components (2.0, 1.1, 1.0), SQL Server and MSDN, MSXML. I mean everything. I followed the uninstall directions given in the dialog after uninstalling Visual Studio and removed/uninstalled the items in the order specified.
2. Then I went to the WINDOWS\assembly directory and deleted EVERYTHING under that directory.
3. I went to "Program Files" directory and deleted everything that had to do with Visual Studio and .NET (2.0, 1.1, 1.0) and SQL Server and MSDN.
4. I also went to the following directories and deleted everything and all directories that had to Visual Studio, SQL Server, MSDN and .NET (2.0, 1.1, 1.0)

"Documents and Settings\<username>\Application Data\Microsoft"
"Documents and Settings\<username>\Local Settings\Application Data\assembly"
"Documents and Settings\<username>\Local Settings\Application Data\Microsoft"

5. Finally I deleted all tempory files in all temporary directories and cleared the internet cache and temporary files using IE
6. I also went to "My Documents" and deleted the Visual Studio stuff there.

After all that I reinstalled VS2005 Pro and VS2005 C++ express and I no longer get the errors.

Label question

Stanciu Vlad10-Nov-05 7:52

Stanciu Vlad

10-Nov-05 7:52

When rendering a string onto a Graphics, on can specify a StringFormat. The StringFormat object has propery named "Trimming". Using this feature a string that doesn't fits into a region is trimmed.

How can this be achived with a label. How can I make a label's to trim it's text?

I hope I understand...because is a rough world out there...

Re: Label question

Anthony Mushrow10-Nov-05 8:01

Anthony Mushrow

10-Nov-05 8:01

When you put text in a label doesnt it just get cut off if it doesnt fit anyway?

Or am i just confused about stuff Confused | :confused:

Re: Label question

Stanciu Vlad10-Nov-05 8:35

Stanciu Vlad

10-Nov-05 8:35

It does get cut off, meaning that what it doesn't fit it's not rendered, but the trimming method offers a way of informing the user that the text didn't fit it's area by inserting a "..." string at the end of the visible text.

I hope we understand...because is a rough world out there...

Re: Label question

Stanciu Vlad10-Nov-05 9:08

Stanciu Vlad

10-Nov-05 9:08

I kind of resoved the problem in a "manual" way : implementing my own Pain method - work's fine for what i neaded the functionality.

I hope you understand...because is a rough world out there...

Re: Label question

Anthony Mushrow10-Nov-05 9:27

Anthony Mushrow

10-Nov-05 9:27

Aww, dammit, worked out this for nothing, well i'll post it anyway, and then well, whatever:

string labeltext = this.label1.Text;<br />
			int length = labeltext.Length;<br />
			<br />
			if(length > 35)<br />
			{<br />
				labeltext = labeltext.Remove(32, length - 32) + "...";<br />
			}<br />
			<br />
				this.label1.Text = labeltext;

that number there, yeah 35 thats the one, that should be however many characters that fit into your label, and then the second number (32) should be your first number minus 3 so that the "..." fits.

And if you want to keep the original text, just save it as a different string.

Well i'm outa here ##----------------------------->>

Re: Label question

Dan Neely10-Nov-05 10:10

Dan Neely

10-Nov-05 10:10

Unless you've replaced the default font with a fixed width one this isn't a good implementation since some characters are wider than others and you maximum char count won't be fixed. The proper way to do this would be via the use of Graphics.MeasureString(...)

Exporting to Excel takes a very long time

zaboboa10-Nov-05 7:33

zaboboa

10-Nov-05 7:33

Hello,

I am trying to export a datagrid to excel, I have two basic foreach statements:

<br />
int rowIndex=0;<br />
		  <br />
			<br />
			foreach(DataRowView row in dataview) {         <br />
				rowIndex++;       <br />
				ColumnIndex=0; <br />
				<br />
										<br />
				foreach(DataColumn col in dataview.Table.Columns) {<br />
					ColumnIndex++;    <br />
					if (ColumnIndex > 3) {            <br />
					   					   theRange = (Microsoft.Office.Interop.Excel.Range)excel.Cells[rowIndex+1,ColumnIndex-3];<br />
					   theRange.Font.Name = "Arial";<br />
					   theRange.Font.Size = 8;<br />
					   			   <br />
					  					}       <br />
				} // End of INNER FOREACH statement<br />
			} // End of OUTTER FOREACH statement <br />

Any ideas why it is so slow.
Thank you very much.

Re: Exporting to Excel takes a very long time

KaptinKrunch10-Nov-05 8:49

KaptinKrunch

10-Nov-05 8:49

It appears to me that your foreach statements are incorrect. You start off looking at each row of the dataview.

<i>foreach(Dataview row in dataview)</i>

Then you loop through each colomn in the davaview
<i>foreach(DataColumn col in dataview.Table.Columns)</i>

/*
* Change this to look at each Column in that row rather
* than the entire table.
*/

Then you move onto next row.

What I see going on here is that your reading each column for every row in the dataview.

Re: Exporting to Excel takes a very long time

zaboboa10-Nov-05 9:02

zaboboa

10-Nov-05 9:02

To be more precise, I should change the inner foreach loop which loops through the columns, to something like:

for (int i = 0; i < Columns.Count; i++) {.......};

I guess like that it should b e a bit faster.
Will try it.

Thank you.

C# Book for a Course

1nsp1r3d10-Nov-05 7:10

1nsp1r3d

10-Nov-05 7:10

Hi all,

I'll be teaching C# in a school and my audience is quite young(~14-17) so I wanted to ask you what do you think would be the best book I could follow to make them really get into C#? Any suggestions are appreciated.

Regards

group box control

Manu_8110-Nov-05 7:03

Manu_81

10-Nov-05 7:03

Hi,
I doing an app in winforms. I have groupboxes with few checkboxes or radiobuttons. How do I get the value of selected control from each groupbox.
Thanks.

Re: group box control

Dan Neely10-Nov-05 7:07

Dan Neely

10-Nov-05 7:07

The data isn't stored in the groupbox at all. You need to examine the checked property of each control seperately.

Dear Inheritance - A question for you

Gulfraz Khan10-Nov-05 6:37

Gulfraz Khan

10-Nov-05 6:37

Is it possible to hide any public method or public property of the base class when inheriting that class.
If yes, then how?

Infact I am creating a custom control by inheriting a ScrollableControl and I don't want to show the AutoScroll property to user of my control (developer).

Thanks

-- modified at 12:39 Thursday 10th November, 2005

Re: Dear Inheritance - A question for you

leppie10-Nov-05 7:02

leppie

10-Nov-05 7:02

Gulfraz Khan wrote:
Is it possible to hide any public method or public property of the base class when inheriting that class.

No

^{xacc.ide-0.1-rc2 released! Download and screenshots}

Re: Dear Inheritance - A question for you

Colin Angus Mackay10-Nov-05 13:29

Colin Angus Mackay

10-Nov-05 13:29

That's a good short answer there. Direct and to the point!

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Re: Dear Inheritance - A question for you

Robert Rohde10-Nov-05 20:51

Robert Rohde

10-Nov-05 20:51

Absolutely hiding isn't possible. But there are a few tricks to accomplish what you are trying to do.
Have a look at this snippet:

[Browsable(false), EditorBrowsable(EditorBrowsableState.Never)]
public override bool AutoScroll
{
   get { return base.AutoScroll; }
   set {}
}

- It will disable Intellisense in the designer.
- It will hide it from the properties window.
- It won't allow any changes to this property

Note that if a user of your control types yourClass.AutoScroll = false then the compiler won't give any error... but who said that solution was perfect Wink | ;)

. But if you also add the Obsolete attribute then intellisense will at least give him a hint.

Time Text Field

charbelasmar10-Nov-05 5:46

charbelasmar

10-Nov-05 5:46

Dear Programmers
I want Time TextField Not Like DateTimeField he'll be with this format
for example
hh:mm AM
plz if u help me

Re: Time Text Field

Joshua Quick10-Nov-05 7:11

Joshua Quick

10-Nov-05 7:11

You should use the DateTimePicker control.
Set ShowUpDown to true.
Set Format to Custom.
Set CustomFormat to "hh:mm tt".

Mouse Events

rich_wenger10-Nov-05 3:54

rich_wenger

10-Nov-05 3:54

Hi,

I have an app that needs to trap mouse events across a form hosting multiple controls for a keep-alive timer. Any help would be greatly appreciated.

Re: Mouse Events

Dan Neely10-Nov-05 4:54

Dan Neely

10-Nov-05 4:54

Write handlers for some or all of the mouse events: MouseDown, MouseUp, MouseEnter, MouseHover, MouseLeave, and MouseMove events, and wire them to *every* control on the form.

Re: Mouse Events

rich_wenger10-Nov-05 5:08

rich_wenger

10-Nov-05 5:08

Hi, and thanks for responding. Lets say I write mouse events for Form1; how do I wire them to 'every' control on the form?

this.MouseMove +=new MouseEventHandler(Form1_MouseMove);

private void Form1_MouseMove(object sender, MouseEventArgs e)
{
//Do Something here
}

Re: Mouse Events

Luis Alonso Ramos10-Nov-05 5:32

Luis Alonso Ramos

10-Nov-05 5:32

rich_wenger wrote:
how do I wire them to 'every' control on the form?

this.MouseMove +=new MouseEventHandler(Form1_MouseMove);
btnOK.MouseMove += new MouseEventHandler(Form1_MouseMove);
txtName.MouseMove += new MouseEventHandler(Form1_MouseMove);
chkRemember.MouseMove += new MouseEventHandler(Form1_MouseMove);

and so on. Or you could also do this:

foreach(Control ctl in this.Controls)
    ctl.MouseMove += new MouseEventHandler(Form1_MouseMove);

If you have controls inside other controls (panels or group boxes for example), you'll need to do that recursively. If you always use the same handler, the same routine will be called for events raised by any controls.

I hope this helps.

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: Mouse Events

Gulfraz Khan10-Nov-05 6:10

Gulfraz Khan

10-Nov-05 6:10

And you can use the following sample code to add mousemove event handler to every control on your form (as Luis pointed out).

<br />
//you may call the function in the Form_Load event as<br />
<br />
AttachEventHandler(this);<br />
<br />
void AttachEventHandler(Control ParentControl)<br />
{<br />
	foreach (Control ctrl in ParentControl.Controls)<br />
	{<br />
		if (ctrl.HasChild == true)<br />
		{<br />
			AttachEventHandler(ctrl); // recursive call, add handler to child controls also<br />
		}<br />
		else<br />
		{<br />
			ctrl.MouseMove += new MouseEventHandler(Form1_MouseMove);<br />
		}<br />
	}<br />
}

Re: Mouse Events

rich_wenger10-Nov-05 6:15

rich_wenger

10-Nov-05 6:15

Thanks, I'll give it a try after lunch.

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