I have one web project in which I have OleDb Namespce listed with
intellisence and in other projects my variables have to be declared using the
entire namespace (i.e. System.Data.OleDb.OleDbConnection).  
All projects have sytem.data.dll reference.

I have a question to ask.
I have one Dataset with two Datatables (Customers, Orders) and a
DataRelation between these tables. I would like to ask If it is possible to
create a datagrid in a window form (VB.NET for example) which shows the

I have a feeling this is very basic, and something I am just overlooking.  
The dr.Read() ALWAYS is being translated to false in the code below.  I print
out the sSQL statement using the watch window, and paste that into Query
Analyzer:  and I confirm the data does indeed exist.  ...

Why is it when a new row is added in the datagrid and the user clicks a save
button that GetChanges() returns null unless they move to another record
first?

We have a wide typed dataset and we profiled our app that constructs it
many 1000s of times and it turns out that the constructor is the most
expensive part of our app. We dug in deeper and it seems the
constructor spends most of its time in the datacolumncollection and

I am looking for a way to programmatically determine the parameter list
of a storded procedure. In classic ASP this could be done using
cmd.Parameters.Refresh. How can this be done in .NET?
Thanks,

Is it possible to connect remotely to access database? If is, how? Any
idea is appricited.

I have reached my wits end with this and am in need of help!
I have a webservice that returns a dataset.  I want to take this incoming
dataset, add a field to it (storeID), then merge this dataset with a seperate
dataset from a master table that contains the exact same fields, ...

I have several applications that were using the old VBSQL controls to
communicate with SQL 6.5. I needed to get them to SQL2000 and instead
of rewriting the entire applications to use MDAC or such, I wrote an
interface that emulates VBSQL to the application and redirects all the

i need to rename a table in a access database, within ado .net.
is that doable with a ExecuteNonQuery sql command applied to a
OleDbConnection, if so what
would the command be, i can't find any documentation for it?

How can I reset or change the value of autonumber in MS Access ? Doesn't it
have the function like NEXTVAL or CURVAL as in Oracle ? Or is autonumber
field more rigid ? Or is it possible to make sequence in Access so I can
manually do it ?

I have a Solution with 3 projects:
1- Data Access: A library with all class to acces to the DataBase
2- A Windows Forms Project that uses the library 1 to view data from the
Data Base.

I am still struggling to understand the usage of Interfaces in an
attempt to make a provider independent data access layer. My question
is this...if I create a connection from an interface that is specfic
to a data prvoider, will the remaining objects created from interfaces

Is there any way that I can run an ADO.NET query in SQLServer to do a
bitwise OR operation on a particular column for multiple rows?
i.e., Select OR(ColumnName) from Table

Having problems with retrieving data from MS Access through a dataset
with multiple tables.
It works fine when I'm only using two tables in the dataset, but when
I want to access data through a second table (three tables in all) it