|
The header on an Excel file contains a null early on, around 10 characters in. If you're sending the contents of a file as a string, it'll hit the null and consider that the end of the file and not send the rest. Take a look at the size of the received attachment: is it resonable? A completely empty Excel 2003 file is 13824 bytes, so if it's much less than that, this is probably what's happening.
Post a code snippet of your attach and send call. You may be missing (or the framework may be missing) something to designate your attachment as binary.
Stephan
|
|
|
|
|
Hi,
Excuse me if I use the worng terms but I'm new to this - be gentle with me!
I've created a DataGrid programmatically, made it sortable and paging etc.. What I'd like to do now is add some edit functions. What I would like to be able to do is click on a edit button on a row of the DataGrid, and instead of editing the data within the DataGrid (which seems to be the only examples I can find), I'd like the data from the row to be placed into a form. I've added a buttonColumn which is now firing my function - All I have to do now is write the function.
Can anyone help?
Thanks
|
|
|
|
|
If you know the row index for your button, you could always
read each cell into a stringvariable using myGrid[row,col].
So if you have 4 columns you could do it like this:
(assuming you have the rowindex and a form that accepts the
data as string array in the constructor)
private void rowButton_click(object sender, System.EventArgs e)
{
string[] gridDataList = new string[4];
int rowIndex = ...get the rowindex from button or something...
for(int i = 0; i < 4; i++)
{
gridDataList[i] = myGrid[rowIndex, i]
}
DisplayDataDialog myDlg = new DisplayDataDlg(gridDataList);
myDlg.ShowDialog();
}
-Larantz-
|
|
|
|
|
hi all,
is there a namespace named Excel ?
using Excel; ???
if yes, why cant i use this ?
is there something missing with my installation ?
(how can i install this missing part ?)
|
|
|
|
|
There is no namespace, there is a COM component.
right click ur solution in ur Solution Explorer, and click on the tab "Add Refferance".
click on the COM tab and search for Microsoft Office\Excel 9\11 (don't remember).
Although I want to warn you, it's easyer to just copy the start and the end from the source of the exel (like html) and write it with stream to a file with .xls ending then using this component.
|
|
|
|
|
Hello!
I loking for some solution to get a stream from large files.
I writing an application witch uses SharpZipLib to create .zip archives. I use File.Open to get a filestream , and then giv it to the component, witch writes to the zip stream.
It works great, but in bigger files the app use a great amount of system memory.
I don't know how can I make it better, how can I make som keind of pipeline, or list from the stream...
Can someone have an idea?
Thanks for help!
|
|
|
|
|
A file stream doesn't use any more memory if you open a large file. It's probably the compression component that uses the memory.
I don't know if that specific library supports this, but speaking generally about zip compression:
The amount of memory the compression uses depends on the compression rate selected. If you select a lower compression rate it should use much less memory. The difference in file size between different compression rates are usually quite small.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for the answer!
I try change the compression level (currently is 6, and the maximum is 9). But I don't understand, why is the compression level changes memory usage, I think bigger level eat mutch CPU time, but memory...
So you said File.Open method handle the large file problem? And what about reading time?
|
|
|
|
|
Zip files work by creating a 'dictionary' where each bit string in the dictionary stands for a longer bitstring in the compressed file. Higher compression levels create a larger dictionary length.
|
|
|
|
|
nemopeti wrote: So you said File.Open method handle the large file problem?
Yes. A stream uses a buffer to read a small part of the file at a time. The default size for the buffer is 4096 bytes, so that's certainly not the cause of the memory consumption.
nemopeti wrote: And what about reading time?
What about it?
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: nemopeti wrote:
So you said File.Open method handle the large file problem?
Yes. A stream uses a buffer to read a small part of the file at a time. The default size for the buffer is 4096 bytes, so that's certainly not the cause of the memory consumption.
but for a compressed file, the dictionary needs to be in memory until the extraction is completed.
|
|
|
|
|
Yes, the compression uses a lot of memory. The file stream doesn't.
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I want to enhance MenuItem with right click event in the same manner as "Favorites" in Internet Explorer work.
Does anybody have any Idea?
~Shash
shash
|
|
|
|
|
Hi,
I working on a solution where I want to send a MSXMLDOM from a unmanaged application to a .NET class. In my .NET class I want to use the System.XML classes to read the XML data. My .NET class is visible as a COM object.
What datatype should my inparameter be, so I can convert the MSXMLDOM sent in to a XMLDocument in .NET?
\Jonas
|
|
|
|
|
Jonas,
Is there a reason that you can't serialize your data into XML then read it into the XMLDocument? That's what XML was made for: inter-platform communication.
s}
|
|
|
|
|
Yes, there is. The "exporting" application has a problem with large strings  Thats why I don´t want to send the data as a string.
\Jonas
|
|
|
|
|
If you can have your MSXMLDOM output the entire XML document as string, then you can use xmlDoc.LoadXml(string xmldocument).
public XMLDocFromDom(string xmldocument)
{
this.xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xmldocument);
}
-Larantz-
|
|
|
|
|
Hello!
I got a few problems:
1)
I´m making a program that runs another, I used PostMessage to call File->Import, there comes my problem, a Folder Browser Dialog is opened and I have no idea on how to deal with the treeview box, my program must select a specific Folder.
I would like to know also about ListView and Combobox!
2)
How can I enumarate all the controls in a window so that I can (for instance) press buttons, check radio buttons, read labels etc?!
Thanks!!!
|
|
|
|
|
suguimoto wrote: I would like to know also about ListView and Combobox!
visit:
http://www.codeproject.com/cs/miscctrl/[^][^]
Here u find the articles about ListView and ComboBox along with other controls.
Best Regards,
|
|
|
|
|
|
This is not answer but, this is what I have learned so far ( I'm still learning so don't take this as the end all answer in any way! )
Every control is a window.
suguimoto wrote: 2)
How can I enumarate all the controls in a window so that I can (for instance) press buttons, check radio buttons, read labels etc?!
So CallEnumChildWindows when you find the parent window. That will give you the handle you need. All controls are a window.
I have noticed that others say to use SendInput, while more say PostMessage. I like SendInput better, but it is was more complicated. You have to actually move the mouse around, send input, and other cool stuff. And, I'm still figuring it out.
If you use Spy++ you can locate your window in question and inspect what is there. Look for the item object name.
I have noticed that Tabs have a tab window with a panel.
I hope this has hepled you.
PS: TreeViews. I think you have to actually hook into thier callback functions to get the data. I tried a long time ago, and remember that since a treeview works on callbacks you have to do that. I could be wrong tho.
Nick
Nick
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Thankss!!!!
Best Regards!
|
|
|
|
|
hi,
i am using Data access layer to populate the datagrid where i made certain columns as hidden, by using datakey property of gridview i can access first column which is hidden please tell me how to access other hidden columns value
thank you in advance!
sunny
|
|
|
|
|
use
Gridview1.datakeys[0]["Datakeyname"].tostring();
thank you guys,
sunny
|
|
|
|
|
hi all,
i am binding a datasource (access database) to datagridview.
i have a column which holds some values. and want to add a new row which will have two columns namely 'total' <text> and 'totalvalue' <sum of="" all="" values="" above="">.
how can i do this ?
any suggestion ?
thanks in advance, bye.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
