In the following code, is it OK to return the DataTable, or should I return
the DataSet so that it can be disposed in the calling code?  In other words,
do I need to Dispose() a DataSet or will the framework clean it up for me?
public DataTable GetSomeData()

I have a web project produced in asp.net, vb.net and it uses a SQL
Server 2000 database. I am trying to load an xml document from data
passed in from the database in the form of a database. Below is the
code I am using and it is followed by the error message I am

I've brought in data to an ASPX page to a datagrid via ADO.Net before, but
what I need to do now is to bring in data from a stored procedure (actually
two procedures, and two result sets) and update the DataSet or DataTable.
Can I do this and bind the updated results to a datagrid? ...

how i can change a date format binded to textbox?
i have '2005-01-01 00:00:00' and i wont have only '2005-01-01'
what i must do?

I am using an oldDBconnection to do a sql insert and update to a spreadsheet.
If the Speadsheet is open in excel when the .net program updates the
spreadsheet then excel.exe lingers in task manager.
Can anyone suggest what is the fix? Code works fine if spreadsheet is not

Hello, i need some help about Database record filtering in ASP.NET through
Dataset object, how can i do filtering by using DATASET object pls tell me.
Thanks.

I'm having a problem pulling out a Microsoft Excel Workbook from a Microsoft
Access database.  I know I have the database set up correct, because from
withinside of Access I can insert and retreive the files.  What is happening
is that when I try to to them out via my code, I get ...

I have successfully downloaded the Enterprise Library and the data
access block (C#). I am able to compile and run the quickstart
application.
So I would like to try the DAB in a new project. But I was unable to

I have some textboxes in form. They are binded to dataset. When i
execute the method dataadapter.Update(dataSet,"books");
the text from textbox doesn update records in database;
what i must do to this work property

I am using visual studio with .Net and I am trying to import a text file into
a table
I have a date in this file ie
01012002

I want to read 213256 Rows into my DataTable out form a Oracle Database. For 213199 Rows it?s very fast, but for the 213200th Dataset it needs up to 2 Minutes.
Could it by my RAM!?
User submitted from AEWNET (http://www.aewnet.com/)

Is there anyway to reset a connection to SqlServer, it seems as though the
connection remains on the workstation until it is rebooted.

I am adding a datarow with the following straightforward code to an access
database:
dsClient.tbClientenRow drClient;
drClient = (dsClient.tbClientenRow) this.dsClient1.tbClienten.NewRow();

Win2k3 SP1 was recently applied to some of our unit testing machines and we
noticed some tests were failing, apparently due to sort order.
We believe there is a bug in DataTable.Select(string Filter, string Sort)
when the filter contains two subfilters joined with "AND". Our code ...

I have a DataTable. I want to find the row number (not return the row,
just find its index in the DataTable) based on a set of values for one
or more columns in the DataTable. All I have seen are the Select and
DataView functions but they return the row not the original index in