I'm trying to use the OracleClient provider in my asp.net
pages, but the namespace only seems to be available if I
put a copy of the System.Data.OracleClient.dll file in the
\bin directory of my web application.

I was trying to find the best way to go about managing a SqlConnection
object being used by a web service. In theory my thinking was that I would
create a shared class that would hold 1 SqlConnection, handle the connection
string and opening/closing of the connection, and expose the ...

I get strange character conversions when fetching CLOB fields in Oracle 8i.
When looking at the data in the database with TOAD the characters seem to be
correctly stored.
The character ''' when fetched is represented by a square (unknown?) in a

I recently created a generic data access layer so I can use it in many
applications.  It is designed to return datasets, datareaders, scalar
values...  I recently have come across in an application that uses the data
access layer needing a datatable instead of a dataset.  What I ...

I need to access an Oracle database from VS.NET.  I
established a Microsoft OLE DB Connection for Oracle as
suggested by VS.NET, and the Test Connection works (Test
connection succeeded).  However, I couldn't establish an

I have a data set that contains two tables tblheader and tbldetails.
The insert command is a stored procedure with paramters. I am doing the following
adapter.InsertCommand.Parameters.Add(New SqlParameter("@p1", SqlDbType.VarChar, 40, strp1))
adapter.InsertCommand.Parameters.Add(New ...

I have a dropdown list that is initiated if Not Postback. However when
a postback occurs, the dropdown's value is reset.
Is there a property I am missing, or some even that is getting fired
that might be causing this?

I think I am on the right track here but unsure......
I need to:
1. find all like items  in the ITEMNO column in the dataset called "RESULTS"
2. in the column called "DATE"  (called DATE with a smalldatetime value -

I have the foll csv fil
01,1211
02,1415
05,1101

I need to identify which row is selected in a DataGrid bound to a DataTable.
How do I do this, I'm pretty lost atm and need to make a demo work for
tomorrow. Please help...
Cheers,

I have a SP Problem.  When I query this SP in Query analyzer, it completes
in less than 6 seconds with almost 70000 rows in my resultset.  When I run
it in VB.NET, it times out and fails.
The connection itself is fine, as it works for other queries that run before

i have successfully added a combobox control in datagrid. this is the
code i have created but don't show up the record from another table.
       Private Sub AddCustomDataTableStyle()
           Dim ts1 As DataGridTableStyle

Is it possible to copy an Oracle database table with a SELECT command or
something else?
I tried reading the data from one table in a dataset, then renaming the
table to the one in the database and then do an UPDATE on it, but it didn't

Anyone have this book? I've run into an example that doesn't work, and
can't relax until I understand what's wrong!
Listing 1.4, p45 ( see below )
In the book it says 'If e.Row.Item "FirstName") = "" 'etc.

How do you retrieve the value of a column in the current datarow object in a
dataset?