Anybody know where the Data Access Application Block is located on the MSDN
site? The Data Access and Storage Developer Center is located here:
http://msdn.microsoft.com/data/default.aspx
On that page is a link to the app block, but clicking it redirects to MSDN's

Im trying to create a connection to A database in Visual Studio.Net. I
select Tools->Connect to Database. Nothing happens. Im trying to connect a
data source to my datagrid, but not even able to connect to the database I
want to.

My application uses a simple source control system implemented in SQL Server
2000.  The file is contained in an image field in a table.  When a user
wants to edit the file, the a new file is created on the user's hard drive
using data from the image, and a foreign key into the users ...

I'm trying to open an Access database using OleDb.  The database opens fine,
but when I try to open the database using a workgroup file with a name and
password, I always get the same error:
   "Cannot start your application. The workgroup information file is

I am using ForeignKeyConstraints so that when I change a parent row's key,
the child rows are updated with the appropriate key.
The problem that I am running into is that I would like to be able to add a
row to a table with a value that would not fit a stated constraint.  So, I

I have a dataset with data retrieved from an Access2K database and I am
trying to change the MaxLength property of one of the text fields.  The code
executes fine (e.g. myDataset.Tables(0).Columns(x).MaxLength = 50), but the
value of MaxLength doesn't change!  Can anyone explain why ...

I have an ASP.net page that uses an "asp:DataGrid" tag that is populated by
a System.Data.DataSet object.  Data is sorted via a "sort_value" field in the
SQL table.
Until now, this page has just been for the display of data.  Data entry is

I have a database with two tables. One is called tblMainCategory and the
other one tblCategory. The tblMainCategories has fields Index1 and
MainCategory.
The tblCategory has Index2, MainCategoryId and Category.

I read in a book that a program can connect to a database using two
different types of connections to a database. In case the program can
maintain a direct connection, classes such as OleDbConnection, OleDbCommand
and OleDbDataReader can be used.

I have a Datagrid, and I want to limit the Lenght of the text in a certain
column to a certain number of characters (for exemple 10).
What I want is that, when the user is typing in the column, that he can't
type more than the 10 characters (not that they are concattenated during

I have a stored procedure that is being called from ado.net and it is
failing with an exception that is related to the option ARITHABORT - 'UPDATE
failed because the following SET options have incorrect settings:
'ARITHABORT'.

When using SqlCommandBuilder, if one of the columns, of
the subject table referenced in the SELECT query, has a
column name that is an T-SQL reserved word, such as User,
the T-SQL command text for the adapter will be incorrect

I'm looking for options in handling a certain data situation. Data is stored
in Oracle.
There is a database that contains tables with common information. For
example, it contains a table called USER_COMMON. This table has a key field

I have the block of code below which is supposed to determine the
number of rows affected with an update statement (ASP.Net, Access, C#,
ADO.Net, OleDB) to determine if the update was successful or if a
concurrency error occurred.  There is an enumeration defined called

I'm fairly new to .NET, so bear with me if this question is naive. But do
most developers use the VS data controls for connections, adapters, and
datasets, or do you write all that code manually?
And if you use the controls, how do you wrap your connection and adapter