|
IS it possible to filter an excel sheet from # form. The excel sheet will be opend from Excel application or from Excel viewer. For example customer want to know the lowest price of the itemsize starting with '23565'. The excel sheet contain many items with that item size of diffrent manufacturer starting with 23565 . When the user type in textbox of the form , the excel sheet should be filtered by the value giving on the textbox.
Pls have any idea that would be very appreciate.
Pol
|
|
|
|
|
Excel already has that capability. What is it you are looking for?
Failure is not an option; it's the default selection.
|
|
|
|
|
You can use Excel Automation to do that. This[^] post will help you get started.
|
|
|
|
|
Hi there,
I have some files in my website for being downloaded by signed in users.
But due to the bandwidth limitation I have to restrict users to download only a specefic size per day for example 100MB per day.
Now I'm looking for a way to measure the user's download size.
Any help please?
|
|
|
|
|
You should really have asked this in the ASP.NET forum. Anyway, assuming that you only allow logged in users to download files, on every download request you would get the size of the specified file and see if adding it to the days total would take the user over the limit.
I know this seems obvious, but bear with me: the wrinkle you have is in defining what counts as a day - is it based on the last 24 hours activity, or is it based on an arbitrary point such as midnight on the database server. The reason you need to know this is because this will affect your calculation as to the previous day. Now, I would suggest storing the current server time in the database against each download for the user as it will make your calculations easier.
Further wrinkles for you to think about. What happens if the user aborts a download and then restarts it? Does this count towards your size limit? How are you going to handle the switch over when the clocks go forwards and backwards by an hour?
|
|
|
|
|
Thanks Pete,
for the sake of simplicity lets neglect time restriction. so here we only have the size as a criteria for dowload restriction.
for the complete dowloads I don't have any problem but somehow download process become aborted I should have the amount size of downloaded bits because this count towards my limit size.
|
|
|
|
|
With a simple database table and a simple query, you should be able to easily limit the user then. All you need do is track the amount of data downloaded against the user by time.
|
|
|
|
|
I know that. My problem here is that how can I figure out how many bits are downloaded.
I need a code snippet.
|
|
|
|
|
That really depends on how you are letting them download. If all you are doing is putting onto a response stream and letting them download that (and not worry if they abort out mid transfer), then you simply need to count the bytes you are pushing into the response stream. To be honest, this is probably your best bet as other methods become a lot more complicated.
|
|
|
|
|
|
No problem. Glad to help.
|
|
|
|
|
OK. You should have posted this in one location only. Please don't crosspost as it's rude.
|
|
|
|
|
We are creating a chat client application where we need to push messages to mobile clients.
No we have WCF service and client is requesting service every 3 minutes.
Is there a way we can use WCF to push data to clients over HTTP?
|
|
|
|
|
You need to probably take a look at Duplex Services - see this blog[^]. Apart from this you can read more about these type of services on msdn.
|
|
|
|
|
nitin_ion wrote: Is there a way we can use WCF to push data to clients over HTTP?
There is no way to push over HTTP full stop, never mind with WCF. HTTP is based on a request/response model so you can only send data in response to a request made by the client.
|
|
|
|
|
That's not entirely correct. It is possible to establish a polling duplex HTTP connection. You can find details here[^] on HTTP push.
|
|
|
|
|
Most of those are essentially faking a push. Re-using a connection would count but I didn't think the browser/service client would accept a second response within the same connection if it hadn't requested it.
|
|
|
|
|
And this is why I was careful to say a Duplex connection - so that the client knows that the response will be left open.
|
|
|
|
|
Push is evil, don't use it.
Always use polling.
|
|
|
|
|
Yep.
And like extra worse for a chat mobile application.
|
|
|
|
|
For a web service, yes. There are other scenarios where that's definitely not the case though (when the speed of update to clients is critical and the number of clients relatively low).
|
|
|
|
|
BobJanova wrote: There are other scenarios ...
Never for a "chat" service. That means humans. And with a low number even less point.
|
|
|
|
|
I'm writing a C# program that reads RSS feeds and displays them on a windows form... The program first worked fine, no problem, but suddenly it began to crash once I had navigated in the web browser control in the C# program. I got into some sort of knowing what causes the problem... When provide the web browser using WebBrowser.DocumentText = sting with large amount of data it does crash... so does anybody have a solution for that??
sb.Append("");
sb.Append(row.title);
sb.Append("
");
sb.Append(ASCIIEncoding.ASCII.GetString((byte[])row.desc));
desc_self_nav = false;
webBrsrRSSDesc.DocumentText = sb.ToString()
|
|
|
|
|
Is it the webbrowser that crashes, or the stringbuilder? Can you paste the text of the exception that it throws?
Bastard Programmer from Hell 
|
|
|
|
|
Eddy Vluggen wrote: Is it the webbrowser that crashes, or the stringbuilder?
That's what the OP wants to know.
Eddy Vluggen wrote: Can you paste the text of the exception that it throws?
Obviously, if there was an exception, it would not be called a crash.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
