I have some small code that opens a connection to an oledb-provider and
opens a recordset. Then creates a delegate to a RecordChangeComplete event
on the recordset.
When I put this code in a service (have tried both OnStart and in a separate

In my app, all queries from different methods/objects have to be in one
transaction (to a single DB). I think that there is a basic way to so that is
pass the same connection and transaction from the beginning of process all
the way down to the end and commit there. Since they ...

Hello, I need immediate help with this problem.

oracle 8i db.
First of all here is the definition of the function(oracle function).

I'm doing some work on a project which involves accessing a large
Access database (about 850Mb)
The problem is when I'm doing an update/insert into the database the
oleDbCommand.executeNonQuery() method seems to return before Access has

I have a large SP that has various print messages throughout.
I want to view these print messages from .Net. As such I wire up an
infoMessage event handler to the connection.
If executed using executeNonQuery it will return all messages fine. Using

   I'm having an issue with an asp.net app (vb.net code) and ado.net. I've
written up the following piece of code everything I've read says it should
work without an issue. Debugging I see that after the last line of code
executes my myDataTable object has one additional row in ...

How do I use DeleteCommand, and UpdateCommand, the SQL string in them is
really confusing with bunch of parameters, what are the parameters order ?
Can I make customized DeleteCommand [which calls Update SQL statement]?

I'm working on a windows app, using SQL for my databse.  I have a table
named "user id".  There are 50 user numbers, ranging from 1-50.  The numbers
are actually the login. no password.  I would like to have a user sit down at
a computer, hit a button and go.  I need the computer ...

Hello NG!
MSDN sais:
To ensure best performance for ReadXml, on a large file, call the
DataTable.BeginLoadData method for each table in the DataSet, then call

Hello all,
Can anybody tell me, or point me the right direction on how I would make a
simple countdown timer from 60 sec down.  I also need to control the time
from a server.

I just got a project accessing MySQL.  How can  I can find the ODBC driver
for it?
Are there other ways of connecting to it from C#?
Any help is greatly appreciated.

Hey All,
I have the code below to run a built up SQL string.   Column1 is a Identity
Column, and Column2 is a varchar(10).  The sqlString below gives me an
System.Data.SqlException Exception that says, "Cannot insert the value NULL

We have a dotnet windows service that will be utilized by anywhere from
100 - 300 windows clients.  They will be connecting using a singleton call.
What is the best practice for connecting from within the service to the
database?  Should each call new up a new connection and then ...

i have the follwing scenario:
...
DataTable myDataTable = new DataTable();
myDataAdapter.Fill(myDataTable);

I'm currently coding a simple project. The goal is to update an Sql database with chosen rows of Excel files. I could use of course DTS but that's not the client choice.
I wonder whether it's possible to use two different dataset, I mean physically different (with sqlDataAdapters ...