I am trying to use Crystal reports to create a report for a dotnet app I am
writing.  Crystal reports only works with type dataset, which is where I
have my problem.
I know how to create the typed dataset if my data is comming from a database

I have an application where we use the OleDb DataLinkClass dialog to
retrieve the connection string. In the advanced tab one can set the
connection time. I set it to any value but the dialog always returns
the default 15.

I have 3 datatables under a dataset .  They have the same columns and were
populated from the same excel sheet.  I would like to move the info from one
column in a datatable to another column in another datatable.  I have
already defined a relationship between these three tables. ...

Hi people I have a question about that:
Nowadays I'm using the Update Method from DataAdapter but i figure out that
it generate multiples roundtrip to my dbserver so i want to use XML to send
all my data to SQLServer and process that in just one travel :P

Sorry for the spam, but I thought some of you might be interested on this :)
Next Thursday we'll be hosting a webcast on DataSets. The speaker will be
Kawajit Bedi, the Program Manager that's responsible for DataSet and "the
man" for DataSet-related stuff.

I have a similar problem to several other people who have posted here - I can only open up to <Max Pool Size> connections.  After that I get a timeout expired exception.
Looking at the open / pooled connections in perfmon (in both SQL Server stats, and the CLR runtime), there are ...

Dim Parameters As IDataParameter() = { _
             New SqlParameter("@StudyID", StudyID)}
...Do some processing here
'point to nothing

Howdy,
I recently implemented an ASP.Net application and am having trouble
with running out of database connections. I've read many articles on
the web concerning pooling, but have yet to find one that really

This sounded like a really easy R&D challenge but .NET is leaving me
with too many options and I don't have six months to experiment and find
the best one. Hence I would like to lean on this board's expertise.
Environment is C#/.NET/SQLServer2k/VisStudio .NET.

I have a program that invokes the following block of code every x
seconds.  The process private bytes keeps increasing after every call.
I've try to dispose the SQlDataAdapter in the finally block, but did
not work. If I invoke the garbage collector manually GC.Collect in the

guys i need some help here. what was working somehow has has stopped. the drive in the machine i was using died and was replaced, so i had to re-install SQL Server.
i was developing on my laptop with an instance of sql server using the conStr of("Data Source=(Local);Initial ...

What is the proper way of working with typed datasets in a 3-tier
environment? Should I use a common assembly for the typed datasets that can
be referenced in the presentation layer, business logic layer and the data
access layer? I really don't want to add a reference to my data ...

I want to copy a dbf file to the the access database.I thought of two
solutions
1. Copy the dbf to the access db by the query
SELECT * into dest_table from [source.dbf] in 'source folder'

Okay, so we have a new Isolationlevel for transactions in ADO.NET - the
snapshot isolation.
That exists at System.Data - which leads me to believe that nothing really
stops me from setting that isolation level on Oracle.

I'm developing an application works with SQL Server.
I've installed MSDE in my PC. When I run it on my PC everything works fine,
but when i try to run the application in another PC (Win XPP) this error
message appears: COM OBJECT WITH CLSID... IS EITHER NOT VALID OR NOT