I am using DataSet to store Sql Server Data in my ASP.Net application and
use it in several .aspx forms by saving it in Cache. In one of the forms, I
need to filter one of the tables in DataSet and display the result in an
Editable grid. I do this by creating a DataView by ...

I am trying to create a DataSet with DataRelations. The problem is I don't
want all the rows in the related tables.
A sql statement of what I'm looking for is:
SELECT ParentTable.*,ChildTable.* FROM ParentTable

I have an Oracle SPROC which takes as one of its IN parameters a table array
(e.g. type charArray is table of varchar2(255)...)
How can I call that SPROC and pass it the table array from ADO.NET?
Thanks.

I am noticing that the methods in MS's data application block are all shared.
Any implications for performance with this? Seems like if users are sharing
methods, we could take some sort of hit if they are accessing the same
methods.

I am getting data from a SQL Server 7 table and binding it to a grid.
I have a field that is supposed to represent a date, and two fields
that are supposed to represent time.
When I look at the grid the date value is just the date (because I

I want to append data into Sql Server from xml file in tree step
1. A user uploads an xml file in a Web Form
2. A Dataset object read the xml file with the ReadXml method.
3. The Dataset append its record into SqlServer one by one in a loop.

The DataTable has a column containing integers.
Filtering it as   "Where ColName=12"   filters fine.
Here is the problem. I want to filter the integer column using "Like". For a
string column the following will work "Where StrColName Like '12%'".   I

i recently encount a strange problem.
first , i successfully insert a record to db, but when i try to update this   record, i always get a
DBConcurrencyException exception.
but when i change "using System.Data.OracleClient" to  "using Oracle.DataAccess.Client", everything is OK.

I need to obtain an mean value of Width column in a Dataview.  I can walk
through the Dataview (see below).
How do I extract the values from Width column in the Dataview so they can be
added together?

Visual Studio Enterprise 2003 and DotNet Framework 1.1.
I have a strongly typed dataset (generated by the Schema Designer).  This
dataset has a table called Category and one of the columns in this table is
called "ParentCategoryId".  There are no explicit relationship set between

I'm using a bound control, a textbox bound to a column in a dataview.
Despite setting the AllowEdit property to False, changes in the text in
the textbox are saved to the dataview and underlying dataset. When using
the update command of the dataadapter these changes are saved to ...

I read David Sceppa's ADO.NET book, and in particular I have read his
methods for retrieving timestamp and autoincrement values from both sql and
access databases... I am using his method accept that in my simple insert
scenario I am not using a dataAdapter and a Dataset, and ...

I used OleDb.OleDbDataAdapter to retrive and modify the access
i used merge function to combin another dataset, then update Access DB
but i can't update the database by using pDataAdapter.Update(ds_data)
the result is always 0

Try to setup a .net web application to access an Oracle 10g database.
All the technology is new to us, so if I sound simple it merely means
I am ;)
Anyhow, the problem is, that when I try and call the Open() procecdure

I have a table with a DateTime column. I have a SQLDataAdapter which queries
the table and then fills a TypedDataSet. The DataAdapter has a parameter
value in the DateTime column.
I want to find all the rows with nulls in this DataTime column.