I am getting this erroor  on transaction.commit
"stack overflow"
on transaction.rollback i am getting this
{"This SqlTransaction has completed; it is no longer usable." }

Perhaps this is the wrong group - but having no luck. My source is
below . I am able to add and delete with similar code. I get no errors
messages.  Displays look good. thank you for any help or information.
<code>

Anybody have idea what is the best method to search in the access database ?

Hi all...
I have an ASP.NET application that is using the managed provider for
Oracle (i.e. System.Data.OracleClient).  One of my pages contains a
query that takes quite a while to run, and results in a timeout error.

Is it possible to update a dataset/dattable/dataview disconnected, without
looping?
Situation:
I'm performing a conversion.

I'm Working on generic DAL component which can deal with all kind of
providers like SqlClient, SqlCe, OleDB, Odbc.
I was wrapping the command object with my own class that inherit from
IDBCommand and this class is holding instance of real command object (like

In the past I used SqlCommandBuilder and SqlDataAdapter .Update method to
apply changes in a DataTable back to its table source in SQL Server. It
worked fine when DataSet had only 1 table, this time I have 2 tables in a
dataset and I want to update them all at once. However it only ...

I installed the Community Starter kit earlier today and fooled around with
it. And I also reinstalled the dot net framework sdk. I already had MSDE
installed as w2000\netsdk, but have it disabled, set for manual startup. I
have sql server 2000 installed as default (local) and always ...

I have a DataGridView with a textbox column which is bound at design time to
a DateTime field from a database.
Also at design time I set the Format value of this CellStyle like "yyyy", so
that I only get the year displayed.

I'm getting a syntax error on the following stored procedure and I need
another set of eyes.
It's bombing at the @SurveyNameID=SurveyNameID line
Any help would be appreciated.

I'm writing a html file upload using Visual Studio and asp.net VB and using
code behind. The vb file is not reconizing the html elements as it does the
<asp: element. I know the studio is generating the references for the asp
item and not the html items. How and where do i define ...

I am using the MSDE 2000 and ado.net. When I use the sqldataadapter wizard it
won't generate some statements unless the primary key is designated. I tried
using char, nchar, int, sql variant, and nvarchar.When I use these data types
they allow a primary key and so the sqlwizard ...

I can't get the below update to work. Here's what I know..
If I enter fixed strings in the update it works. The response.write
displays show good and updated values in the s strings. However, only
the @chain cmd.Param gets set, all others,like @responsible either

Every one has different SQL database path.
How do you make your application adaptable to this.
Is there a way a program can automatically search for sql server on the
network?

If I derive a [Serializable] class from DataSet and add a value-type member
to it, then that member is serialized (using SoapFormatter) without a
problem. However, if I add a reference-type member it does not get
serialized, even though the class for the member has the ...