|
Hi All,
I am facing one problem,tht is I upload an excel file with 65,000 of rows.So the task is tht First I hav to insert these rows into my DB is it ok I had done it and the whole execution done within 10 secs.
Second task is tht,I hav to post tht data into a another site through HTTP POST method tht is ok for me ,But the main problem is tht, I hav to post only the 500 number of rows into a single execution.So the sceniro is tht 65000/500 the total number of execution.
So i want to run tht execution fastly,Coz if I run traditionl method then my posting page has expird or connection forcily closed.
So is it possible I have to save that file into a particular laocation and when tht file will be posting into lacation then an automtic service run at background and tht will done all work.I am not talking about the windows scheduling.It is might be a windows service but I want to initate when my file will be save on a particular laocation.
If anybody can help me for the same then please help me.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Your best bet IMO is to have a webservice at the other end and to do multiple calls that send the data a bit at a time. A windows service could handle this on the server and the ASP.NET page could simply tell it to start work, then return a page to the client.
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.
|
|
|
|
|
Hi Crisitan,
Thanks for ur help.Can u discribe it more.And how can I initate a windows service through asp.net page.Please tell me or if any link for tht particular tutorial then give me.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Well, I am assuming you have control over the whole process. I'm not sure exactly how an ASP.NET process would kick off a service, I've done it, but it was a long time ago. The core thing is, do you have control over the end that is recieving the Excel data, to replace your HTTP Post code with a web service ? If not, a windows service could still do the post without holding up a web page lifecycle, but you wouldn't be able to fully take my advice in that case.
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.
|
|
|
|
|
Crisitan My sceniro is this suppose
i hav 65,000 number of rows.Now I uplaod the file and click the send button.then I create the insert command for tht to DB.Now I hav a web service instance which is get the data from DB and post it a another site page by the size of 500 number of rows.So my web service work on tht and it will a slow proceess to sent the data meanwile my web page expird after 20,000 number of rows post on the another server.coz it has several simeltenous task to work e.g. inventory management,retrun response to insert the data.
so i want to do only data insertion into my web page after that a background process will be done it.if i create windows scervice for tht then the schedule will be run after a schedule time.But I want to run it at the time of posting the data.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Your design is confusing. Here is my suggestion though.
Don't call web service from your ASP.NET application as it is taking long time. Delegate this task to the background service. You may need to create a database table in which all the records that has to be processed should reside. Your ASP.NET application has to insert rows into this table and background service should poll this table regularly. Get the data from this table and call required webservice.
Best wishes,
Navaneeth
|
|
|
|
|
Boss How do I call the service through windows service.If yes the it has some time of interval to run for.But i want run it to current task.if i set the interval at least then procees execution time will be more then the time callback time.if I set it 5 to 10 minutes of timer then user is not ready to accept to much time to show the response.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Windows services are expected to run all the time. So there won't be any scheduling. You run each web service call on a separate thread and keep the other thread polling the table. So you don't find any delays in the processing.
Best wishes,
Navaneeth
|
|
|
|
|
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.
|
|
|
|
|
hi
i am developing a webapplication which is local to my system
when im running the application it is showing that it is executing from
http://localhost:1234/webapplication1
where as my webapplication is in drive D
i know that when a page is requested for first time
the asp.net engine compiles it and converts it to a dll
and for next request the same dll is used
i didnt added the bin folder to my webapplication
now what is the problem is
i changed the code and when i run the application it is showing the old result.
can any give the path for deleting the dll
i m using asp.net 2.0, where i could not find Inetpub/wwwroot
to solve this i uninstalled the .net and reinstalled it but even it is not solved.
|
|
|
|
|
vijaylumar wrote: to solve this i uninstalled the .net and reinstalled it
You have problems in understanding how a file-system website works. Visual Studio 2005 onwards, an inbuilt ASP.NET development server is supplied and used when you create a file system website. If you change the code and do a refresh, you should see the latest updates. In worst case, you may need to stop the ASP.NET development server and start it again. You never need to reinstall .NET framework.
Give us more information about what steps can reproduce your problem so that some one can come up with a solution.
vijaylumar wrote: i m using asp.net 2.0, where i could not find Inetpub/wwwroot
So don't you have IIS installed?
Best wishes,
Navaneeth
|
|
|
|
|
hi
thanks for your reply
where could i find ASP.NET Development Server
|
|
|
|
|
ASP.NET Development Server is inbuilt server launched from Visual Studio, now if you want to publish this web site follow steps mentioned in this link
|
|
|
|
|
hi
i want to restart the ASP.NET Development Server
|
|
|
|
|
When you launch the web site from VS, you will see development server in task bar. That will have options of stop.
Stop the execution of web site from VS and it will stop the development server and relaunch it again. this will take care of restart of development server.
|
|
|
|
|
hi
i got the error like this
BC30456: 'CreateResourceBasedLiteralControl' is not a member of 'ASP.masterpage_master'
do u have any idea about this
|
|
|
|
|
This error is code specific, can you share the code so that I can look into it and let you know what could be the error.
Thanks
|
|
|
|
|
hi
this is the code in MasterPage
in source
<%@ Master Language="VB" AutoEventWireup="false" CodeFile="MasterPagePos.master.vb" Inherits="MasterPagePos">
'in code File
Public Class MasterPagePos
Inherits System.Web.UI.MasterPage
End Class
|
|
|
|
|
I need entire code since what you are talking about is code related error.
|
|
|
|
|
hi
actually i got the error like this
BC30456: 'CreateResourceBasedLiteralControl' is not a member of 'ASP.masterpage_master'
do u have any idea about this
|
|
|
|
|
I have a Web App project with a few Page items, as well as a UserControl item. I would like to use this UserControl within the Pages, but I can't seem to add it to the Toolbox. When I do a drag-drop, I get a Text element, which is just the filename of the UserControl.
Am I going about this the correct way? Should I instead set up the UserControl as totally separate project and somehow reference it to get into the Toolbox?
|
|
|
|
|
You shouldn't be using the toolbox at all, because it doesn't really generate nice HTML. You should just write the code in your aspx to add it.
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.
|
|
|
|
|
User controls cant be added to the toolbox
To use t just drag the user control directl to the page
Alexei Rodriguez
|
|
|
|
|
As the others have posted, you do not use the toolbox to add your usercontrol.
Instead you drag and drop it, but you may need to be in Design view as you otherwise
will just get a reference to the file.
|
|
|
|
|
OK, I went ahead and added the UserControl to a Panel in a Page, but the UserControl was rendered as just a general rectangle, in which there was the message "Error Rendering Control - An unhandled exception has occured. The directive is missing the 'tagprefix' attribute." When I attempted to execute the Web App, I got an error, "The directive is missing a 'tagprefix' attribute.
So it seems that I need to add this attribute. I have never heard of this attribute before. Shouldn't the IDE add this attribute automatically? Or perhaps this is just a standard Microsoft bug?
|
|
|
|