For data retriving only operations I always try to use DataReader as much as
possible rather than DataSet because I think DataSet is bulky and takes
alots of resources.
Am i on right track  ?

Either MSDE or ADO.Net hangs when I rapidly run a series of identical
database reads.  The only useful message I get is
System.InvalidOperationException which tells me I have a timeout somewhere.
But, where?

i have a table with 10 fields.  i want to write an update stored procedures
so i can update any number of fields in the table, but i don't want to write
a seperate sp for every combination of parameters.
is there a way around this problem?  and do i need to do anything special

Hi there guys!
i'm using this query in VB.NET:
Dim sSQLFirstAvailable As String = _
   "SELECT TOP 1 * " & _

I have an environment that has multiple servers and on each server I have a
copy of a specific db with the same table.
I'm looking for an approach to fill a datatable with the info that each
table on each server has.

I wonder if anyone can shed some light onto a intermittent problem I
have at the moment it is the good old ORA-03113 Error.
MESSAGE: ORA-03113: end-of-file on communication channel
DATE: 09/03/2004 09:10:24

Does anyone know how to use databinding to bind your dataset to windows form
PictureBox control? 'cause I don't know how to bind the Image property from
my datatable's string field (called ImagePath), as far as know, i can use
following syntax to bind other controls such as textbox:

App is VB.NET, using adonet
When app runs from the build machine (where compiled) it runs great.  If I move the exe file to a shared public drive (for deployment) I get errors whenever I try to instantiate an ADO object.  I am trying to run the app from the same machine, but ...

i have created an sqldataadapter using a wizard and added the
necessary textboxes in my form and done some navigational button like
previous and next button to browse the record. now i made some changes
to my record in my textboxes to find out if the record is save to the

I have .net (C#) application that accesses a remote ORACLE service
(8i) using System.Data.OleDb to fire off a stored procedure.  Granted
this is a long running stored procedure but I want to cap things at a
couple minutes so I can try again.  The problem is that no matter what

I am having a hard time figuring out how database update works with
DataSets. Here is an example of what i want to do:
To make it simple, let's say i have 5 tables Users, Teams_Users,
Teams, Operators and Operators_Teams

I can get updates and inserts to work but not deletes.  This code
yields a DBConcurrencyException 0 records affected even in situations
where the delete does take place and removes several records.  Can
anyone point out what I'm doing wrong?  Thanks.

ooops!  :oops:  My sproc handling the delete command was of the type
"delete from table where field = parm" so the first time it was
called it deleted all the rows.  Subsequent calls to the delete would
return 0 rows affected which the DataAdapter interprets as a

I get a "Timeout Expired" exception trying to update database on a remote
computer.
I am wondering what is happening at the database, will my command still be
executed at the database server, although my ADO.NET application get the

I'm developing a project using VB.Net and MSDE as the data source.  In one
scenario I need to return a set of data which also requires some static data
to be included with it.  I figured a simple way to do this is to generate a
simple stored procedure which uses a temporary table ...