Can anyone tell me if the actual connection string of the ADO.Net
connection objects are sent across the network to the database in clear
text?
Thanks

A deffinite bug in mscorwks.dll makes my managed service crash abruptly.
When hooking up windbg it turns out to be an "access violation" in the
mscorwks assembly memory space. Every time it happens the managed stack is
dealing  with datasets. The native stackdump reveals that the ...

Is there really a way to debug for the rowversions of a datarow, directly
using Watch or Command Window (doesn't have indexer error)?
The only way I can do this is a utility that outputs rowversions using Trace
window...

Hello , All My problem is like that I m fetching data from Remote Databse
Server . The data that i want retreive is so large that it take too much
time, and system shows me error like Time Out expires. I have putted
Timeout=0 . I have also tried timeout=120 . But Problem as it is ...

I received an error from the ExecuteNonQuery command and I don't have
a clue where to begin to diagnose it.
The calling parameters are connection, CommandType.StoredProcedure,
SPName, Parms().

I have a .NET C# program that references a COM object that is expecting a
database connection pointer (_ConnectionPtr) parameter.  How can I pass my
open SqlCOnnection object as a pointer ?
Any help is greatly appreciated.

SqlServer allows multiple sqlstatements in one SqlCommand by using ';'
This can for instance be used for refreshing after an insert statement or
for filling mutiple datatables with one command.
I don't think Oracle can do this, I hope I'm wrong...

Is there an easy way to display everything in a DataTable when you're
testing... DataSets allow you to see it all with GetXml... with DataTables it
seems like you're forced to pick a specific row... then you can look at the
ItemArray for that row in the watch pane... which isn't ...

I have a DataTable populated with 2000 new records, then call the Update of
the SqlDataAdapter to insert the records from the DataTable into SQL Server,
and this operation takes about 18 seconds, thus around 110 inserts per
second.

I wanted to run this by the gurus out there to see if my method of filling
an integer array from a DataReader makes sense.  The number of rows the
DataReader will return would not be known beforehand, unless I make a
separate ExecuteScalar call to the database and use a sproc ...

I have an MS/SQL Table with a field defined as "VarBinary(128)" and an
Asp.Net application form with a TextBox that will accept user input as
LastName.
1. I can write the TextBox (LastName) to the MS/SQL table as

In my application I have a reasonably complex dataset. I would like to
implement Save As functionality within the application.
When a user first opens the application, they either open an existing
dataset (based on a combo selection) or they do new and a new dataset is

We have a rather stored procedure which works like countless others in our
application, but for some reason, this specific sproc is taking an
extraordinary amount of time to return when called.
We have tried using data adapters  to fill a dataset, and we've tried using

One of the people that I work with and I were going back and forth about
whether its better to return data from a persistence layer as a dataset or as
a class array.  So, I throw together a quick form that would generate a
dataset/datatable woth 1001 records and an array of ...

Trying to teach myself some database programming under VB.Net so
apologies if this is something of a newbie question:
Having succeeded in getting some local database programs working OK
I'm now interested in a slightly more ambitious project to maintain a