I am writing a program where i want to perform a calculation, and save this result to a field in a database.  How do I open the row for editing, change the value, and close the row.  I am new to .NEt.  I would do this in VB6 using a recordset.edit, recordset.update.  Please help.

A customer claims that when executing against SQL Server, the use of
OleDbCommand.ExecuteNonQuery will return the number of rows affected when
executing a Stored Procedure.  The customer also claims that the
ExecuteNonQuery will return the number of rows affected by a select into

I'm reading a table with fields of varchar type and the
DataReader["MyField"].ToString returns the field padded with spaces upto the
maximum length. In QA select len(MyField) returns a different length for
each field and for sure I ran an update with RTRIM() for each row.

Im trying to send a number of insert statements to SQL Server 2000 at
one time, using ADO.NET.
The code im using is pretty standard (see below) and the insert is
performed all fine and dandy.

This is my SQL Insert Statement to insert a single into a table on a
database;
INSERT tb_test VALUES(' & _
txtTest1.Text & "' " & _

I need to figure out how to put files like a .JPG or .DOC into a Access2000
DB via .NET.  Does the Odbc library support this functionality?  If not, any
other suggestions?
- Rashad Rivera

I have a class written in VB.NET which connects to a SQL Server 2000 database, executes a stored procedure and fills an ADO Dataset with the result set.  Making the connection to the database and filling the dataset are both done inside of a Try...Catch statment to catch any ...

I am trying to push 40,000 rows of data from an ado.net
dataTable to a sql server table.  It takes me about 5
minutes to read the data from an external data source
(using a vb.net project).  But it takes over 10 minutes to

I try to read data from a SQL server and convert it to a xml document string
where the data itself is saved with different encodings. I figured out how
to write the correct encoding to the string but it seems that when reading
from the database the data i converted from it's ...

I had expected to be able to change the DataRow that is passed into the RowUpdating event, but for some reason it does not seem to work. Am I doing something wrong or is a workaround?

Can the commandbuilder be used with a command object?  I
want to insert data into a table in sql server that has
many fields/columns from a dataTable in a vb.net project.  
I am trying to get away from this though

Can someone tell me what actually happens when I call
EnlistDistributedTransaction(null) on SqlConnection object?
Is it supposed to unenlist?
Or is it supposed to enlist in the transaction of the

I am using Oracle as my database source. My webservice is running on a
machine different than the database. I can connect to my oracle database if
my database is in the same server as my webservice, but in this case the
databse server is apart. What needs to be add to the connection ...

I've found 742 claims that it can be done - including Microsoft? ADO.NET
(Core Reference).  On the other hand, I can't find the rules/form/format for
the spS or any but the most trivial examples.
Anyone know where I can find an example that shows how, for example, the

I need to configure connection pooling for SQL Server
OleDB provider. Although the ".Net Data Access
Architecture Guide"
(http://msdn.microsoft.com/library/default.asp?