.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

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

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

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

View Complete Post

More Related Resource Links

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!

make anonymous users submit data to a form library

isn't there a way for anonymous users to submit form data to a form library without custom code?

time out stored procedure windows form

I have a form that runs kicks bulk copies data to a data base and then runs a stored procedure.  the problem I have is the stored procedure takes a long time and users have no way to know what is going on.  the app window freezes says not responding and then after a while it completes and moves on. is there a way to prevent the application from freezing and being marked as not responding?

Anonymous users submitting Infopath forms via InfoPath Form Web Part

Is there a way for anonymous users in a public facing site to submit InfoPath List Forms via an InfoPath Form Web Part? Currently when I go to a page with the InfoPath Form web part configured as an anonymous users I get the following error message: Error loading the form A form template (.xsn) file cannot be accessed. You may not have the required permissions to open the file The list allows anonymous users permissions to add and view items When logged in the form works fine

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:




How do I allow multiple users to desing the same InfoPath 2010 form? Preferably using SP 2010 to ho


We have several users who need permissions to edit a template and publish that template to the forms library.

The primary designer creates the template and uploads to a doc library.  Admin staff from all divisions need to be able to flesh out the template and publish for all users.

Design time, unhandled exception occured, request is not available in the context


i am using a user control that has the html code with head tag is set to runat server. when i drop this control in main page, i am getting an error in the design time, Error rendering control, unhandled exception occured, request is not available in this context, but at runtime, everything is working fine. i can fix this by removing the ID and runat=server in the head tag, but how to make this to work without removing the runat server for head tag ?.. which request it means that is not available.

i am very new to C#, i hope what i am asking makesence, apologize if i am not clear, i highly appreciate any explanation ! thankyou !...

here is the code present in the user control...

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="header.ascx.cs" Inherits="user_controls_header" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">

Increase Session Time Out in WSS 3.0 Form based Authentication Site


How to increase session time out for form based authenticated shrepoint site ,

Default Sharepoint  time out is 30 min ...

I want session shuld expire after 120 min..


add control (ex:textbox,button....) to form at run time


how to add control (ex:textbox,button....) to form at run time?


Infopath form timesheet question on rounding time and using code


We have a timesheet form that has 4 time fields:  Start Time, End Time, Actual Time and Billable Time. 

Our Start Time, End Time and Actual Time buttons and field calculations work just fine, but we want the 4th field to calculate the billable time by rounding UP to the quarter-hour.

For example:

Start Time - 9:00am

End Time - 11:20am

Actual Time -  2:20

Billable Time - 2:30 (or 2h30min)


I'm new to Infopath and not sure how we would accomplish this.  What type of code would I need and can I even use code on that Billable Time field to accomplish this?


Thanks for any help you can give me!


InfoPath 2010 master details form, Submit data to muliple Form Library

I have 2 Form library
Library 1 :
    Employee ID
    Employee Name
    Employee Age
Library 2 :
    Employee ID

I want to create one form using Info Path as master details form. i.e for Library 2 repeating field.
How we can do this any one have any idea.

I have tried to submit this form data into 2 data connection in info path, but its not working ....

Custom Form Field in Collect Data Action doesnot capture multiple users.


I have a situation where the department head dynamically assigns the reviewers depending on the document that is uploaded. To capture the reviewers I added a Collect Data Action and a "Reviewers" form field, with type "Person/Group" and checked the following properties

1. Allow selection od People and Groups, 2. Choose from all users and more importantly 3. Allow multiple users

Although I am able to enter multiple users in the form, I am able to retrieve only the first user I entered and the rest just.. disappear!

Infopath 2007 : can users anonymously save an uncompleted form they can later return to?


i am using infopath 2007 to create a survey that is web-enabled, and is stored in a Sharepoint Document Library. the survey is pretty lengthy and i would like to know if they can save what they've done to a certain point so they can return to it later?

the catch is that the survey should remain anonymous during that time (i know that i can have them save results in aforementioned document library, but then they can see other people's responses if they, too, save an uncompleted survey).

thank you.


SharePoint Designer workflow task - problem with multiple users selector in InfoPath form




I have got an issue with InfoPath form generated for my SharePoint Designer workflow task. There is a multiple users selector that requests users from a task assignee. The problem is that only the first user entered got saved.


I am using SharePoint 2010 Standard Server (release). Steps to reproduce are the following:

Auto Populate current date & time in the New form



I have requirement where I want the current date and time in the newform opened by users. I can get the current date with Today's Date option. But not able to find the time option. Is there a possibility with SPD. Tried using button option to activate a formula to the textbox value so the user can jus click the button to get the current time and date. but facing problem in that.  Kindly advice.



Access Form's Components at run-Time


Hi everyone.

I need access form's components (for example a timer) from outside of form (class).

Have can do this ?

Values in repeating rows being replaced after opening the form a second time


I have a couple Infopath forms and recently they started behaving oddly.

In each of them there is a repeating row. In each row you enter a work order as the first value/column, this then filters the second column which is a drop-down with the various items on that work order. The remaining rows are then descriptions of those select items respectively. This information is all retrieved from a single SQL connection.

It all looks great, you click submit (It submits those values to a SharePoint list) and is then saved in the document library. However if you open the form after the values in each of the repeating row has reverted back to the first item for the selected work order.

For example: I enter work order 3344 which consists of items x, y, and z. In the drop down I can select item x, for the second item, I select y, and then z for the third for a total of 3 rows I then click submit.

If I open the form again the correct work order is still displayed but the three rows are all showing details for x, the first item in the work flow.

Does anyone have any idea what could be doing this? Thanks in advance!

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