Error in copying excel chart to clipboard - C# Discussion Boards

paas5-Aug-08 3:24

5-Aug-08 3:24

If, prior to binding the data set to the grid, you pre-define your collection of grid columns and their individual data bindings (DataPropertyName) in the order you want, and set the AutoGenerateColumns property of the datagridview to false, you should be fine.

I hope that makes sense.

Re: column in datagrid

benjamin yap5-Aug-08 3:53

benjamin yap

5-Aug-08 3:53

once i set the AutoGenerateColumns to false, it does not show anything.

BTw i am using the tableAdapter in dataset.xsd.

i am not harding my coding inside my cs file

private void btnViewAll_Click(object sender, EventArgs e)
{
    //this.productTableAdapter.Fill(this.dsProduct.product);

    dataGridInfo.DataSource = null;
    dataGridInfo.Rows.Clear();
    BindingSource bs = new BindingSource();
    bs.DataSource = this.productTableAdapter.GetData();
    dataGridInfo.DataSource = bs;
}

Re: column in datagrid

paas5-Aug-08 4:16

paas

5-Aug-08 4:16

benjamin yap wrote:
once i set the AutoGenerateColumns to false, it does not show anything.

You also need to predefine the location of the columns in the grid either programatically, or by editing the columns collection directly in the grid. If you right-click on the grid, and select 'Edit Columns', you can add the columns you want and set various columns properties including, most importantly in your case, the 'DataPropertyName' which should be the name of the field as defined in the dataset/datatable being bound to the grid via the BindingSource.

Store/retrieve font in user settings and isolated storage

AndrusM5-Aug-08 2:14

AndrusM

5-Aug-08 2:14

I have class

FormData {
public System.Drawing.Font TextBoxFont;
}

I need to read/store this class in isolated storage in Winforms application and also in user settings.

Using

XmlSerializer formatter = new XmlSerializer(typeof(FormData),
"MyNameSpace");

causes exception

System.Drawing.Font cannot be serialized because it does not have a
parameterless constructor.

How to fix ?

Andrus

Re: Store/retrieve font in user settings and isolated storage

led mike5-Aug-08 5:03

led mike

5-Aug-08 5:03

AndrusM wrote:
How to fix ?

Well you are going to want to check out how to control Serialization, there are a number of ways. You probably want to start with this[^] You may end up implementing IXmlSerializable[^]

It shouldn't take you long to get up to speed, I have used it in the past and it's fairly simple.

led mike

Where do unhandled exceptions in event handlers go?

JoeRip5-Aug-08 1:29

JoeRip

5-Aug-08 1:29

When an exception in an event handler is not handled, where does it bubble up to?

It's not bubbling up to anywhere in my Windows Form app. The exception itself gets reported in the debugger output, and the event handler terminates at the offending line of code, and my program runs happily along its way - no "unhandled exception" message is displayed anywhere.

The code doesn't even stop when running hosted/in the debugger. If I wasn't watching the output window, I would have no idea the exception is being thrown.

Is this expected?

I can handle this, I guess, by carefully wrapping all the code in my event handler with Try/Catch. However, I wanted some exceptions to bubble up and be handled in my app - specifically, those *I* throw. But they go nowhere. And I'm realizing... where would they emerge, anyway?

Re: Where do unhandled exceptions in event handlers go?

astanton19785-Aug-08 2:26

astanton1978

5-Aug-08 2:26

I have had weirdness like this before when I attached the debugger to running code and there were PDB files from a different build (build and deploy on Monday, lose PDB files on Tuesday, add enough code [spaces] to change the file slightly, rebuild and try to attach to the process on Wednesday). The PDB are similar enough to allow the debugger to attach, but stepping through causes very odd behavior. Of course the solution for this is to either get the original PDB files, or rebuild the assembly and debug with the new ones.

I have also seen cases where the output window shows a slew of "MissingMemberExceptions" or other system looking exceptions that happen in the background and doesnt appear to affect my program's execution. I assume these are thrown by dependant or underlying assemblies and handled down there, before they bubble up to the calling application. The output window may just be blindly dumping any exception data from the CLR.

What kind of exception / details are in the window? Can you cut/paste that and a sample of the code that is executed right before and after the exception shows in the output window?

Error in copying excel chart to clipboard

dan!sh 5-Aug-08 1:21

dan!sh

5-Aug-08 1:21

I am trying to create an excel chart using reflection. I need to show the chart on a separate form. The chart gets created accurately but the code throws error while copying it to clipboard. Here is the code peice I am using to copy chart to clipboard.

// Copy the chart area to clipboard
oChartArea = oXLChart.GetType().InvokeMember(
             "ChartArea", BindingFlags.GetProperty, null, oXLChart, null);

---> Exception in the line below
---> Exception: Exception has been thrown by the target of an invocation.
---> Inner Exception:  Select method of ChartArea class failed.
oChartArea.GetType().InvokeMember(
  "Select", BindingFlags.InvokeMethod, null, oChartArea, null);

oChartArea.GetType().InvokeMember(
  "Copy", BindingFlags.InvokeMethod, null, oChartArea, null);

// get the chart in bitmap object from clipboard
oImage = new Bitmap((Image)Clipboard.GetImage());

// Set the chart as the image for the picturebox
oPic.Image = oImage;
oPic.SizeMode = PictureBoxSizeMode.AutoSize;
oPic.Left = 10;
oPic.Top = 20;
Clipboard.Clear();

Seeking your help....thanks

How to show all items in DataGridViewComboBoxCell

T.EDY5-Aug-08 0:22

T.EDY

5-Aug-08 0:22

hello,

can i droppeddown all items that i have in a DataGridViewComboBoxCell ?

if it ComboBox we can only set

myComboBox.DroppedDown = true;

but how i can do that in DataGridViewComboBoxCell ?

Thank u

Regards,

Tomi

Re: How to show all items in DataGridViewComboBoxCell

nelsonpaixao5-Aug-08 13:12

nelsonpaixao

5-Aug-08 13:12

Where are your items stored? in c#
Why doesn´t work like that:
ComboBox_Country.Items.Add("France");
ComboBox_Country.Items.Add("Italy");

or in database? Confused | :confused:

nelsonpaixao@yahoo.com.br

How to read an image file

Hari_10104-Aug-08 23:40

Hari_1010

4-Aug-08 23:40

Hi All,

My requirement is to read an image file from database and to save it as project file (.mpp) file in C# .Net

Many thanks in advance.

Thanks and Regards,
Hariharan C

Re: How to read an image file

Ashfield5-Aug-08 1:11

Ashfield

5-Aug-08 1:11

Ok, thats your requirement, where's your code?

Write something, post it when it doesn't work and maybe someone will help you.

Bob
Ashfield Consultants Ltd

Re: How to read an image file

Hari_10105-Aug-08 1:22

Hari_1010

5-Aug-08 1:22

Hi All,

I am able to read the file from database and save it as a mpp file. But when i tried to open in MS Project, its saying the following error,

"Project cannot recognize this file format"

The following is my code,

DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("data source=hariharan;
initial catalog=ProjectServer;
integrated security=true");
con.Open();
SqlCommand cmd = new SqlCommand("select reserved_binary_Data
from MSP_PROJECTS where
proj_name = 'TestProject.Published'", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(ds);

byte[] contentArray = (byte[])ds.Tables[0].Rows[0][0];
int len = contentArray.Length;
FileStream docStream = new FileStream("C:\\testing.mpp",
FileMode.CreateNew, FileAccess.ReadWrite);
docStream.Write(contentArray, 0, len);
docStream.Close();
con.Close();

Regards,
Hariharan.

Re: How to read an image file

astanton19785-Aug-08 2:28

astanton1978

5-Aug-08 2:28

Are you using the same byte encoding when saving and retrieving?

Re: How to read an image file

Alan N5-Aug-08 6:29

Alan N

5-Aug-08 6:29

Hariharan,
This image you refer to, is it data that is already in Microsoft Project format or is it something you need to convert to that format prior to writing out to the .mpp file.

Alan.

Re: How to read an image file

Ashfield5-Aug-08 8:28

Ashfield

5-Aug-08 8:28

I sounds rather like the file is not in mpp format.

Bob
Ashfield Consultants Ltd

Parsing color names

AmitDey4-Aug-08 23:19

AmitDey

4-Aug-08 23:19

I have string
s = "Black";

I want a color object according to this string

ie. I want
Color c = Colors.Black;

so if s = "Red" then c should be Colors.Red

How can I achieve this ?

Re: Parsing color names

Tony Richards4-Aug-08 23:23

Tony Richards

4-Aug-08 23:23

Take a look at Color.FromName. I think this does what you want.

How to search inside pdf files ?

hdv2124-Aug-08 22:50

hdv212

4-Aug-08 22:50

Hi i want to search inside pdf files (without any traditional component), can anyBody help me ?
thanks.

Re: How to search inside pdf files ?

dojohansen4-Aug-08 23:26

dojohansen

4-Aug-08 23:26

I don't know how to do it but apart from googling it I suggest you be more precise; at least I don't quite get your question: what exactly do you mean by "without any traditional component"?

Re: How to search inside pdf files ?

hdv2124-Aug-08 23:46

hdv212

4-Aug-08 23:46

before post this question, i searched in google and not found useful result.
i mean i want to use free tools.

Re: How to search inside pdf files ?

blackjack21505-Aug-08 0:54

blackjack2150

5-Aug-08 0:54

It's not as easy as it sounds.
Do you want to search just the plain text?
If so, I can suggest a solution:

Visit this site http://text-mining-tool.com/[^] and download that application.
It a program which uses IKVM to run a java PDF library (PDFBox) and which can extract the text from PDF files. For you, the most useful thing will be the command line utility (minetext.exe), which you can call from your code and it will generate a text file with the contents of the PDF. From there you can search all you want.

BTW, all the programs & tools I've mentioned above are free.

It should work pretty well, though I have encountered some PDF files which could not be understand by the PDFBox component, so I couldn't use them.

Best of luck.

Re: How to search inside pdf files ?

hdv2125-Aug-08 2:59

hdv212

5-Aug-08 2:59

thanks blackjack2150
but i want search my pdf data in database, and i can't extract each document to drive then search inside it, can anyBody tell me tradional or non-traditional component ?
thanks

Re: How to search inside pdf files ?

astanton19785-Aug-08 2:48

astanton1978

5-Aug-08 2:48

If the PDF is image based (like a multipage TIFF converted to PDF), then you will need to extract and OCR the individual images. The text data and positional information need to be saved to the cross reference table (I believe).

Once that is done (no small task), then you should be able to use the find function in FoxIt (faster than Adobe) or Adobe reader to locate the text you are trying to find.

If these are text based PDF's (not images) then you should be able to open them up with System.IO.TextReader, notepad, or similar text editing tool and search for the string you are looking for.

A high level overview of the PDF structure is here...http://www.planetpdf.com/developer/article.asp?ContentID=navigating_the_internal_struct&page=1[^]

Wiki entry... http://en.wikipedia.org/wiki/Portable_Document_Format#File_structure[^]

This one gives nice examples also...http://www.mactech.com/articles/mactech/Vol.15/15.09/PDFIntro/[^]

Jessica Cao has a nice list of other places to look here...http://forums.asp.net/p/1143759/1849142.aspx[^]

I used to have a better link that went into detail about the structure of PDF's, but I cant find it at the moment.

Excel Data Problem

Syed Shahid Hussain4-Aug-08 22:41

Syed Shahid Hussain

4-Aug-08 22:41

Hello

I'm reading an excel file, Now the problem is that when reading it make some cells blanks.
THe reason is that if the first column value is of type text ("0.98ad") then it'll show only data like this format

or when it is numeric (0.8) then it shows only numeric values.

Any idea about it?

Thanks

Syed Shahid Hussain

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