I am new using ADO .Net, and my impression is that
the client always tries to retrieve a collection of data
to process. There is the case in which a single value is expected to be
retrieved, and I do not know how to do it using ADO .Net. Can somebody

A part of our system deals with using DataViews, and it appears that the
RowFilter property (DataColumn.Expression syntax) does not support the
following:
1) Bitwise operators

I've created a windows application with the follwoing code, and it works just fine:
 string strConn;
 strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
    "Data Source=" + System.AppDomain.CurrentDomain.BaseDirectory  

I have seen this question posted before but never answered.
If I load a DataSet from a database query, I need to call
AcceptChanges after DataRow.Delete to remove rows.
If I load a DataSet from an XML file or create one from scratch

I'm using an Access database in a .NET C# solution... I have a
document table and I have to insert documents in this table. The first
time I start the application I have to insert a datarow in the table
describing this document, but then the user can modify it and when he

I would like to have a functionality that saves/updates a given DataTable
into the DB while its structure is unknown.
I think of 2 possible solutions:
1) to use SqlCommandBuilder - which is very expensive in the runtime

I need to formulate a query that tests that a field is a member of a
list of acceptable values, but can't figure out the mechanics. Say we
have a table with a column containing an ID. I have a list of
interesting ids in my application, for which I'd like to write a query:

Lets say I have a query like this one:
SELECT column1 FROM table WHERE column2 IN (2,5,8)
How do I substitute the 2,5,8 values with @ parameters and sqlparameter
objects? Is it possible?

I have seen in msdn article that if the SelectCommand of the dataadapter
retrieves results from an OUTER JOIN the DataAdapter will not set a
PrimaryKey value for the resulting DataTable and we need to explicitly define
the primary key for the table.

Help!!
What are the best concepts / startegies to deploy an ASP.NET web
application? My idea is work first in Production PC then after completing
the project deploy it on the Web Server. But what about the database - do i

Sorry if this is too basic but I've been banging my head on this for some time now.
I'm using Visual Stucio 2003, VB.NET.  I'm able to build a win form with an OleDBConnection, DataAdapter and DataSet against an Access 2003 database using Jet 4.0.
I'm able to browse, move forward, ...

How Do you clear the command window?  I run a program and type in commands
in the command window for various reasons and wnat to clear it and I can't
delete the old stuff whether I'm in design mode or debug mode.

I know this is not the correct ng for this, but the ms access ng's are
pretty dead.
I need the terminology for 'drop procedure' and for 'alter procedure ....
as'.  These expressions fail in ms access 2002, but 'drop query' or 'alter

Just applied SP1 for v1.1 of the .NET Framework, and we're receiving
the following error message when closing a SqlConnection, that has
been manually enlisted in a distributed transaction:
An event was unable to invoke any of the subscribers

Using VB.Net 2003 and ADO.Net 1.1 and the MS DataAccess application
block 2.0:  I have a stored procedure that returns back records when I
run it manually for a certain record, but in the program executes, the
DataReader.HasRows = False.