|
Right, but since very few of my "ongoing operations" are void and parameterless, this is pretty useless. I'd instead create anonymous delegates (as shown above), which in fact do have to be cast to MethodInvoker 
-Domenic Denicola- [CPUA 0x1337]
“I was born human. But this was an accident of fate—a condition merely of time and place. I believe it's something we have the power to change…”
|
|
|
|
|
You don't have to cast to MethodInvoker provided you specify an anonymous method that is parameterless and doesn't return anything. For example,
Control.PerformOngoingOperation(delegate()
{
Library.Object.Method(5, true, "test");
}
That will work just fine, no cast required.
It should be noted that in the .NET framework class libraries, it's a common practice to accept a method that returns void but takes 1 parameter of type object in order to pass in state.
For example, see ThreadPool.QueueUserWorkItem(SendOrPostCallback method, object state);
cc
Where SendOrPostCallback is a delegate that takes 1 object parameter.
Another thing you can do here is provide generic overloads for your Control.PerformOngoingOperation:
object PerformOngoingOperation(Function method, out string id)
</code><code>object PerformOngoingOperation<TArg>(Function<TArg> method, out string id, TArg arg)
</code><code>object PerformOngoingOperation<TArg1, TArg2>(Function<TArg1, TArg2> method, out string id, TArg1 firstArg, TArg2 secondArg)
</code><code>object PerformOngoingOperation<TArg1, TArg2>(Function<TArg1, TArg2, TArg3> method, out string id, </code><code>TArg1 firstArg, TArg2 secondArg</code><code>, TArg3 secondArg) And so on, as many as you like.
This way, your PerformOngoingOperation method can execute most any function without having to use the Delegate class; everything will be strongly typed and performance will be great as no late-bound method invocations will occur.
|
|
|
|
|
Hi ,
I am trying to read an MS Excel file in my C# class. But problem is its not showing me the column values. I have checked in actual excel file , those columns do contain values but due to some reason my code is not reading it.
here is what i m doing :
Code Blockstring filename = "xmp.xls;";
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= " + filename + "Extended Properties=Excel 8.0;";
OleDbConnection ObjConn = new OleDbConnection(strConn);
ObjConn.Open();
object[] objArrRestrict;
objArrRestrict = new object[] {null, null, null, "TABLE"};
DataTable schemaTbl;
schemaTbl = ObjConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
Hashtable ht = new Hashtable();
int index = 0;
foreach (DataRow row in schemaTbl.Rows)
{
ht.Add( index, row["TABLEX] );
index++;
}
string sheetName = (string)ht[0];
OleDbCommand ObjCmd = new OleDbCommand( "SELECT * FROM [" + sheetName + "]", ObjConn);
OleDbDataAdapter objDA = new OleDbDataAdapter();
objDA.SelectCommand = ObjCmd;
objDA.Fill(recordsDT);
ObjConn.Close();
DataRow rowx= recordsDT.Rows[14];
// and now if i try to read value of 6th column
rowx[5].ToString(); // gives empty string
rowx["6th Col"].ToString(); // it returns me empty string and actually this column do contain value
and similary i can't get values of col 7,8 but I do get the values of Col 1-5 and after Col 9.
But if I try to same column values of row 1,2 it works fine. It starts to get funny after row no 7. ( each row contains 80 coumns)
Thanks
ZINK
|
|
|
|
|
Hi would appreciate if you helped me with this strange problem.
i´m trying to write text from my listview into a excel file but the problem is that i want to change cells, now its writing in the same cell.
for example:
a1 a2 a3 a4
subitem[0] subitem[1] subitem[2] subitem[3]
subitem[0] subitem[1] subitem[2] subitem[3]
tryade this:
using (StreamWriter sw = new StreamWriter((path3 + namn), true))
{
for (int listIndex = 0; listIndex < this.listView2.Items.Count; listIndex++)
{
sw.WriteLine(this.listView2.Items[listIndex].Text + this.listView2.Items[listIndex].SubItems[1].Text + this.listView2.Items[listIndex].SubItems[2].Text + this.listView2.Items[listIndex].SubItems[3].Text);
}
Process.Start(namn);
enyone with a good knowledge with this problem???
TNX!!;)
|
|
|
|
|
The code you have provided makes no sense.
Nothing in your code explicitly refers to Excel.
You write some text to a StreamWriter but then don't do anything with it.
You call Process.Start with a variable that you haven't defined. What are you trying to do here?
When you say you are trying to create an Excel file, do you actually mean a delimited text file?
Paul Marfleet
|
|
|
|
|
no.. i just givin my example of what i thought..
this code writes in a .xls file but in one cell. I want to change cells foreach subitems..
how do i do that
appreciate this.
Big tnx!
|
|
|
|
|
You haven't posted all your code. There are a number of variables that are not defined.
Post all of your code. I can't help you unless I can understand what you are doing.
Paul Marfleet
|
|
|
|
|
ok..
my code to send info from my listview to a .xls file look like this:
string[] lines3 = System.IO.File.ReadAllLines("datainställningar.txt");
string path3 = lines3[0];
string text = textBox1.Text;
string namn = text + ".xls";
if (MessageBox.Show("Vill du skapa diagramet " + text + "?", "Mitt jobb",
MessageBoxButtons.YesNo, MessageBoxIcon.Question)
== DialogResult.Yes)
{
using (StreamWriter sw = new StreamWriter(path3 + namn))
{
for (int listIndex = 0; listIndex < this.listView2.Items.Count; listIndex++)
{
sw.WriteLine(this.listView2.Items[listIndex].Text + this.listView2.Items[listIndex].SubItems[1].Text + this.listView2.Items[listIndex].SubItems[2].Text + this.listView2.Items[listIndex].SubItems[3].Text);
}
Process.Start(namn);
}
}
But now it´s writes in only a1 cells in .xls, but i want it to write every subitems in each cell.
is it more clearly now??
tnx
|
|
|
|
|
AFAIK, there are 2 ways to create an Excel file in .NET.
1. Excel Automation. Allows you to programmatically control the Excel application. Requies Excel to be installed on the machine your application is running on.
2. JET OLEDB Provider. Allows you to connect to an Excel spreadsheet like a database and read/write data to it. Doesn't require Excel to be installed, only the JET driver.
Google either of these and you should find numerous examples to get you started.
Paul Marfleet
|
|
|
|
|
Here is another method for generating Excel file from c# http://www.codeproject.com/dotnet/ExportToExcel.asp
|
|
|
|
|
This code will nevcer generate a REAL .xls file. You can generate a text .CSV (comma seperated values) file that Excel will import but it's not an .xls file.
|
|
|
|
|
I am not sure why MS decided to make CSV able to be imported into Excel by default. Quite a lot of people I know now, think that anything .CSV is an Excel file. 
|
|
|
|
|
darkelv wrote: I am not sure why MS decided to make CSV able to be imported into Excel by default
Because it was too bloody easy?? 
darkelv wrote: Quite a lot of people I know now, think that anything .CSV is an Excel file.
That shows you how much they really know about Excel and CSV files. Pretty much nothing, right?
|
|
|
|
|
Hi,
I would like to know how I can create a .csv file with today's date and a variable name.
I have the following:
int day = date.Day;
int month= date.Month;
int year= date.Year;
string str="hi";
int res="123";
Now I want to create a .csv file with the following name : 13102007_hi_123
I though of putting everything into a single string (lets' say, result) but then, how will the following code replace result with the string!? At present it creates a .csv file with the name of result
if (!File.Exists("c:\\code\\result.txt"))
{
File.Create("c:\\code\\result.txt");
}
Any help will be greatly appreciated...Cheers!
ALSO, can I add a heather that will be ignored by excel?
|
|
|
|
|
Separating the date into it's components isn't very useful. It's much easier to just format the date the way that you want: date.ToString("ddMMyyyy").
If you don't know how to concatenate strings and use variables instead of literal string values, you really need to pick up a beginners book and gets some basics down.
---
single minded; short sighted; long gone;
|
|
|
|
|
...I know how to concatenate strings! the problem is how I then refer to that "variable" when creating the .csv
|
|
|
|
|
...In case it is not clear...
int day = date.Day;
int month= date.Month;
int year= date.Year;
string str="hi";
int res="123";
string fileName = day + month + year + "_" + str + "_" + res
However, if I do : File.Create("c:\\code\\fileName.txt"), it creates a file with the name "fileName"...rather than the value of fileName
...any ideas?
|
|
|
|
|
Have you heard of string.Format()? Surely you must have seen it in the intellisence and wondered if it might be useful.
mocasu wrote: File.Create("c:\\code\\fileName.txt"), it creates a file with the name "fileName"...rather than the value of fileName
Have you thought of also concatenating the file path into the string too?
|
|
|
|
|
...what can I say...thanks both of you for being so ...
|
|
|
|
|
mocasu wrote: ...what can I say...thanks both of you for being so ...
"Sarcastic"? (That's the normal accusation) ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
...if that's what you think you were being...Not everybody thinks the same...All of us can finish it with something different, it is just a matter of judgement
|
|
|
|
|
mocasu wrote: ...if that's what you think you were being...
I didn't say that I thought it. I said it was what I (we) are normally accused of. 
|
|
|
|
|
go like this:
File.Create("c:\\code\\" + filename + ".txt");
It's one of those obvious things that you can't see...like having to look a little right or left to see a dim star.
Dave
|
|
|
|
|
Thanks a lot David! really appreciate...that is what i was looking for.
-- modified at 11:39 Saturday 13th October, 2007
|
|
|
|
|
You're welcome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
