In general, If multiple users thru an application try to update the same tables in database simultaneously, then by default on what basis the priority will be given.Like if we don't have any extra logic for the locking implemented.
View 3 RepliesI wrote an ASP .NET database app, that store data in the database, for some reason, and i've tried all that I know, when two or more users submit info simultaneously, their data gets store wrong, i.e. the data gets mixed up.
View 8 RepliesWas wondering if someone can help me out with this multi update problem
I have a webform that populates a single table but due to certain dropdown data conditions it could also potentially populate 3 other tables
The tables information populates a gridview with amounts from accounts etc..
e.g.
Table 1
Site DataType account update
34 SS 12.50 N
Table 2
Site account
34 12.50
Say the above entry has the updated column changed to Y via the webform the amount 12.50 should disappear from the gridview. I was
a bit shortsighted and added the additional tables afterward. The information on the gridview pulls from the additional tables and since
the first table and the additional tables are not linked the data still stays the same in the gridview
I do have an Id column on both tables but unfortunately I added the rest of the tables after the first one so the Id's do not really match.
I've scenerio where i've two dropdownlist box (one dependent on other, displays handset brand name and on selection displays the respective model name), two combolistbox which is bounded to their respective datasource(Displays the fault and accessories).
Now i've to update the three tables booking(Handsetid, Brand,model), accessories(handsetId,AcesoriesID) and fault(handsetID,faultID). Ive to update multiple rows in Accessories and fault.
These controls are present in datagridview EditTemplate
I have stepped through this code to test it and I am puzzled as to why the update isn't going through to the DB. When I run the SQL statement in SQL editor it updates fine. All variables are getting the proper values when I step through.
[Code]....
I'm using this code to generate my table:
[Code]....
And then im using this code after submiting:
[Code]....
But the ID from the Request.Form is 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26, etc.
protected void Page_Load(object sender, EventArgs e)
I m getting following error in my eventvwr . I couldnt find reasons of the following error.
"Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
The only thing my page is doing is inserting/updating data into a table in sql and the thing I can think of is because multiple users are using the same page to insert/update data? Will that cause deadlock?
I'm having a problem when two or more users simultaneous work on a webpage and provides info to create a new record in my database. the issue is that for some reason, their entries get mixed up and the wrong data gets commited to the database, how can i fix this. All the webpages i browsed for help provide optimistic concurrecny on updaing/deleting existing records, not creating new ones.
I also turned off SessionViewState, but I don't think it helps.
I'm not using a ObjectSource Control, i'm creating new instances of the BLL Classes in my code as I need. Should I null the objects after I use them? They are only created in the scope of a method, so it should essentially dispose of the object when the method completes.
I am creating an online employment application, and instead of creating a table with 20 columns for job duties that may or may not receive values, I simply want to create 3 columns
ApplicantID
EmployerName (Name of Work history Employer)
JobDuty
I want to create a form on a page with 10 textboxes so the applicant can type in some job duties they had at that job.
Is there a way in C# or SQL to then cycle through and insert the textbox values as separate rows?
An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.
Here I am using ASP.NET using C# and my backend in active directory.
Is it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?
View 6 RepliesI want to be able to display the entries in this table based on the date and time of recorded in the entry.
So as an example:
Entry A only appears on Mondays at time X.
Entry B appears on Tuesdays at time X and Sundays at time X.
Entry C appears every day of the week at time X.
Entry D appears every day of the week but twice on each day at time X and y respectively.
I want to select data from a table where the user can search by 3 options; date, keyword, and type. The date will always be either today or a user chosen date. The keyword can be null or something the user inputs. The type will be chosen from a drop down and can be all or a specific category. I know how to search the date, but the other two create complications. I have created a stored procedure trying to figure this out:
[Code]....
Is there a way to say if the keyword is null then don't use it as a search criteria. If that is possible then type can use that same logic I suppose.
I have one SP in sql server which takes the data from user and inserts into three tables. My problem is if multiple users call the same SP in same time it throwing error..(I guess one user at a time can access the table and table will be locked, that is why remaning users getting error)how to handle this situation. it is a web application, so at a time so many people can call the same SP.How can many users insert data in the same table in the same time?
View 5 Repliesi am doin my final year project and in my project i want to watermark multiple images simultaneously where image,logo,position,alpha and key value is stored in a database table ....i need to retreive these details from db table and perform watermark on those images....
View 3 RepliesI'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:
[Code]....
i am new to this linq concept,
i have used the following code to delete multiple records in my table,
but when i hit the button insteading deleting multiple records only one record is getting deleted
below is the code
protected void Button1_Click(object sender, EventArgs e)
I have read up on uploading multiple images and storing them to a file but so far i am only able to store one image into both file and into database. The problem i have is that i don't know how to create the table to store more than one image?
View 8 RepliesI've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
View 6 RepliesI have Tables customer (Customerid),Product(Productid),Order(orderid). i have created view Customerid,Productid,orderid . is it posssible that if i insert value in view it will get inserted in table itself. can i do it in MS SQL SERVER
View 1 RepliesI have a page in which there are multiple updatepanels and each of these update panels are trigerred by different triggers.
These update panels are used to do Async post back and the page is updated with the data retrieved from the async post back.
Now the issue i am facing is that since there are multiple update panels, the update done by one panel is lost when the other panels does the post back.
let me know if any one knows on how to solve this issue.
I want to know if we can use multiple membership providers simultaneously in a single ASP.net application.
View 1 RepliesI have been google some but I canīt find any solution that have been worked for me. I do use System.Net.mail on my site to send emails to individual employes. Now I would like to be able to email all emplyees. The emplyees email address is stored in a MS SQL table. Is it possible to make a BCC email to all employees in that table?
View 2 RepliesHow can insert, Display ,update multiple records simultaneously through GridView in Asp.net.I have Button for insert, update . I want insert, update multiple records through a GridView in a single click.
View 1 RepliesI have two different repeater control which are in two different Update panel.I want to bind one Repeater value with another.But When i am using asyncPostBackTrigger or postbacktrigger it is reloading whole page.
I want to load only load update panel