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

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

Accessing the same database many people at once

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net

I there.

 I made a website, 1 database;  We have 4 cumputers, the 4 are using the same website and saving datas at the SAME TIME.

 The problem that i have is that when 2 people click in the save button at the same time, only onces is in the database, but the others get lost.


 Visual Studio 2010, Framework 3.5, MS-SQL 2008, C#.

 The conecction is in c#, everthing is in c#.





View Complete Post

More Related Resource Links

accessing values from a database with datalist?


I have a datalist and I am filling it using a dataadapter, dataset. So in my .ascx page, I have

<asp:datalist runat="server" id="dlProducts" repeatcolumns="2" repeatdirection="horizontal">


<table border="0">

<tr><td><%# Eval("Item_Name") %></td></tr>

<tr><td>I have to add a picture here</td><td><%# Eval("First_Name") %></td></tr>




In the area where I have put a statement like "I have to add a picture here", I have write a big case statement.  Like:

Case: 6 // show a picture from file1

case: 7 // show a picture from file2

Case 8: //show a picture from file3


So How do I do this here?  Because I dont know how to access the datalist values from code behind.


Here is my code behind:

SQLString = "SELECT First_Name, Picture, item_name, item_id from table1 where item_id = " + request.querystring["iid"];

dataadapter daItems = new dataadapter(SQLString, "connection_name");

dataset dsItems = new dataset();



Accessing a database

I have added a folder called "Databse" in my application and inside that i have a databse file(SQL Databse named dbFiles), and my connection string looks like this : < add name="conString" connectionString="Data Source=localhost;database=dbFiles;Persist Security Info=True;"/> Now my problem is i am unable to open a connection to this database. What am i doing wrong????

Accessing database in STANDBY mode while log shipping

Hi,     I am testing with Log shipping, I have it setup and it is working just fine. The secondary database was restored with Standby mode and is readonly. I have no problem accessing and querying data from the secondary database but I noticed if changes are made to the primary and I am accessing the database when the restore step to the secondary runs it fails with the following error: Message2006-07-31 09:40:54.33 *** Error: Could not apply log backup file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\LogShip\CI_REPLICATION_TEST_20060731131501.trn' to secondary database 'CI_REPLICATION_TEST'.(Microsoft.SqlServer.Management.LogShipping) ***2006-07-31 09:40:54.33 *** Error: Exclusive access could not be obtained because the database is in use.RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) *** This appears to be because you can not restore to a database that is in use? How do you get around this? Is it possible? How do I query data from the secondary db without worrying about causing log shipping to fail? Do I not worry about it because at somepoint when Exclusive access is obtainable all the logs will be rolled forward, but this could create a wide gap in sychronization between the primary and secondary db's, say if someone or something does not properly log off. I guess I could disconnect all users prior to applying tlogs but that kind

Accessing my Web Application's database with MSSMS at the same time.



I wish to acces my database using MSSMS at the same time that I am running my web application. When I tried to access my database with MSSMS I get the following error:

Failed to retrieve data for this request (Microsoft.SqlServer. Management.SDk.Sfc)

Additional Information:

Unable to open the physical file "C:\inetpub\wwwroot\myapp\App_Data\aspnetdb.mdf".
Operationg system error 32: "32(The process cannot access the file because it is being used by another process)". (Microsoft SQL Server, Error:5120).

What can I do to being able to view my database with MSSMS at the same time?

Thanks for your help,


There are too many people accessing the Web site at this time


Hello When I publish my application and host that into IIS.

I got Below errer when i try to access my application from browser.

"There are too many people accessing the Web site at this time"



Ashish Patel, MCTS Software Engineer [Level - 2]

Accessing a .mdb database in 64 Bit Platform


I want to upgrade the 32bit application to 64 bit application.
In my 32 bit application i use Microsoft Access as the backend database ( simple only with some few tables, no relations)

I have used MFC database classes like CDaoDatabase, CDaoRecordset for accessing the database.
During the upgrading process i came to found that CDaoDatabase classes are now no longer supported in Win64 platforms.
I get the following error:
 fatal error C1189: #error :  DAO Database classes are not supported for Win64 platforms

Also going through some of msdn Q/A articles, i found that CDaoDatabase classes have been deprecated now, or sth like there is no provision for accessing the .mdb in X64 platform.

Is there really no method for accessing the Access database in X64 platform.
Are there any other solutions.....
Is switching to ADO.Net will be the solution....

Hope Somebody will put the light on this topic..

Anur RS..

Accessing data in infopath form from another database


Hi, I am having Sharepoint 2010 RTM Enterprise Trial on Windows Server 2008 SP2.

can it be possible to retrieve data from another database (not a sharepoint databse) and populate infopath form with it ?

if yes, please provide any links so that i can start from there....

if no, please provide any alternate solutions...


Error Accessing Oracle Database in a visual web part.


Hello All,

  I'm new to SharePoint development.  I’ve the development box set up with Windows 7 64 bit, share point development environment installed (SharePoint Foundation) with all the hot fixes and I’m able to create and publish a visual webpart and access it. I’ve also installed the 32-bit ODAC (ODAC 11.2 Release 3 ( with Oracle Developer Tools for Visual Studio) and I see the Oracle.DataAccess file in the GAC installed. Here are the results from GAC

C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>gacutil /l Oracle.DataAccess

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

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.

Accessing the different controls inside a GridView control

how we can access a particular control which resides inside a GridView control. In this article I will show you how you can access different controls inside a GridView control. We will see how we can access a TextBox control, a DropDownList control and a ListBox control. If you are working with ASP.NET 1.X then you might want to check out my article Accessing Different Controls Inside a DataGrid.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

This links important to how to create connection string to any data base sever.
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