|
mrithula8 wrote: private void InitializeComponent() { button1.Click += new EventHandler(button1_Click); // list.ItemActivate += new EventHandler(list_ItemActivate); }
If you remove the above then you should be OK. In Visual Studio the components are initialized in the FORM1.Designer.cs file.
Hope this helps.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
try this
public Form1()
{
InitializeComponent1();
CreateHeadersAndFillListView();
String sss;
PaintListView(sss);
}
private void InitializeComponent1()
{
button1.Click += new EventHandler(button1_Click);
}
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi Guys. I have a working Excel application that reads an input file and writes the data to an Excel sheet. Now, I need to do a few more things though but just can't seem to get it working properly. This is what I need to do and what I have so far.
I need to set the current cell color to red if the Recon Indicator is NN but it sets all the cells before the current cell to RED. My question is how do I select only the current Cell. I have tried numerous things but it doesn't work.
if (RECONCILIATIONIND == "N")
{
objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
objRange = objSheet.Cells.Rows.EntireRow;
objRange.Font.ColorIndex = "3";
}
The next problem I have is that I need to do some calculation on an unknown number of cells and subtract it from a total in a different column. Below is a sample screen.
Nominees & Own Name (Level 1) Beneficiaries (Level 2)
19326421
175
84
76
2238
235
14
591
345
122
240
346
From the above, I need to calculate the totals in Beneficiary (level 2) and subtract that from Level 1 total and add the total into a new column. Now, there is an undertermined number of values in Level 2 i.e. there could be 2 or 4 or 50 or 300 values to add. How would I be able to do that?
Any help or advise would be appreciated.
Excellence is doing ordinary things extraordinarily well.
Excellence is doing ordinary things extraordinarily well.
modified on Tuesday, March 10, 2009 4:03 AM
|
|
|
|
|
Kwagga wrote: objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
try modifying this to select 1 cell and then set the colour. You are setting the colour for the range not the cell.
This entire excercise is based on traversing row/column sets and identifying the values for a cell. Should be able to acheive it with a Do While loop.
Changing the format made a difference huh! Don't be rude next time.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I don't think that I was being rude. Although the pre tag was incorrectly placed it was still readable. Anyway, thanks for the help. What I have resorted to doing was instead search the sheet for value and then mark it in a different color. However, it only finds the first instance and then stops. How can I get it to search for the next instance? Below the code I have put together. A bit rough though.
Excel.Range currentFind = (Excel.Range)objSheet.Columns["S", Type.Missing];
Excel.Range firstFind = null;
currentFind = currentFind.Find("N", Type.Missing, Excel.XlFindLookIn.xlValues,
Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext,
true, Type.Missing);
while (currentFind != null)
{
if (firstFind == null)
{
firstFind = currentFind;
}
else if (currentFind.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1,
Type.Missing,
Type.Missing) == firstFind.get_Address(Type.Missing, Type.Missing,
Excel.XlReferenceStyle.xlA1,
Type.Missing, Type.Missing))
{
break;
}
currentFind.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
currentFind = currentFind.FindNext(currentFind);
}
Any advice on the other Issue I mentioned?
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
how to get the control of the shape residing in the active cell of my sheet?
I mean to say, is there a way i can say:
Excel.Shape sh = MyApplication.ActiveCell.get_Shape(); or something like that so that I get the shape's control and further I can use it.
Regards
|
|
|
|
|
hi guys, this is my first post in CodeProject.
i want to send an email from my c# code but at a specific time.
would any one please help me.
i have exchange server in my office and i am able to send email immediately using System.Net.Mail.SmtpClient class but can't send it at a specific time.
thanks
|
|
|
|
|
Ramin RamZ wrote: this is my first post in CodeProject.
That I'm afraid is obvious from the content of the post. This question has been asked sooo many times it is ridiculious, try searching either CP or Google. You will find many examples to work with.
Good luck.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have already searched google but didn't solve my problem.
because i dont want to put it in a queue and set a timer to look at the queue after a specific time.
the problem is that the computer sending the mail might be off on that time, what i want is to send the mail even if the computer goes off.
|
|
|
|
|
Schedule the mail sending application using windows scheduler.
Ramin RamZ wrote: the problem is that the computer sending the mail might be off on that time, what i want is to send the mail even if the computer goes off.
|
|
|
|
|
thanks navaneeth for the reply.
but if the computer goes off then how the scheduler would be able to run.
|
|
|
|
|
Ramin RamZ wrote: what i want is to send the mail even if the computer goes off.
Wow. You ARE dumb. How can your PC send mail, if it is off ? It can't.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
nothing is impossible in the world of programming.
if i send e-mail to someone and if i am able to delay it from the server then for sure it is possible. It is possible through server based not client based i know this, but i dont know how to delay it from the SMTP server.
|
|
|
|
|
Ramin RamZ wrote: if i send e-mail to someone and if i am able to delay it from the server then for sure it is possible.
Sure, on an Exchange server, it's possible. But, on a normal SMTP server, there is no facility to support this.
|
|
|
|
|
You send email using the SMTP protocol which is donkey's years old. There is no facility in this protocol to time the sending of mail, you send it to your server, it forwards it on to the next and so on until it gets recieved by the recipient.
The only way email gets delayed is if a server is out of action. Normally when this happens, the previous server in the chain will attempt to resend it at intervals. The sender will normally get information emails saying that it's having difficulty contacting the (maybe redirection) server. Usually after about 48 hours it gives up and returns your mail.
The only way you can do what you're tring to do is by actually doing the send at a later time. If you're SMTP server or the sending computer is turned off then you are stuck and that's the bottom line.
As others suggest either the Windows Scheduler or your own rolled solution are the only options you have. Sorry.
Regards,
Rob Philpott.
|
|
|
|
|
|
Sorry Ramin my mistake - missed the word "delay" in your title
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Hi Guys. I have a working Excel application that reads an input file and writes the data to an Excel sheet. Now, I need to do a few more things though but just can't seem to get it working properly. This is what I need to do and what I have so far.
I need to set the current cell color to red if the Recon Indicator is NN but it sets all the cells before the current cell to RED. My question is how do I select only the current Cell. I have tried numerous things but it doesn't work.
if (RECONCILIATIONIND == "N")
{
objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
objRange = objSheet.Cells.Rows.EntireRow;
objRange.Font.ColorIndex = "3";
}
>/pre>
The next problem I have is that I need to do some calculation on an unknown number of cells and subtract it from a total in a different column. Below is a sample screen.
<code>
Nominees & Own Name (Level 1) Beneficiaries (Level 2)
19326421
175
84
76
2238
235
14
591
345
122
</code>
From the above, I need to calculate the totals in Beneficiary (level 2) and subtract that from Level 1 total and add the total into a new column. Now, there is an undertermined number of values in Level 2 i.e. there could be 2 or 4 or 50 or 300 values to add. How would I be able to do that?
Any help or advise would be appreciated.
<div class="ForumSig">Excellence is doing ordinary things extraordinarily well.</div>
|
|
|
|
|
I suggest you reformat the question to include ONLY code in the code block - this is unreadable.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All!
I have a Form simulating an OpenFileDialog which has a ContextMenuStrip with some items including: Copy, Paste, Delete and so on with shortcut keys: Ctrl+ C, Ctrl + V and Del.
The problem is this: when I lunch the form, Del shortcut works fine (but Ctrl+V ant Ctrl+C don work unless I show the context menu by right clicking)! if I do a Copy/Paste the Del shortcut does not work any more until the next time I right click on the form and showing the context menu  . this problem is only by shortcuts, context menu items work fine by themselves.
any suggestion would be greatly appritiated.
|
|
|
|
|
I am assuming that the form is getting the keypress events instead of the context menu. If you think about the way a menu works IE press alt F to activate the file menu item then it makes sense that a context menu will not be operated directly from the form.
Why Del work, I have no idea. If you trap the keypress on the form you may be able to activate the context menu.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
Here is my code...
string sPath = Server.MapPath("~/sms/sms.xls");
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sPath;Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
From the above code, connection string was working and connection is opening fine, than its throwing the error messg like
"The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly."
But sms.xls file having the name of sheet1 and which resides inside the sms folder... than to y this message appearing....
Pls help me....for the past 2 days iam sike of this problem
krishna
|
|
|
|
|
never having used a connection to XL but I would check that the sheet1$ is the same as naming a sheet sheet1, the $ may signify the system default name rather than a user defined name.
Try naming the sheet differently.
Also make sure the sheet layout conforms to DATABASE layout structure, no stray bits in the top rows!
Personally I would open the sheet and interate the rows and cells rather than rely on the OLEDB connection.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The excel's sheet have some sheet name, Sheet1$ on of this,but application read excel, if you excel file sheet name not call Sheet1$, it's will error, So, You'll using sheet of Excel file, the code for sheet[0],it's mean frist sheet name,Sheet[1] is second sheet name.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
