473,503 Members | 1,725 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Csharp sql server query locks database as I step through it

2 New Member
Is there a way in cSharp using SqlDataReader, SqlConnection and sqlCommand, to step through a query and not lock it, like the option adOpenStatic in vb6 did? Thanks
Jun 29 '11 #1
2 1752
Subin Ninan
91 New Member
Set MultipleActiveResultSets property to True in connection string.
Jun 30 '11 #2
Steve
2 New Member
Hi thanks for the reply but that did not work. While a report was running, a application could not connect to the database. I got around this my using a DataSet in my report.
Jun 30 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
9440
by: Michael Holberton | last post by:
Hi All Can we connect remotely using SQL Server Enterprise Manager from our home PCs using a VPN connection, across the Internet, to an instance of SQL Server(or a database on it) that resides...
2
2478
by: vidya | last post by:
Hi, I wrote a stored procdure in SQL Server which calculates some metrics. This procedure always returns only one row with 11 columns of integer values. I ran it in SQL Server Query Analyzer...
2
1340
by: Jorge Varona | last post by:
Greetings, I am having a difficult time trying to get my index server query to work. Here's the code: // create a connection object and command object, to connect the Index Server ...
3
1755
by: johnb41 | last post by:
Can anyone help me? I need to create a SQL Server Express 2005 database programmatically in my app. I have searched the web and I found nothing. Can anyone help? Are there classes in the new...
1
3282
by: swatijogdand | last post by:
How to link table of sql server to access database using ado?
1
2355
by: wintonsl | last post by:
Would anyone know how to convert this Access Query to SQL Server Query? Format(((+++)/(IIf(>0,1,0)+IIf(>0,1,0)+IIf(>0,1,0)+IIf(>0,1,0))),"Standard") What this query is doing in Access is...
1
1334
by: srikalyan | last post by:
I have this C++ program that queries the database on the local host. But if I have to query the database that from a remote machine then what are the commands and libraries that I have to include in...
4
4146
by: winniewang | last post by:
Hi everyone, Who can help me to translate the SQL Server query to DB2 query? The query were shown as below: CAST( CONVERT( CHAR(2), MonthNumberOfYear) + '/ ' + '1/' + CalendarYear AS...
3
2809
by: Max2006 | last post by:
Hi, I have a search result GridView bound to an ObjectDataSource. Once I open the asp.net page, the ObjectDataSource automatically refreshes the GridView which is the default behavior. I am...
3
9039
by: Kunal Desale | last post by:
Hello, I am migrating access queries to SQL Server 2005 Queries. My Access Query Is: SELECT qtrade.intordreftrim AS Expr1, qtrade.extordreftrim AS Expr2, qtrade.intinvreftrim AS Expr3,...
0
7086
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7332
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6991
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7462
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4673
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3167
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1512
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
382
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.