Hey, How many records do you have in your excel file? Are they too much, I mean System.OutOfMemoryException hits when there is not much memory left for the application? have a look at your excel and see whether you can optimize it.. -Anurag

Its basic maths buddy.. :) Let me try to write a simple app for you. Distance between points (5,5) and the origin (0,0) should be: public CalculateDistance() { double D; int x1=5; int x2=0; int y1=5; int y2=0; D=Math.Abs(((x1-x2)^2)+((y1-y2)^2))^(1/2); Console.WriteLine(D); Console.ReadKey(); } The above should do good. -Anurag

Feels like you need to find out the distance between 2 points on a 2D plane. Point A (x1,y1) Point B (x2,y2) Distance between them would be=[((x1-x2)^2)+((y1-y2)^2)]^(1/2) Use Math.Abs method to get the absolute value of the distance regardless of x1>x2 or x1

try Session.RemoveAll();

What do you mean by online in MacBook and offline in desktop? there are 2 kinda apps: Desktop apps and Web apps... Both are pretty different.. Can you first decide what kinda app you wana do?

hey..u cn use iframe tags in your aspx page and try to play a youtube vid..smthing like below: have a try.. regards

select COUNT(Category_name) from TableName where Category_name like '%SearchPrefix%'

Thank you.. My article got 7th place...:) regards anurag

It shows only the winners... Any other link where we could see the final standings?

Hello People, Well this query might be a little weird, but how to know who won the monthly competitions held over here at CP. My article was in bid for the Best Web Dev article, for which voting ended on 19th April. I am pretty sure my article wouldn't have won..:) But trying to find out as to what position it eventually landed at?? If this is not the correct forum to post this kind of query, please advise accordingly. regards Anurag

hi, every single information is available on developer.android.com you can refer to it quite easily.

cheers

hi all..have found the solution to the problem above posted by me..thxx evryone fr their suggestions..will post the answer sometime...

thanks a lot everybody for the responses.. will do evrything what is required to crack it...

hi Richard..thxx for the suggestion..i did try Math.Abs stuff but still not getting the desired result... The conversion into months in negative scenario is what I am not getting.. Further assistance would be highly appreciated..

Regards Anurag

Hi all, AM working on a C# project.. my requirement is as follows: there are 2 dates viz date1 & date2. if date1 > date2 the difference should come as e.g (3years,2months) if date1 < date2 the difference should come as e.g (-3years,-2months) I am able to get the first scenario but the second scenario I am having problems with, not able to calculate the number of months in negative quite correctly... Below is the code used in case of positive scenario,currentdate is alwys greater than the assetCapDate passed as a value: public string newmethod(string assetCapDate) { string timeStr = string.Empty; int years = 0; int months = 0; int days = 0; TimeSpan ts = new TimeSpan(); System.DateTime date1 = DateTime.Now; System.DateTime date2 = Convert.ToDateTime(assetCapDate); ts = date1.Subtract(date2); years = (ts.Days/365); do { for(int i=0; i <= 12; i++) { if(date1.Subtract(date2.AddYears(years).AddMonths(i)).Days >=0) { months = i; } else { break; } } if(months > 12) years = years + 1; }while(months > 12); days = date1.Subtract(date2.AddYears(years).AddMonths(months)).Days; if (years > 0) { timeStr += years.ToString() + " Years, "; } if (months > 0) { timeStr += months.ToString() + " Months"; } if (days > 0) { timeStr += days.ToString() + " Days"; } return(timeStr); } Any help would be highly appreciated. I am not sure whether this question falls under C# domain..Moderators please advise accordingly..will move this question to another domain if required.

Regards Anurag

Have moved this question to the Javascript section....

Hi All, Have a code which sends an Outlook mail using Javascript by creating an instance of ActiveX object. I need the functionality to be such, when the user executes this code his default signature should also be added in the mail...Have tried it but to no avail..Any help would be highly appreciated... The code goes as follows for the reference:

function mailWindowOpen(mailBody) {
outlookApp = new ActiveXObject("Outlook.Application");
var nameSpace = outlookApp.getNameSpace("MAPI");
mailFolder = nameSpace.getDefaultFolder(6);
mailItem = mailFolder.Items.add('IPM.Note.FormA');
mailItem.Subject = "Hi There!!!";
mailItem.HTMLBody = mailBody;

 mailItem.display(0);

}

mailBody is passed as a parameter from an aspx page, which has the Page.ClientScript.RegisterStartScript command to call this Javascript function...

-Anurag

Is it the correct domain or should I post this question in Javascript section??? Moderators please advise...

Hi All, Have a code which sends an Outlook mail using Javascript by creating an instance of ActiveX object. I need the functionality to be such, when the user executes this code his default signature should also be added in the mail...Have tried it but to no avail..Any help would be highly appreciated... The code goes as follows for the reference:

function mailWindowOpen(mailBody) {
outlookApp = new ActiveXObject("Outlook.Application");
var nameSpace = outlookApp.getNameSpace("MAPI");
mailFolder = nameSpace.getDefaultFolder(6);
mailItem = mailFolder.Items.add('IPM.Note.FormA');
mailItem.Subject = "Hi There!!!";
mailItem.HTMLBody = mailBody;

 mailItem.display(0);

}

mailBody is passed as a parameter from an aspx page, which has the Page.ClientScript.RegisterStartScript command to call this Javascript function...

-Anurag A curious newbie

hii..got around the problem by upgrading the .net framework 3.5 to SP1..now i am able to drag and drop other controls...however, a new problem persists..I am not able to customize the toolbox though..i right clicked on the toolbox area and clicked on choose items..then a dialog box appears with various menus..clicked on 'WPF components'..chose the controls which i needed and then clicked on OK..but to my surprise the controls were not added...tried it again 2-3 times but to no success..restarted VS again and repeated the whole procedure but couldn't do it...Please help..

Anurag A curious newbie