How can I SELECT a column data whose name is using one of the reserved
keywords?
For example "Authorization".
Anatoly

I have a vb.net application. Using ado.net, I create/open a connection,
create a transaction object, and go through a loop. In each interation of
the loop, I create a SqlClient.SqlCommand (using this transaction object)
and perform a cmd.ExecuteNonQuery using a SQL Update statement. ...

Hi - getting the following error occasionally - does not seem to be tied to
any particular user activity - this and the lack of a stack trace that goes
back into my code leads me to suspect that it is due to garbage collection.
I'm not explicitly doing any disposing and I am ...

Is it possible to get a view of a DataTable that contains all the rows
except those that have been deleted?
I guess I could easily loop through the DataTable, but is the a better way
to do this?

I have a question about inserting records into Multiple tables in both a
dataset and database.
Currently I have a dataset created from a database with 3 tables.  The
Database (ClientName) generates the ClientID and the other two tables

All the code I've seen for Parameterized stored procs seems to think that
the developer knows the parameter names at design time.   I've got a
situation where I have a hashtable of possible parameters, and an unknown
stored proc name.  Is there a way to Automatically create the ...

I'm performing a simple one row INSERT of some data into a table but need to
get that rows first column fields' value, its the first column which is the
Indentiy and Indentity Seed. If this is not in a SP (I'm using Sql Server 2k)
how can I accomplish this with a normal asp.net ...

Hello Group
I've a Dataset with 3 tables and their relations (ej. Customers, Ordes,
Invoices)
How can I find the parent row, when I'm searching by and order or invoice

Dear NG
A prerequisite to handle dbconcurrency when using DataAdapters and Stored
Procedures is to SET NOCOUNT OFF in the an Update SP for example. As a
consequence, when the update statement fails due to a concurrency issue, the

I have a DataTable from which i want to filter out some records. For that I
create a view and I apply a first set of filter condition.
Later in my processing, I would like to use that view again to apply a
second set of filter condition. But i don't see any constructor for the

I want to filter out all the records of my Datatable based on the Column whose Datatype is Datetime....................What will be the Rowfilter string.......I tried with..
"Isnull(ActualCloseDate,'') = ''"
"Isnull(ActualCloseDate,0) = 0"
But no success...........

I am passing an ADODB.Recordset (rs) into a .Net C# dll.  I need to fill a
dataset using Oracle.DataAccess.Client.DataAdaptor.  
OracleDataAdapter da = new OracleDataAdapter();
DataSet ds = new DataSet();

is it possible to fill a dataset such that it can be done in increments?
for instance, if I have a large table with a big schema (like 50 columns -
for whatever reason), could I fill a dataset table with a partial query like
(via a dataadapter

for ADO.NET SQLParameters with SQLParmaeter.Direction =
ParmeterDirection.Output ....
apparently , contrary to the documentation , you DO have to set the
SQLParameter.Size property ...

Hi;
When I create an IDbCommand.CommandText select string, all of the examples
show using @name for SqlServer substitution and :name for Oracle substitution.
I don't know Oracle well so I may be doing something wrong. But it appears