C# Discussion Boards - CodeProject

18-Sep-08 0:38

You could use a Fraction/Rational number class or find the GCD of all the numbers, multiply them by the GCD, sum them all, then divide by the GCD.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Guffa18-Sep-08 1:31

Guffa

18-Sep-08 1:31

You can get much better than an approximation, you can get the exact value.

The sum of (1/2 + 1/4 + 1/8 + ... + 1/n) is (1 - 1/n).

Despite everything, the person most likely to be fooling you next is yourself.

Angelinna18-Sep-08 1:37

Angelinna

18-Sep-08 1:37

Would this operate as a recursive function? If not, how best can one
implement the summation recursively.

Guffa18-Sep-08 2:24

Guffa

18-Sep-08 2:24

Why would you do that as a recursive function? It's a very simple calculation. There is no looping required of any kind.

Despite everything, the person most likely to be fooling you next is yourself.

Pete O'Hanlon18-Sep-08 3:53

Pete O'Hanlon

18-Sep-08 3:53

Good point. I should have thought of that. D'Oh! | :doh:

I've been out of school way too long.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Alan Balkany18-Sep-08 4:21

Alan Balkany

18-Sep-08 4:21

You don't need any loop or recursion. Here's the formula: http://www.ies.co.jp/math/java/misc/sum/sum.html[^]. The formula is at the end of the page; 'a' is the first number in the series, and 'r' is the ratio between consecutive terms.

Using Microsoft.Office.Interop.Excell.dll to modify .xls file

Angelinna18-Sep-08 4:44

Angelinna

18-Sep-08 4:44

Thanks all for your guidance. I am trying to have it all programmed in c#.

mcnam17-Sep-08 23:26

mcnam

17-Sep-08 23:26

Hi everybody,
I uses Interop.Excell.dll to modify excel file then it worked fine if I chosen the computer's region was English. But the problem happened when i changed to another different with English; Some of function could not work. For Example :
I used this function to change the condition of cellItem
cellitem.FormatConditions[1].Modify(XlFormatConditionType.xlExpression, XlFormatConditionOperator.xlEqual, "=AND($X$" + position + ">2,MOD($X$" + position + ",2)=0)", "");
-With the region is English it still ok.
-With the region is Germany I had error exception:
{"The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))"}
OS: Window XP professional.
I think that:"The reason is some functions of that dll can not work with the difference formats(currency, datetime, number...) doesn't like English format." I try to find the correct dll using in Germany location but untill now I do not find out it or find out another solution.
Have anyone ever done in this situation and solved it! Please help me.
Thanks,

varchar(max) vs varchar(50)

Mogaambo17-Sep-08 23:03

Mogaambo

17-Sep-08 23:03

if i use varchar(max) instead of varchar(50), and use "chandra" only , then will both give the same performance.

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

leppie17-Sep-08 23:08

17-Sep-08 23:08

Mogaambo wrote:
then will both give the same performance.

Same performance of what? Actually what is this doing in the C# forum? It should be in SQL...

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Mogaambo17-Sep-08 23:26

Mogaambo

17-Sep-08 23:26

i am creating tables on runtime, after reading from a text file but i don't know the datatype size, so if i use varchar(max) will that okay.

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

leppie17-Sep-08 23:42

17-Sep-08 23:42

Again, please use the SQL forum, NOT C#!!

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

How to show event of a user control in property window

Pete O'Hanlon18-Sep-08 0:30

Pete O'Hanlon

18-Sep-08 0:30

It won't make any significant difference to the performance of your C# code.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Guru Call17-Sep-08 22:50

Guru Call

17-Sep-08 22:50

Hi,

I made a custom control inherited from 'Button' control.

I made a custom event 'Action' in this userControl I made a access specifier 'public'.

like this :

public delegate void ActionEventHandler(object sender,ActionEventArgs e);

public event ActionEventHandler Action;

protected void OnAction( object sender, ActionEventArgs e)
{
if ( Action != null)
{
Action(sender,e);
}
}

but when I drop this control to a form it doesn't show 'Action' event
in property window.

plz help how to do this...

Re: How to show event of a user control in property window

Simon P Stevens17-Sep-08 23:30

Simon P Stevens

17-Sep-08 23:30

Add the BrowsableAttribute[^] to the event.

Simon

Trouble with Invocation, serial port

introuble217-Sep-08 22:41

17-Sep-08 22:41

Ok, i am still having some trouble with the code. I have a controller on the other side with a thermometer and keyboard etc.
I am sending the temperature from there to my form. It normally works fine.

The only time it gives me an error is when the first thing i do (after turning on the controller) is click "show temperature" on my screen form. Then the error that occours is the following:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created.

It also says:
TargetInvocationException was unhandled.
Exception has been thrown by the target of an invocation.

Could it be that the forst time data is in some kind of wrong format? How to make sure that the window handle will be created before BeginInvoke?

Sample code: namespace WindowsFormsApplication1
{

public partial class Form1 : Form
{

int ledStatus = 0;
int r = 2;
System.IO.Ports.SerialPort sp = new System.IO.Ports.SerialPort();

public Form1()
{
InitializeComponent();
sp.PortName = "COM5";
sp.BaudRate = 19200;
sp.Parity = Parity.None;
sp.DataBits = 8;
sp.StopBits = StopBits.One;
sp.ReadTimeout = 5000;
sp.Open();
sp.DataReceived += new SerialDataReceivedEventHandler(sp_DataReceived);
}

void sp_DataReceived(object sender, SerialDataReceivedEventArgs e)
{
this.BeginInvoke(new Action(UpdateData), sp.ReadExisting());
}

public void UpdateData(string character)
{
if (r == 1)
{
string ajutine2 = "0";

ajutine2 += character;

int stringToInt = Convert.ToInt32(ajutine2);
for (int y = 0; y < 1000; y++) ;
if (stringToInt > 100)
progressBar1.Value = stringToInt;

double intToDouble = Convert.ToDouble(stringToInt);
double ajutine3 = intToDouble / 10;

string doubleToString = Convert.ToString(ajutine3);

ekraan1.Text = "";
ekraan1.Text += "Temp: ";
ekraan1.Text += doubleToString;
ekraan1.Text += " *C";

}
else if (r == 2)
{
for (int y = 0; y == 5000; y++) ;
ekraan1.Text += character;
}

}

... }

leppie17-Sep-08 22:51

17-Sep-08 22:51

introuble2 wrote:
It also says:
TargetInvocationException was unhandled.
Exception has been thrown by the target of an invocation.

Look at the Inner or base exception causing this on this TargetInvocationException.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

introuble218-Sep-08 0:31

18-Sep-08 0:31

Do you mean this:

public void showTEMP_Click(object sender, EventArgs e)
{
r = 1;
sp.Write("X");
ekraan1.Text = "";
}

The controller reacts to the "X" and starts the temp conversion and send.

leppie18-Sep-08 0:35

18-Sep-08 0:35

introuble2 wrote:
Do you mean this:

No I dont mean any of that. I never even mentioned anything you wrote! How did you get that?

I mean do:

try
{
  //do the code that causes the TargetInvocationException 
}
catch (TargetInvocationException ex)
{
  Exception realex = ex.GetBaseException();
}

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

introuble218-Sep-08 1:49

18-Sep-08 1:49

I am just beginning with C# and its a tad confusing at the moment.
Anyways, i tried what you said and now it just wont run. It doesnt even print any errors.

However, if i select "start without debugging" i get some information:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at WindowsFormsApplication1.Form1.UpdateData(String character) in C:\Users\raigo\Desktop\Kit Programmid\VISUAL\KIT\KIT\Form1.cs:line 62

Any ideas?
Thanks for any ideas Smile | :)

leppie18-Sep-08 3:14

18-Sep-08 3:14

introuble2 wrote:
Any ideas?

introuble2 wrote:
Form1.cs:line 62

Look there. Specifically at what is being passed when calling int.Parse().

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Alan N18-Sep-08 1:46

Alan N

18-Sep-08 1:46

Hi,
I think the problem is that your are opening your serial port before the form has been created.

Move the following code into the forms Load event handler and I think you'll be ok.

sp = new System.IO.Ports.SerialPort();
sp.PortName = "COM5";
sp.BaudRate = 19200;
sp.Parity = Parity.None;
sp.DataBits = 8;
sp.StopBits = StopBits.One;
sp.ReadTimeout = 5000;
sp.Open();
sp.DataReceived += new SerialDataReceivedEventHandler(sp_DataReceived);

Alan.

introuble218-Sep-08 2:07