.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Strategy for saving information by thousand of users in a short time.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :ASP.Net


I am working on an application which will be like users will be working offline (most likely a window app) all day saving 10-50 rows of data on to a text file and at the end of the day when they come online they will be uploading the data to main sql server database using the app. There may be hundereds of users saving information at a time within a short span of 20-30 mins.

I am totally new to developing an application which has that amount of activity. Can anyone tell me the best possible strategy so as to avoid issue on concurrent saving in case of too many users. Will Sql Server 2005 will do ok or my app is likely to face any issue. Any errors that I might run in to.

 Any help is appreciated !

View Complete Post

More Related Resource Links

The Free Barcode Creator produces barcode images one at a time, and allows easy saving to a file or

The Free Barcode Creator produces barcode images one at a time, and allows easy saving to a file or pasting into an application. 2D versions are also available:

SQL Server: Build Apps that Provide Real-Time Information and Customized Content Using SQL Server No


The adoption of wireless devices continues to spread unabated, and organizations are looking for new ways to get in touch with customers through these new mobile devices. In the past, unsuccessful ideas such as push technology were used to send targeted information to customers. Now, SQL Server Notification Services uses the SQL Server 2000 database engine and the .NET Framework to promote a new breed of notification applications that will allow relevant, consensual communications to be sent to any subscriber device.Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.

Mark Brown

MSDN Magazine November 2002

how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help



I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help


Thanks in advance!

Track declining information over time

I am having some annoying problems, both based on the same principles. For the first issue, I am trying to track a census.  Basically, I have a list of people at a place, and want to figure out how many came in, and how many left, which will give me a positive or negative number. I want to compare this number to the original count of everyone, and then increase or decrease the amount by that factor. For example"   Starting number of people: 400     People Added: 2  People Subtracted: 10 Net loss or gain: -8  New number: 392.   I want that number that keeps track of everyone to be plotted out by month, in a line graph, so my chart would be something like   400 350        0 300                                0 250                                                 0            August             S

SharePoint 2007 + PowerPoint gives "Contacting the server for information" for a long time

I've never had this issue for but today all of a sudden I tried to open a PowerPoint document posted to a document library on our SharePoint 2007 site and it gave a message saying "Contacting the server for information" for a long time.  It eventually opened but not until after 5-10 minutes.  Does anyone know what might have caused this?  The file itself is pretty small, only 70KB, and as I said we haven't had this problem before.

Let the users know that something is being processed in the background as they wait for a long time



I have a listbox that contains a list of items. The user is required to pick the items from this listbox and add them to another which is called selected items listbox. When doing this he needs to check for any duplicate entries as teh available listbox can contain duplicates but not the selected items list. I have 2 buttons "Add" and "Add All" to add items from available to selected list. The code for Add All button is:




What are the options to get information from anonymous users in sharepoint ?


1) i tried with the infopath form submitting but found out that sharepoint wf wont start for system account submission

2) I tried useing list form, sharepoint workflow doesnt work also it shows view all site contents & throughs an error when anonymous user submit the list form but i can see item in allitem.aspx

i cant use the form based authentication, beacuase form itself an request for account password & we dont want users to register again

Get Users by Profile Information


I am useing asp.net membership to store my users and under each users profile there is a field for their supervisor. I would like to get a list of all the users with the supervisor "Jon Doe". Is there an easy way to do this or would I just have to loop through each user and see if there supervisor = "Jon Doe" then if it is store there username in a list ?

How to find the Eastern Time after Daylight Saving Time difference (GMT - 4) or (GMT - 5)


Hi All,

I am using SQL Server 2005.

I have a requirement to find the Eastern Time,

Which is (GMT - 4) during Daylight Saving Time(DST)

and (GMT - 5) during non DST.


Can anyone help to develop a logic without hard coding any date and time values, to find the Eastern Time(EST)?


Thanks in Advance...



How to handle Daylight Saving Time issues in sql server Database


Hi We have users across the globe and have issues everytime the Daylight Savings change occur. Is there a way to handle this issue in sql server?


SharePoint Date Time Control logic for saving and retriving in List


Hi Friends,

     I am Ali, I need to set the SharePoint Date Time Control in my webpart.


1. When i am adding student details in Admission Form, ( Fields like Name, Class, data of birth, Date of Joining ...)

2. at Date Of Joining : here,  SharePoint Date Time Control should show the default date as (Sys date). 

For this i am using this :  

" DateTimeControl1.SelectedDate =DateTime.Now; "

it is working fine.

and For Saving " Date "  in list item From SharePoint Date Time Control i am using this :

listitem1["Date Of Birth"] = DateTimeControl1.SelectedDate.ToShortDateString();


3. When the user retriving the date from particular list, here Date Time Control should show the date, as what date he (student) was added in the list.

for Retriving date from List to SharePoint Date Time Control i am using this as below: But it doe

UTC Offset Lookup Table for different Time Zones with Daylight Saving.



I am trying to populate a table for on SQL 2008 Server which should have start datetime and end datetime for daylight saving for various world time zones. So that I can lookup if a particular date is between startdate and enddate and get UTC offset.

Something like the following table. Checked this link but not sure if I can use it in anyway for the information I am looking for or need something completely different.


I not an SQL expert and finding it really difficult to get solution for this problem which I am facing.

Appreciate help.



Deadlock Occured while muliple users using one form at a time.


Hi All,

            I have one web application in which when multiple users working on same form at that time deadlock is occurred.Actual Exception is given below.

Transaction (Process ID 72) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

I already used a begin tran and commit tran in my dataaccess class and rollback tran if exception occurred.i also read some issue in msdn also at that place i read that update statistics.so i execute this stored procedure sp_updatestats but still there is no result.so please anyone tell me what should i do for this deadlock?

Nikunj Nandaniya

worflow for short time activities


Dear Folks,

Currently I am working on a travel booking portal where travelers can search and book a flight but user has the option to book online and pay later within specified time frame (say 2 hours). Here, I am thinking of implementing the workflow for order fulfillment with following states.

OrderBooked (When user book flight online but has not paid yet)

OrderPaid (Later when user pays using credit card or any other payment mechanism)

OrderCanceled (If user doesnt pay in specified time)

OrderCompleted (in case user pay and ticket successfully generated)


Here I am no sure if we should implement WWF in this scenario as the life span of an order is very short (say 2- 4 hours). If payment is not done in this time span, order will be canceled. My understanding is that WWF is best suited for long running activities.

Please suggest



Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.
The Time Zone
DST Start DST End Offset for UTC
EST 3/13/11 4:00 11/6/11 3:00 240
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend