I get the error on the following line
mvCmd.CommandText = sSql
mvCmd.Connection = mvConn
mvCmd.CommandType = CommandType.Text

I want to transfer  data from sqlserver to local access database ,
and i use dataset.merger() method , but i find the accessDS's datarow state
keeps unchanged !
so i have to change some unimportant column's data,

In ADODB, the Command.Parameters.Refresh method brings back parameter information for an SQL stored procedure from the database - the Parameters collection is populated with the expected names and types etc.
Is there a way to do this in ADO.NET - I haven't found it yet ?

  The stored Procedure is
CREATE OR REPLACE PACKAGE DEPARTMENT A
TYPE CURSOR_TYPE IS REF CURSOR
PROCEDURE GET_EMPS (I_DEPTNO IN NUMBER

Many seem to say not to dig around in there too much,
but I'm in there alot.
Tweaking the Command set, bindings stuff like that.
Anyone else?

I have a transaction that adds a row in two tables. To accomplish this I have created a coarse grained method, which opens a transaction and then calls two fine grained methods (each responsible for adding a row in the dataset coresponding to a table). Individual methods updates ...

Is there something special I need to do to insert large Ntext fields?
Small Ntext fields insert/update/delete fine, however, larger one(8K+) time
out on updates and deletes.
Any suggestions would be helpful.

I wrote a Stored procedure that return me an xml
some thing very simple (select * from XXX FOR XML AUTO)
and I would like to get the XML result into some string param in VB.NET .
then I would like to take this XML String and transform it with XSL and the

We have a data access object that handles most our our database actions,
Somethimes we get this error does anyone have a clue what could me causing
this.
at System.Data.Common.UnsafeNativeMethods.SetErrorInfo(Int32 dwReserved,

I have got the following problem: i try to create a view (query) in MS Access through ADO.NET with the oledb Jet provider, i use the following code
dbCommand.CommandText = queryString
dbCommand.CommandType = CommandType.Text
dbCommand.ExecuteNonQuery()

I was wondering if somebody can give me an advice.
My problem is that I am working with an Access database, I am
succesfully running a query, binding the output of the query to the
data adapter to a dataset and to a table, then I add 4 new collumns

I can't find this documented anywhere, but it appears that you cannot
set the value of a field in a DataRowView more than once without
calling AcceptChanges or RejectChanges in the underlying DataTable.
Can anyone confirm this?  Is this documented anywhere?

Can somone please help me.  I am trying to get a ADO recordset and build a
dataset off of the recordset.  I have tried both recordset.Open and
command.execute.  I have not been successful.
Here is my code

I am trying to use my own dialect with an OLEDB provider and I am able to
connect and build the command object but when I run the command.execute my
code fails and gives the following message.
"Parameter object is improperly defined. Inconsistent or incomplete

I've created a .xsd file in VS.Net using the add>new item>XML Schema.
I created the fields and a primary key in this schema. However, when I use
the DataSet readsmlschema function I get a dataset with the proper fields,
but no primary key defined.