When I create a DataSet file(xsd) based on a Sql Server table in Visual
Studio, the varchar columns get defined as string and does not have any
information about the maximun length the field can hold. Is there anyway I
can get this information in the xsd file without having to ...

I am trying to write an N-tier application in dotNET.
The layers that i think about implementing are as follows:
--> Presentation Layer - for UI
--> Business Layer - for business rules and logic

I'm not asking a question here, I'm sharing some insight I just discovered.
Consider the following [air] code.  My actual code operates on a huge table
with over a million and a half records, so I have to loop in blocks of
100,000 at a time, and the "processing" that it does to ...

I looking for alternative Data component, Dataset and Grid
That browse and edit sql tables directly, like VB6 style, with
No need to add 1 line of code?

I made connection with sql2000. I'm collecting data from database/table
(name - "Base1").
Then I'm transposing it. All is in dataset, by dataadapter etc.
I'm trying to write values to new table in the same database (name -

I am using ado.net with typed datasets and typed datatables
my question is about how to handle child / parent type tables with datasets.
For instance say that I have 2 tables with columns :
table Topic: (parent table)

Hi eveyone,
I am fairly new to .NET.  I have read couple of Csharp articles for creating
a data access layer.  One of them has been provided by Mcrosoft.  Can some
one please clarify the logical structure of the data access layer? What is

I have a DataSet, filled using a SELECT command.
What I'd like to know is, what precision is defined for decimal columns.
Example:
CREATE TABLE ...... column1 decimal(10, 2) .......

If a Transaction is started on a Command object what happens if the
Connection is closed?
As the connection is not really closed but moved to the connection pool is
the transaction still open and potentialy capable of being Commited or Rolled

I'm wondering if it is possible to display in a datagrid multiple columns
coming from 2 different tables without having to do the a join in my sql
statement.
For example, I create 2 data adapters, each doing a select on a specific

I am using a dataview to filter rows that have an 'access level' (this is a
column) less than the users 'access level'.  The dataview is created with:
       ContactDataView = New DataView(Me._stuadrk, _
                                      "CONTACT_TYPE_PL <= '" +

I've hit a brick wall, trying to get my web application to do what I want and hope someone can help.
I have an SQL database which records financials for our company. A subset of the database looks as follows:
ID ---- TradingDate ---- Loaded  ---- AccountCode ---- ItemCode ----  ...

I'm using ODP.NET for connecting to Oracle 8i 8.1.7.4 from C# Data
Access Object.
I'm experiencing a problem with ExecuteNonQuery() from OracleCommand
object.

Hello, I am a DBA at a company that is moving from VB 6 to the new .NET
environment.  In our old VB6 environment connection strings were usually
embedded in the code.  Things like server name, database, userid, password
were right in the VB6 code.  This doesn't seem to good to me ...

I have a database with  some tables that form a cyclical relationship. In
order to implement the equivalent of a delete cascade contsraint for this
situation in SQL Server 2000, I am required to do it with an INSTEAD OF
trigger at the database level (Sql Server will not allow you to ...