I'm using SqlConnection to insert data from one table into another using
SqlCommand after I start a transaction.
If I have convertion error for the insertion of the data, The transaction is
no longer valid.

Hi! Are there any best practices using OleDbDataAdapter and strongly typed
data sets? I always end up having too many (I think) adapters and data sets,
even for a small application with just a few tables.
In my most recent project I use 7 tables in the database and I think I have

Hello, I'm trying to implement a very easy asp.net page to insert some
data in a database. I'm doing it using as less code as posible so I
used as much data controls as possible. Here is the page schema:
3 Textfields

have a VB6 pgm, which used the following to read/write a blob of doubles
Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (ByVal
pDest As Long, ByVal pSrc As Long, ByVal Length As Long)
CopyMemory pDest:=VarPtr(mRolloutQty(StartingMonthOffset)),

I have 4 columns in a sql database which contain the value 0 or 1.  From a
speed/storage standpoint, does it make any difference whether I treat these
columns as bit or tinyint.  Don't both take a byte for storage and
transmittal.

I have a web app that calls a SP.  Twice in the last month
the app has locked up.  The first time we ran a SQL Trace
which showed that the SP had "completed".  But no dataset
was returned and ultimately the app "timed out" by

Can anyone give an example of how to filter the detail datagrid that is
databound in a master detail relationship.
I need to display only a subset of the detail records.
Thanks

Following MS' recommendation, I have changed the targetNamespace of my
dataset in its .XSD file in a project I am (still) developing from the
default http://www.tempuri.org to something of mine, i.e. changed the line:
 <xs:schema id="DataSetIC"

I have a problem with the RowFilter property, which I have explained below.
I create a typed dataset from a Sql view. Using a data adapter I fill the
table in the dataset. However when I try to apply a filter to the table in
the dataset, the filter is ignored, here is the code I use ...

Hi, I am using ADO code and
I got a collection read only error. I have setted the LockType to
Optimistic and CursorType to Dynamic, but it still have the same
error, anyone have any ideas? I am appreciate for your help.

I'm trying to add some ADO.NET code to a program developed with VC++ 6.0.
When I add a small C++ routine in a file  compiled with /CLR my startup time
goes from 2 seconds to 20 seconds every time a try to run the program. (not
just first time).

          I Had a problem in developing a application for getting a message
over or above system tray .
When we first logon into the MSN messenger , The messenger will shows
message above the system tray. for example " there are

I'm having trouble converting a datatable into xml, with resonse.write
to aspx. I'm basically converting vb code that saved a recordset into a
stream into c#, but the format is wrong. I've tried using streams,
datadoc, xmlreader, etc with no success. I need to convert it directly

I am using this function tu execute updates to a MySql database from a sql
string, but I am getting a  System.InvalidOperationException: Connection
must be valid and open.
Database queries work fine, but I cant update the source. Am I missing

I am trying to call a stored function of Oracle Package from VB.net.
The function takes a string and returns boolean.
How should I call it from vb.net ?
I tried 3 different ways but get error: