I'm quite new to ADO.NET programming, so please forgive me if some of my
questions sound dumb or are just FAQs, but I'm trying to develop a DB-based
application and I'm getting a lot of problems; maybe I'm just missing some
important point... so any help would be appreciated.

Greetings all,
Here's my situation:
Background: I have an application for that has company data and survey response data.
The survey questions, answers and responses are being stored in the database.

I have a question about validating user input, which the user can enter in a DataGrid. I use the rowchanging event of the DataTable to which the DataGrid is bound. In this rowchanging event-handler, I check the column data of the row, and if not correct, my own exception is ...

Transaction won't work.  I'm trying to insert a new row in four related tables.  The first uses an autoincrementing integer as it's primary key.  I recover it with the standary @@IDENTITY handler.  In turn, it is part of the primary key in each of the other three tables
I tried ...

Run the program below to duplicate this..
When you enter in a row (enter test in both fields in datagrid and press enter)
The  dataTable.RowChanged  event is triggered,
the action is Add

Will a filter on the parent table in a DataRelation propagate the child in
the relation?

I have a major question.
I have several tables in my SQL-DB with several relationships (without update/delete cascade) like for example:
- Customers
  |

I have populated a data table (dtHeader) from a SQL database using a SQL
Data Adapter. I have an Access table (header) with the same fields as the
SQL table.  I want to populate the Access table with the data in the data
table. The data table contains information from multiple SQL ...

I have a DataSet with an existing DataTable that was created at design
time. At runtime I want to fill the existing DataTable with data from
a DataAdapter. When I call
MyAdapter.Fill(MyDataSet, 'MyTable');

Is there any automatic stored procedure generator to generate up_insert,up_
update, up_delete stored procedures for a table?
Thanks,
Ali

We are receiving errors whey trying to open a SQLConnection to Sql Server
from an ASP.NET web application.
Error Description: Unable to get username from token.
Source: System.Data

How can you get the SQL DATA TYPE of a column in a DataSet. Now I am not talking about the System.Datatype but the SQL one. I am connecting Via SQL Server 2000
Under the Column dataType property (myDataSet.Tables("TEST").Columns(i).DataType.ToString) I get the System Type's such ...

I am creating an application in .NET (Visual .NET)  and  I need to connect a
PC to a AS/400.     I wrote my code and compile, but when I am executing the
programs I have  problems trying to reach the data stored in my
oledbdatadapter da.fill(dataset).  If I use a recordset it says ...

I'd like to design using C# a universal data connector dll that I could use
to access SQL or Oracle databases
from my existing apllications. It should be really generic. Accepts
parameters for server name, database name, SQL command, login name, and so

One of my web applications throws a SqlConnection exception occationally,
with the message saying unable to obtain a connection, and it may be due to
max connection pool size has been reached and there is no more connection
available.  How can I find out (and change?) the max ...