I want to know do you have control over other database, I mean lets assume that DB1 is where you are uploading excel data, and post the these details to DB2. So if you have access to that DB then I would suggest right CLR enabled SP which will run at MS SQL server level rather calling it via web application which is very very slow. So to improve the performance you can divide the task and process it in separate places. Let me know if you need any further details on the above design. Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com My Blog Suggestions for me

thanks a lot... Deepak :) Smile a Lots,Its Costs Nothing

As you said that your widows services is processing the data.After processing it you can put it in some kind of temporary database,and Monitor the DB from your webservice and show it on your webapplications or you can put some async call which will access the DB and show data on your webpage. Windows service should always be running on the system and process the data when gets some data. Deepak the Cool wrote: Is it possible to run the windows service through the web application button click event NO Cheers!! Brij Check My Latest Article

Is the .OCX registered on the machine?? You really can't have a COM component without at least an empty constructor, so I question the error you got. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

in web service u can use DynamicContextKey. and in autocomplete generally textbox's text is used for filtering.

Hi I do had problems with ExecuteScalar, So I suggest you just replace it with ExecuteReader and read value using DataReaderInstance(0) in vb.net DataReaderInstance[0] in C#. Or if you are using .Net 3.5 version use LINQ to read data from database instead. Hope this will solve your problem. Gaurav Mahajan [website www.sushilindia.com], Amritsar Website Developer and Computer Lecturer.

Deepak the Cool wrote: it is not possible to create the webservice object and call it into the static function because static call only static class and method Not true. Static methods can call non-static methods if it has a reference to the non-static object. Deepak the Cool wrote: Can I create an object as static as the point of oops or this is good for the project. Not sure what you mean by that. You can create a static reference to an object if you need it. However, be aware that the object will be around for the life of the application until you set the reference to null even if nothing else references it. Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog

Hi Everyone, I got the answer and I post it here for the help of other programmer.... <pages enableEventValidation="false" viewStateEncryptionMode ="Never" /> Deepak :) Smile a Lots,Its Costs Nothing

I know very well what is here? If you hav a proper Solutions then give it Otherwise dont give the reply that type of message..... Hope u'll understand better..... Thanks And Regards Deepak :) Smile a Lots,Its Costs Nothing

I used this buddy But my strFiledata still giving me ASCII characters Thanks Deepak :) Smile a Lots,Its Costs Nothing

You might want to put the whole error message in a google search and see what comes up. "I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

No there is not that type of message it is showing me a yellow page for configuration error I add reference from com component for crystal reports the following are the elements of my web.config... and i am using followin DLL for Excel Interop.Excel.dll Interop.Microsoft.Office.Core.dll Interop.VBIDE.dll stdole.dll can u help me for that particular u can check my page by http://test.paymentsindia.com/ Deepak :) Smile a Lots,Its Costs Nothing

Deepak the Cool wrote: now i want to that when i put the search string into web user control's text box and click the search button in web page it will fill a data table according to search string. In button click redirect to a search page with the criteria passed as querystring. In search page get the search criteria, fill the datatable and show it. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions