I've been on a mission this past year to move from VB6 to .Net. I'm
fortunate(!?) not to have the big catalog of some long-time VB developers,
although I have some CE apps that have to be entirely rewritten in CF. A lot
of what I develop has to be written for the PPc, so I knew I ...

Hola grupo,
Tengo un programa que transfiere datos de Sqlserver a Oracle, primero se
conecta a SqlServer, carga un DataSet, realiza ciertas modificaciones en los
datos, y luego los inserta en tablas de Oracle, este proceso se debe

I develop web application in asp.net with c# language and access database
I use access 2002 and ado.net with jet4
In some case I recieve "Unspecified error"
In my code when db tier is created my connection is open

Please tell me where can download <Beginning C# web Applications with Visual
studio .net> 's code
Thanks in advance!

I used the IDE to generate the connection string and it generated the following
Provider=OraOLEDB.Oracle;Persist Security Info=False;User ID=SomeID;Data Source=EDSSP.DDDDD;EXTENDED PROPERTIES=''
Now when I take this text and create a connection object with it, I get an error on the ...

I have looked in the documentation and I have looked in Google, but I cannot
seem to find an answer: If a transaction has been opened and the transaction
is disposed before calling Commit or Rollback, am I guarenteed that the
transaction will be rolled back?  For example:

I'm connecting to Oracle 9i database using ODP.NET (Using the
OracleConnection class). Can I use the same currently open connection for
executing a stored procedure / query through an ADODB.Command object?
I want to do something like this:

I have read a bit about the strongly types DataSets, and the only
purpose/value that I can see for them is the ability to write code that
references the contents of such a DataSet in a more convenient manner. There
are three (3) significant issues I see with the use of strongly ...

I have a MSSQL table that has a uniqueidentifier that defaults to (newid())
I'm getting the following Error when I try to insert a new record into the dataset
Column 'ID' does not allow null
I've hacked at the properties for a while but no luck...any clues

What's the easiest way to update an MSDE database with CSV data using C#?
(I'm assuming all that DTS stuff is not licensed for use with MSDE. And if
it is, how do you access it from .NET?)

I have created some user controls to include in my aspx pages, the problem I
have is if I include a user control that has an updatable datagrid on it and
I click the button it references the page where the control is called and
not the control itself.

I want to update a DataRow asynchronously without it affecting any changes
that have been made by the user. I don't want these changes to be picked up
by the command builder, for example. Is there any way to edit the data in
the DataRow directly without having to go through ...

I've two tables: one master and the other is detail
I've this two lines
daNoleggi.Update(_ds.GH_Noleggi
daDettaglio.Update(_ds.GH_DettaglioNoleggio

I have been reading a lot of material on the use of (specifically) the
SqlClient classes that are used to retrieve, display, edit, and update
database records. The basic approach seems to be:
1. Define a SqlConnection to the database.

I have isolated all my data access into DALC classes ex. VendorDALC.  I want
to allow for both SQL Server and MS Access databases.  What is the best
practice for this?  VendorSQLDALC and VendorOLEDALC?  Or is there a better
way to do this?   SQLHelper / OLEHelper and have VendorDALC ...