Is there any advantage of always calling SqlConnection's Close method after
done using it vs. just let it go out of scope open and hope the garbage
collection will take care of it?
thanks!

I need a help in Crystal Report?!
When I'm using Crystal Report Command Based Report that include Graphs and
Grouping and then change the report command using
report(OBJECT).SetDataSource(Command) it doesn't retreive the correct sql

When I use query builder  connected to Oracle 90i and I use views instead of
the table in the query builder design grid I get "Data type is not
supported"
However If I use the same exact query and connection in the code behind of

I'm trying to create an .aspx page in C#, and it needs to read information
from SQL to radio buttons.  I'm not sure how to read information to radio
buttons and how to submit the .checked or not checked to a database.  i think
i can figure that out, but reading from an sql and ...

Hello, generally, is it better to quickly open and close ADO.NET a few times
or open the connection once. Perhaps my understanding of pooling and
disconnected data is not where I'd like it.
An example is let's say there is an ASP.NET page with a page_load event and

Respected Sir,
In respect to input and output to Stored Procedure.
we can pass as indivitual parameter to the SP's for insert statements from
.net.

I am using visual studio 2003.  I user the server explorer and drag a table
onto a webform.
The program creates a "Connection" and an SQLDataAdapter  Generates the
"Select, Insert, Delete" statments.

Can someone help me? I'm not sure about the code below. It's working but... . I create a new OledbConnection, opened and called a method. This method creates a new OleDbCommand that use the connection (via another class; cn is a member in an data class). But the OleDbCommand is ...

Hello, (sorry for my english).
I'm trying to build an oledb data access generic class and would like to get
the value of an identity column for any oleDb provider... I have seen so many
specific examples for ms-access, sql server, oracle, mySql... Can anyone tell

I have posted around this issue before, and am still looking for a soultion.
There are several situations where we have tsql code that could generate a
sql error but still need to return a recordset or print statement that
occours after the error.

i am testing this technology and looking for a good example that works.
http://www.perfectxml.com/InfoPath.asp is the best i could come up with, but
has problems submitting back from infopath to the database.
The access db i am testing with has only one table to simplify the issue.

I want to use excel as my data source instead of sql server. because,
sqlserver is a bit pricy for some small customer, and also a bit for those
people not good in computer. So some of my client prefer to use Excel to
maintain their data.

This is driving me nuts.  I have found plenty of newsgroups that discuss this
subject and not one of them helped.  I have tried multiple connection strings
to connect to a database on another computer.  The current string
erver=hostMachine;Database=hostDatabase;User ID=sa ...

I'm using   theDataSet.WriteXml(...)   to write the DataSet to disk. After
that, when I read the DataSet from disk  (theDataSet.ReadXml), then if there
were tables with no records, they are gone. Same for table columns that
contained only null values, not there any more either.

I am having trouble adding a new record to an access database
Error is 'Syntax error in INSERT INTO Statement'
Updates are OK
Here is the code