If you run the following query
select
'CategoryID = ' + c.CategoryID
from

I am using manual transaction control with the Ingres ODBC data
provider for .NET. I have simulated a bank transfer example and found
that, despite setting the isolation  level of the transaction to
serializable, the result of running the transfer concurrently is >not<

I have a design decision to make. I must choose between a DataAdapter.Update() and many DbCommands (actually SqlCommands)
Let's assume that a small percentange of the columns need to be modified on average. This would suggest that long strings of SQL will be traveling to the ...

I have a C# type that exposes one of its properties as a DataTable.
Unfortunately, i need to use this type from a COM application ( an ASP page
to be accurate ). So I have registered my type with Regasm and can create it
and use it just fine...except when I need to reference the ...

I am attempting to maintain a database connection across threads. I am
receiving the following exceptional error:
"There is already an open DataReader associated with this Connection
which must be closed first."

   What do I have to do to mey development webserver to remotly debug a
project using the IDE?  Basically, I have my server, and I work on my
workstation, and create/run the projects from the server remotly, but
debugging won't work.  I tried to install just the remote dubugging ...

I hope i explain this clearly. I have 2 tables. TABLE1 contains 250 rows with the following data:
quantit
part I
purchase order numbe

Hi, All
I populate a datagrid using dataset, read data from SQL Server database
"Northwind" database including "Customer", "Order" and "Orderdetails"
tables. When the "unit price" display in the datagrid, it does not have $

I have a MS Access database (say abc.mdb). I have set the database password
and admin password to "abcdefg" (say). The problem is that when I create a
simple application (a form-based application or asp.net application) and try
to connect to the database using ado.net i get ...

I have a single-threaded WinForms app which uses SQL Server 2000 as its database
Part of the app is a 'Restore from Backup' form which uses SQLDMO code. I keep gettin
errors telling me that there are other connections open - therefore the restore can't go ahead
I used sp_who to ...

String cstr = "select * from tFam where name like \'" + tFind.Text + "\' order by name, fname"
Directed to Access DB
Works fine when tFind.Text = "nelson" but returns nothing when tFind.Text = "*son". Same behavior with single or double quotes around the find text. What's up
Thanks

I am running Dot Net 7.1.3088 on top of framework 1.1.4322
I cannot find the system.data.oracleclient namespace.
I tried running the 'Managed Provider for Oracle ' oracle_net.msi.
This ran OK but still no client namespace.

I have a problem but i don't know how to solve it. I have a Login page
where i use Form based authentication and i use sql server. When the
user is logged in he is redirected to the correct page. I have users
that work in different shops. I want to populate datagrids, listboxex

I am running a VB.NET application which is using ADO to connect to an Oracle
9i database. I have a form which runs a query which can take a considerable
time to run depending on the criteria that is entered. This query is run on
a seperate thread as I wish to return control to the ...

ODBC as well as ADO have connection boxes that allow to set up connection strings (pick providers or ODBC drivers etc.). Is there something that is equivalent for ADO.NET. Does ADO.NET still use OLE DB providers or is there something different with the .NET providers and ...