Hello All;
Does anybody know any way to start read-only Oracle transaction in .NET
application?
This mode can be set in PL/SQL by SET TRANSACTION READ ONLY statement, but

I'm using the following code to obtain information about any table in a
database. Now _schemaTable contains the info about the table and one of its
fields is "IsKey" which as far as I know should identify the columns that are
the primary keys in the table. Unfortunately "IsKey" ...

I have a need to effiently load millions of fairly small records into SQL
Sever 2000.  I have some financial data with many, many observations (one
set has 37 million records) and I need to get it into a  SQL server.
I create a comma separated variable (CSV) file using a VB.NET ...

I've developed a .NET 2003/SQL Server 2000 application. When the app fires
up, it loads combo boxes (Using SQLDMO) with available servers, databases
and tables. It works great. However, when I move the solution to another PC
and try to run it, it fails saying "Login failed for ...

I'm working with a large ADO.Net DataSet and my application uses quite a bit
of memory.
According to the memory profiler I am using, there are about 120,000
DataRows, and they take up about 5 Megabytes. These DataRows are contained in

I was doing some testing and noticed that when I execute a stored procedure from
my ADO.NET (using the Command class of the System.Data.SQLClient namespace) the
number of reads on a relatively simple query were significantly higher.  As a
matter of fact I have not found a case ...

We'll host a webcast on ADO.NET 2.0 & SQL Server 2005 next week. I thought
you guys might be interested. For more information you can check out:
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032263284&Cu
lture=en-US
This is part of a webcast series on SQL Server ...

Using SQLServer database.  UserId defined as numeric and First/LastName
fields defined as nvarchar(50).
Here is my SQL Statement:
SELECT UserId, LastName & ', ' & FirstName AS FullName FROM Users ORDER BY

Is it ado provider by default do the connection pooling? or it is depending
on the database.  I know sqlclient provider does the connection pooling but
can I use connection pooling with MYSQL?
thanks

I have the following comma delimited file to read:
    Date,campaign code,count
    12/1/2004,DM31,10
    12/1/2004,DM32,15

A row was deleted in a DataTable, and now I want to bring it back so I
can remove it (so my dataadapter will not touch it later).
How can I do that?
Thanks.

I have two datatables,  dtTable1 has an INDENTITY column, dtTable2 has a
integer column to have the value of table1 indentity column but it can be
null. so I can't create the relation between tables (unless there is some
kind of ignore null relation). Now when I add new row to ...

I'm trying to figure out a general algorithm to allow any valid MS SQL 2000
username/password combination to log into a Winform application.  I'm having
trouble with special characters.
I'm created a user named test

My Windows Form contains DateTimePicker to show date-type data from
DataTable. Because application need to be able to save "no date" ie.
NULL into database table, I solved it like way...
("dtpRepaired" is DateTimePicker-control)

I'm using SqlDataAdapter to get records from table at database different
from my connection using the databasename at the select statment
"Select * from otherdb..myTable"
After updating the data I want to update the table, I'm using