i have a Dataview with 10 rows.Each row has a different "category" value, but this is not the primary key. to access a particular category i do the following
dva.Sort="CategoryID"
DataRowView[] drv= dva.FindRows("2")
the array will always be 1 row so ill get the row i need.  howver, ...

Been thinking of using one of these freebie, or for a small fee O/R sets of
components, and wondered what the general view was.
Obviously I have considered the MS Appplication Block flavour, but wondered
if there was anything else out there worth looking at.

When I create a datarelation between two of the tables in my dataset, it
creates a key on the appropriate column of the parent table. Am I wrong in
assuming that a PK column cannot have Null Values? And if they can't, does
that mean you must have at least one child record for every ...

This is my first attempt at using Dot Net. I am using WebMatrix to
create the web pages.
I created a data page using the editable datagrid template, and am
able to modify and delete data.

I've a OleDBConnection to a Microsoft Access Database. However when I call
the Close method to close the connection to the database, and then doing
something with the database file, it says the database file is still in use.
It seems that it happens not only with Access but other ...

Win2003 and VS2003 using ASP access to SQL Server msg: Login failed for user 'NT AUTHORITY/NETWORK SERVICE'.  I added IWAN as a login and user to DB that I am accessing in my app and still get same msg.  I must use integrated security.  I have looked at all the related issues ...

I have a dataset that I create using an XSD file.  Ultimately I serialize
it to the file system.  Prior to the serialization call I call
AcceptChanges on the DataSet to make sure I only save the current records
and minimize the size of the serialized file.

Is it possible in ADO.NET like Virtual Recordset in ADO?
if possible please help me how to do it
Navan M

I have some troubles with a computed column in a DataSet
I have a typed DataSet ds, which is received from a WebService ws. The Table BestillingslisteLinie has one child-relation to the table BestillingslisteLinieKommentar
My computed column is added to the table ...

I Restored a MSDE database--with a prior backup.  Now my program won't
connect to it.
I use SQL Security.
Any ideas?

When I call .ToString in order to return the class property values, is there
any way to return the values discretely? I want to return some values as
integers and some as strings. Is there any way to pull these out one at a
time?

I am facing misterious problem while setting up RowFilter property of
DataView.
It works find when i do
dv.RowFilter = "StudentName like 'Dave'"

Hi,
I have a page, I put a web table control on it (design
time).
Inside this page's Page_Load method, I use LoadControl

When I create a table in the database with:
cmd.CommandText = "CREATE TABLE pmdb.wolist (SITENUM NVARCHAR2(5) NOT NULL,
VELD1 NVARCHAR2(100), " + _
"VELD2 NVARCHAR2(100), VELD3 NVARCHAR2(100), VELD4 NVARCHAR2(100), " + _

Can anyone give me "the" best way (or at least the intended way) or loading
a single row into a dataset
then updating it.
You surely don't have to fill a dataset then only update a single row