esProc can solve this problem easily. It is just like Excel+SQL, a free tool, see: A Query Language Over-perform SQL [^]. code as below: A1: =sqlsvr.query("select Name,Dates,[Outstanding Values] from test_table order by Name,Dates") A2: =A1.derive(:Difference) A3: =A2.group(Name) A4: =A3.(~.run(Difference='Outstanding Values'-'Outstanding Values'[-1])) I can't post a image file,so here are some explains: A1 cell:query some data from database. A2 cell:add a column to A1, named "Difference", just no data. A3 cell:group the data by field "Name" in A2 cell. Here are 3 groups, A4 cell:within every group(i.e. "~"), modify the field "Difference". The algorithm is: "this row" subtract "last row"(i.e. 'Outstanding Values'[-1]) I think esProc is more simple for mass data computation BTW. how to post a image file?

If the method takes a URL, then it must provide a URL class, unless it just takes it as a URI or a string. What do the docs say ? Are there samples ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

you can also use Profiling if you dont want to use session Regards, Usman Munier Xavor Corporation Pakistan

you can access parent control but this is not proper way instead you can create properties in user control those required Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

Start here http://msdn2.microsoft.com/en-us/library/system.web.ui.page_events(vs.80).aspx[^] only two letters away from being an asset

aakar wrote: I am automating MS Word using VB .Net . What I want is that I want some text to be inserted on the word document that I have opened. Once I have done this when my mouse moves above this line of text, the cursor should change to hand cursor and the text should behave like a hyperlink i.e. when that text is clicked, it should take the user to some other location. Try to check this resource[^] and look at the final section that import data from ms access to word. This might give you some idea to insert your own data.

For my money, SQL-DMO is the way to go. It allows you to stay within the confines of the application and is just a cleaner implementation (IMHO!) I attempted to invoke sqlo from within C# and it did work, but catching any exceptions was a bit awkward. /dave ---- If you always do what you always done, you'll always get what you've always got - Anonymous

System.Windows.Forms.Application.Exit(); does not get executed because your program is running an open window on a thread. It will never reach System.Windows.Forms.Application.Exit(); because when you close the window Dispose would have been called already. Can i ask why you are using a window? If it is to run a scheduled task why not just create a Console Application, this will exit once it has finished executing. If you have the window so you can enter data about what it is you want to run, why not just add switches to execution of your console application like Start -> Run 'myapp.exe "path to filename" "time to start"' Like this: http://www.codeproject.com/csharp/deleteold.asp?df=100&forumid=152583&exp=0&select=1169916[^] Darren

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