I have a DataTable from which I only need a certain range of the DataRows.
What I would like to do is copy a range of rows from one DataTable to a new
DataTable like the following:
For i As Integer = start To last

Is it possible to fill a strongly typed dataset with multipe tables single
stored procedure command?

Where can I find documentation for the syntax allowed in the filter used in
datatable.select("some filter")?
I want do something like this:
dim str as string = "men"

Using vb.net 2.0 I'm trying to filter a dataview.  From the code examples
I've seen, it looks correct, but its not having any effect.  The datatable
has about 250 rows of data.  after I apply the filter and set the dataview
as the datasource, I still see all of the rows.  However ...

If I use Excel to open an Excel file with 61K records, they appear instantly.
If I fill an ADO.NET recordset in Visual Basic with 61K records, it fills
almost immediately.  But if I bind the dataset to a ListObject in Excel in
VSTO, then populating the workshseet takes 20 ...

Hey guys,
I am querying a sql database for a matches using wild cards.  If I return
more than one record I want to prompt the user to choose the best match.
What is the best way to do this?  I thought I could put the matching records

Hi, i'm using an OleDbCommandBuilder to update data from a dataset to a
access database.
It work fine, but if i use a table with a decimal column data type, i
get this error, when performing the update

Is it possible to use the ADO.NET 2008 Sync Framework to sync only a portion
of a table?
Syncing the entire table is not an option for the app I am working on due to
the sheer size of the table, so I was wanting to apply business requirements

I'm migrating from ms-accss to sql server 2005 for a vb.net application.
the problem is that the queries like "select field1+field2 from table"
arereturning NULL if one of the fields is null.
I like to have the concatenation containing the not null values.

I've migrated from VS2000 (1st version of VS.NET) to VS2005,I'me having some
performance isssues
for example a query "Select * from table" that return 70000rows is taking
more than 1 min (instead of 5 sec in the previous version)

I read recently in an ADO.NET book that I should create indexes on foreign
key constraints if they will commonly be used when joining.  I can't
remember where, but I could swear that I had read somewhere else that
indexes were automatically created when you assign a foreign key ...

New to ADO.NET so apologies in advance for repeating what I am sure
has been asked been before. I have read that a data reader is much
like a Server Side cursor. I understand this but have one questtion. I
use a SQL Command object to execute a Select statement, then a data

I would like to save (and load) an entire datatable into SQL Server 2000.
Is this possible and has someone has some sample (code) for me?
tia,
Pipo

I'm using framework 2 with web application project,  one of my page have 5
dropdownlist and one gridview. The dropdownlists data are stored in SQL
Server (data may grow more in the future)
1. sector (about 4 items)

Hi;
1) Is there a url that discusses the best way to do this using ADO.NET (and
pretending it's a SQL database)?
2) Is there a url that shows the best way to access it as a cube taking full