I'm trying to use the general architecture of Duwamish7... the Data layer
loads selected rows from several related DataBASE tables into one DataSET
object and then returns the DataSET to the business/user layers. The
business/user layer then modifies the DataSET and passes it ...

I'm wondering if anybody has seen this problem. I basically need to cycle
through ~30000 db rows to update the data, I load up the id of the rows I
need first, put them into ArrayList, close the connection, then process
through one record at a time, so there is no nested transaction ...

I'm using VB.NET for this one, and it is straight forward.
I have a sp that takes an input parameter (a string) for querying the
db. Here is the sp:
CREATE PROCEDURE [dbo].[web_SearchByName]

I'm testing OleDbCommand for calling a store procedure in a Sybase DB
I'm using an output parameter but always I get DBNull
here is my code:
Dim conn As New OleDbConnection(connStr)

I just have a little but important question. If I need to read and
XMLDocument (XmlDataDocument) into a DataSet and bind it to a Datagrid....
Does the target computer require MDAC installed in order for this to work?
Thanks!!!

How do I get at a MySQL database? Is there an interface, "SQLClient" type,
to get at it somewhere?
Thanks...
Bruce

I've come across a problem while trying to fill a DataSet.
Hopefully someone can help me out.
What I have is the need to combine data from several databases.
The schema in each DB is the same with the possible exception of unicode vs

I've been developing in ADO.Net for around 2 years now and all taught via
internet tutorials and hands on testing. I wanted to know if anyone could
recommend a good book that provides an excellent overview of ADO.Net on
issues such as Dataset transactions and concurrency. Also of ...

I came across the Microsoft Data access applicaiton block,
and noticed that all the methods in the sqlhelper class are static.
Suppose if i use the Microsoft DAL block in an ASP.NET application
will having static methods affect when muliple users use the

I need to create stored procedure that transfers data from one database to
another. I don't know how to make two connections in the same time - can I
do it in stored procedure or can stored procedure take connections as
arguments? I'm working in C# and writing procedure in SQL ...

I want to do a bulk insert of around 25k records into oracle databse .
can anyone help me out with some work arounds, I have used the bulk insert
in SQL SERVER , but in ORACLE I am unable to do.
your expert advice and support would be highly appreciated.

Using VB.Net, Framework 1.0, Jet 4.0.  Two ComboBoxes (prefixed "cbo") and
three DateTimePickers (prefixed "dtp") are bound to a DataSet (m_DS)
populated from four hierarchical tables: Company, which is the parent of
Invoice, which is the parent of both Expense and Timesheet.  ...

In the RowChanged event an added row is not in the rows collection of the
datatable.
Is there an event after the RowChanged event where the row is in the tables
row collection?

I always wished there was an efficient way to insert a dataset into a SQL
Server DB in .NET 1.0 rather than just iterating and doing an insert each
time.  Is there any method in the new framework that will do this?  Thanks!

I have to transfer data from a sql table into an access table. The
column in access is defined as memo.
Whenever I add a row where the size of the memo field is larger than
about 8000 bytes I get an error: 'The field is too small for the