I am new to vb.net using visual studio.  I'm having a hard time trying to figure out the new syntax for vb.net
The following is code is what I'm trying to create in vb.net
   Set cnGblBatch = New ADODB.Connectio
   cnGblBatch.ConnectionString = "Provider=SQLOLEDB;Server=;Database= ...

I need to get the raw xml of a specific DataRow (and all of its child
elements) as a string but I've got no idea how this has to be done
*properly*. Any idea would be highly appreciated.
Cheers,

Hi gang,
I need some SOLID direction here.
I am planning to use DataSets and DataBinding in an app which will have a
few users (VB.NET / SQL Server).  I need to be able to create an 'offline'

Question
Why DataAdapter.Fill does not refresh the deleted records in the dataset?
If this is by design then how can I refresh the data and get rid of removed
records without actually refilling the dataset with clear and fill

I understand that ADO.Net has some dependency on MDAC 2.6 or later
(from MSDN documentation). Please correct me for the following:
"If I am going to use either System.Data.SqlClient OR
System.Data.OracleClient namespaces for data access, as they directly

I create a dataset  using a  sql dataadapter fill method - da.fill(ds,
"myTable"). I want to know how many rows are in the table but I can't find
the correct property. I've looked through the dataset options and the
adapter but am not seeing a way to do this. Any suggestions ...

When I use the following expression
DataBinder.Eval(Container.DataItem,"PM_CUTOFF_PERIOD", "{0:MM/dd/yyyy HH:mm tt}"
It displays my date and time as follows
05/18/2004 14:00 P

I'm trying to read records from a main table, along with data records
from dependant tables into a SQLAdapter.  I will then need to make
some changes to certain field data.  I will then need to insert these
records into another database (with same structures).  Can some one

I have a stored procedure that does some math for me. I've aliased the
calculations and was wondering why I could not use those in a dataset? The
sp runs correctly and returns the alias names, but if I fill a dataset with
the result, I get no columns in the datatable. Is there ...

I have a table in a SqlServer database which contains a couple of
DateTime fields, 'StartTime' and 'EndTime'. These fields are only used
to store time, not date. Since I don't specify any date information,
all the records have '1/1/1900' for their date.

I am trying to update a row in my data-adapter after inserting to a parent
table.
Scenario:
TableParent

I have an existing Dataset, can I create a new Dataset using the existing dataset with a new Query.  I want to query the existing dataset into a new dataset. Is this possible?

Why do the commandbuilder classes not derive from an interface or a base
class?
Every other ado.net object seems to do so.

I have an asp.net application which allows users to search, create and update records in a SQLServer2000 DB. Search results are displayed in a datagrid
The problem is after a record is updated or created and the datagrid refreshed by the user, the newly updated record doesn't ...

I am having problem designing my business objects to retrieve data from a
SQL Server.  The data structure is very similar to Northwind (Order-Order
Details...) however much more complex.  I was looking at using inner joins
in a complex SQL Select statement however there are too many ...