I am trying to learn ASP.NET while writing a system in it and am
feeling a bit overwhelmed.
I have just read most of a book on ADO.NET. I will need to write a data
access layer for this system and it is more than likely that the data

Hi,
I have a "flat" XML file that I want to convert to a hierarchy as listed on
the bottom.
The XSLT I tried works fine in the XSelerator too but is slow when using

I'm using a DataTable to hold a selection of rows (100,000+) from a large
database table (1,000,000+ rows). At times I want to remove rows that aren't
used anymore from the DataTable to save memory. But my tests shows that it
takes very long time to remove the rows. Running the code ...

I hopeing that someone is able to point me to some good documentation on
using the DataAdapter to Persists DataSets back to a DataStore. I having
difficulty in working out how all this disconnected or (loosly-coupled)
data-layer stuff works and would like some complete examples ...

Getting the following error when attempting to read in a dBase III file
through ADO.net:
Could not lock table 'Table#dbf'; currently in use by user '(unknown)' on
machine '(unknown)'.,Microsoft JET Database Engine,   at

I have a simple windows forms application which resembles a
parent-child table relationship. To be more specific, the form is bound
to a table called "Sales" and it also contains a datagrid which is
bound to a "SalesDetail" table. When I add a new record to the form and

Hi there - sorry if this is a bit long winded, but I am really stuck and
would appreciate any advice anyone has on this.
I have the following set up in a stored procedure (below) which is called
from an asp application and displays in a datagrid. The purpose is to

I have a WinForms app that builds a DataSet from an XML file.  The DataSet
is wrapped in a DataView and bound to various controls through which users
will make changes to the data, and when the "Save and Close" button on my
form is clicked, the changes persist back to XML using ...

I'm trying to display the data from my typed dataset on a page using
the Xml web control.
I have the following code:
Xm1.Document = new XmlDataDocument(ds);

I am trying to get table data from a MSSQL Function/UDF using the
OleDb provider.
The error message I get is
"The request for procedure 'FuncOne' failed because 'FuncOne' is a

I have a parent detail relationship between two tables.
The detail records are shown in a datagrid (GridRemarks)
It is databound like this
GridRemarks.Datasource = mainDatasource ' a shortcut to

I need to perform some aggregate stats on an ado.net dataset.datatable
(which just contains numeric data), nothing too complicated, just eg:
** max and min values in a column
** row index of where the max and min occurred

I am exporting excel worksheet values into datatable. When there is a value
in the excel cell which has more than 2 decimal places, for example say
123456789.123, the datatable truncates this to just two decimal places
(123456789.12) losing the the third decimal place. Is there a ...

Can any one guide me to fetch data from excel sheet using vb.net
Reagrds
Reny
---

I am updating several excel worksheets using ADO.NET (OLEDB objects).  Everything is working fine except all the data is inserted as text despite being typed in the DataTable object and when the Excel worksheet was actually created.
If the user-specified Excel Workbook does not ...