We use ADO.NET / SQLProvider against SQL2000 for our web application.  We
have started to see more and more of these errors:
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection

I'm currently programming an ADO.NET application for SQL server.
I notice that the SqlCommand.Paraterers.Add() method require 4 parameters
which are parameterName, SqlDbType, Size, and SourceCOlumn. The question is
with Size parameter:

in a network-winforms-application based on a access database I've got
the following problem:
user A starts software
user B starts software

I'm using the ADO.NET 1.1 framework and have this ADO.NET dataset I
want to use to add and/or update records on the physical SQLServer
table it came from.  I am using an ADO.NET commandBuilder to
automatically generate the update and insert SQL commands.

All:
I am running a stored procedure via code but need help with the sytax for
the output parameter as mine is wrong, Sorry, but I am just learning.
Here's my incorrect section, more is listed below:

I'm using this query
Select Distinct(prj.Name) as PrjName, prj.oid as PrjOid From
SITE61.PRJMGTProjectRoot prj,
SITE61.CORERELATIONDEST ic, SITE61.PRJMGTDatabase pd

When I sort a number I get a lexicographical sort
1
11
112

Greetings All, I am writing a small test app in C# .Net 2.0 that needs
to connect to an Oracle 10g database.  I need to use Microsoft's data
provide System.Data.OracleClient to connect to the database and I need
to connect as "SYS."  There seems to be no provision for connecting as

Hi friends, how ru all,
I have a question about creating Data Access Layer and Business Logic Layer
using ASP.NET 2.0 and VB.NET, which is the best way, and what is that best
and optimized solution for creating DAL and BLL.

In ADO the preferred[1] way of specifying the connection string was using
an .UDL file.
What is the preferred way to do this in ADO.NET?
// Anders

System.Transactions: TransactionScope and CommittableTransactions leave open
transactions on server.
I'm having problems with commited or rolled back transactions leaving open
transactions on the database server.

I've recently made a name change on a few database tables.  I thought I
got all the name changes done in the front end reference.  However,
this one eludes me.  I've checked all the classes listed in the error
trace.  I've done full text searches across all the documents of the

       YO...., I NEED SOME HELP HERE !  Actually, I got some info from
a good guy called ScottT, but I need more. You see, I'm kind of stuck
in here.
                       I need to connect two forms. But the problem

I have a hard time recalling what was the basic rationales for using structs
instead of classes in a C# program. Could anyone point out the reasons?

I have a solution - just a test one - where  there are two projects.  One is
a simple windows form with a text box called txtClient & a command button.
The command button eventually calls a SP that has a parameter @ClientName.
The other project is a class library that has a class ...