I have to get a stored procedure to produce a result set then loop
through it and insert records into another table in the same db. What I
have written is causing SQL server to hang or some other performance
bottleneck. Here is the code. Anybody got any ideas? Thanks!

I am new to .Net, ADO.Net and OOP programming. Have plenty of
experience with VB6 and DAO but now need to move on. Here is my simple
question:
I want to create a procedure or class that will handle the creation of

I am hitting an AIX UDB 7 Database, and the problem I am having is that I am
not receiving what columns are the primary keys.  I was previously hitting a
Mainframe DB2 database and it was working.  Any clues.
I am trying to run these commands to retrieve the primary keys.

I have two tables and one has a relationship to the first table primary key
which is an autoincrement field. So After I add a record to the table 1 I
need to get this autoincrement field so I can add it to table two. How can I
do this? I am using access database. Is there a way to ...

A few days ago, I started a thread on abstracting connections and
commands. Based on the input and further study, I think I have learned
a way to do some of what I need based on using Interfaces. Below is
untested code (I am still awaiting my copy of VS to begin actually

I have what I feel should be a simple operation, but I cannot seem to
get it to work.  I have a table from a dataset that is bound to winform
controls.  I would like to add a record, set some default values, and
the allow the nuser to edit the data.  I am successful in adding the

I have a dataset that includes 2 datatable with a parent- child relation.
so i have 2  dataadapter.
when i update the first datatable with first dataadapter,
my second datatable's rows' rowstates change from "Added" to "Unchanged".

I'm retrieving CSV-file like this way...
Dim strFilePath As String = MyCSVSourceFilePath
Dim strConnStr As String = String.Format( _
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended

   I'm using ADO.NET to update a table in an access database.   The table
contains the following columns,
   id    =    auto number
   filename = Text

I'm calling a store proc in my vb.net code, but the value returned is
always 0, which is wrong. But when I runt the query in SQL, it's working
fine. My SP is
CREATE PROCEDURE [dbo].[max tableid] AS

I cannot seem to figure out what property do you bind the data to in a
radiobutton ?
I thought we would have to do it on the group box, but group box has only
text & tag properly.

I have the in famous multi combo on the form bound to the same DataSource
Issue.
I have a dvLookup which is used in multiple comboboxes to do the lookups.
How because they are all having the same DataSource: dvLookup, they have the

Does anyone know if there is a planned support for MS Access in the MS DAAB?
Thanks,
Jos?

From a VB.NET app, I would like to call a stored procedure which prints out
a few lines of information with the "Print" command.
Is there anyway to read this data from the VB interface?
Thanks,

Why is this not working (i.e., it leaks a connection EVERY TIME)?
<code>
Imports System.Configuration
Imports System.Data.SqlClient