I am trying to loop through some fields on a form in order to call a stored
procedure to insert bulk information into SQL server, the thing is I am
trying to exit the loop but the loop keeps going past the counter varible. I
only want to insert the information based on the value of ...

Can I run multiple queries separated by semicolon (;) with ado.net compact
framework uisng windows ce?
I have tried to use it by setting IDbCommand.CommandType = CommandType.Text
and without it. but couldnot get my code work

Did I miss something, or is this just lame?
With Oracle 10g & distributed transactions I get:
System.DllNotFoundException: Unable to load DLL (oramts.dll). at System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) ...
If I rename the 10g ...

I'm just about to write one of these components to simplify simple dataset
return, and command execution against a SQL Server database.
Does ANYONE have a component freely available that I can use? This will save
me a day or two!

I'm updating my current VB.et application.  I currently reads about 6 tables
from an MS Data base.  I've created a new MDB file which combines the 6 tables
into 1 table.  I'm doing this because I know I'll speed up my application
loading time by more than 10 seconds (out of about ...

Can someone help with how I might add a datarow to a dataset where the
Primary Key is an identity column and as such does not receive its value
until the row is inserted into the db?
I get a null error adding the row to the dataset without a value in the PK

I need to copy new records from an access table which can potentially have
records added to it all the time by users. I figure I can add a flag for
records that have been copied already that can be set after copy. The
problem is that in the time that I copy all new records using ...

I have an Winforms application that's using ADO.NET to access a SQL Server database. The connection is NOT pooled, and is kept alive for as long as the application is active. It also creates a ##TEMP table to be able to detect an already running instance (only one can run at a ...

Recently, we installed Sharepoint Services on our test server (Server 2003)
to try it out. I made a new web for my regular aspx pages. My problem is
that now whenever I try to access my old pages, it prompts for a username
and password for that server. I want it to allow anonymous ...

I'm trying to select from an Access DB based on a date field.  The date
field in Access is specified as Date/Time and the following code is grabbing
the date from a DatePicker in short format:
Error - Date type mismatch in criteria expression

I am storing images in SQL server ans trying to retrieve them into an image
control but I can't seem to get the image to show. If I load the image page
(ReadRealImage) on it's own it works no problem, what I am trying to do is
to load the image into a user control page with an image ...

I am using ODP.NET 9.2.0.4.01 and .NET 2003 to create a connection to
an Oracle 8.1.7 database running on Windows NT.
My problem is that it takes 32 seconds to create a new connection pool
to the database. I have a few questions if you can possibly help me (I

I have a dataset which has a parent table and a child table.  The parent
table has some expression columns that do things like sum the ExtPrice
column in the child table for a subtotal, calculate tax (tax rate *
subtotal), etc.  My problem is when I delete the last row in the child

Right now, I have an app with an SQL2k backend that is just getting revved
up. Currently, I fill my datatables with everything that is in the real
database table (I've done a good job of normalizing the database, so the
tables are fairly thin). After fill, I then populate a grid for ...

Lets say I have a SINGLE DataSet declared Public in a module to use across
all classes. What happens if, say, in Class1, I fill the DataSet with the
datatable "dtEmp", then later, after Class1 goes out of scope, in Class2, I
fill the DataSet and ALSO use the name for datatable as ...