G'Day all,
Heres my code: (watch for wrapping)
'MDB Connection and open
       Dim MDBConnection

Am fed up with Null values crashing my applications and screwing up data
when it hits a check or combo box, in Visual Studio 2002.
Have found numerous fixes on various sites and now feel am going round in
circles.

(Type your message here)
hello,
  i'm using fill method to populate.and fill method implicitly open and close the executereader connection.  and my question is why the error occured"there is already an open datareader associated with this connection which must be closed first"  ...

I followed a walk through and created a record set. The db functionality is
being handeled in a component. dataaccess is working fine, but i'm not able
to built a sub to handle the updates. the walkthrough.
I used studio to create the component and it generated all the edit, ...

I am debating which route to take for Declarative Trans
Application. ADO.NET or ES (COM+). What do i gain by going
the ADO.NET rounte and cetainly at what cost?
Thank you

I have a DataSet built from a .XSD that contains relations. For example
consider the XML fragment below:
<Apples>
 <Orange ID="A"/>

Is there a limit on the number of columns in a dataadapter?

I'm receiving an exception of "Data type mismatch in criteria expression" when trying to store a date and time to a column of Access 2002.  The default parameter constructor puts the DBType as DbDate which stores only the date portion.  It needs to be changed to DbTimeStamp in ...

I am trying to generate Excel sheet using
Provider=Microsoft.Jet.OLEDB.4.0;
I am always getting the error while inserting data into any cell other
than A.

I have used the OleDb connection GetlOleDbSchema &
OleDbSchemGuid.Tables to get a list of tables from the Access
database. I can not find the equivalent way to get a list of tables
from an SQL database. Please advise how to go about this.

I should retrieve DataTable of the source database and compare that with
the target database's DataTable. Only those lines in source database's
DataTable which has (new unknown) code that does not already exist in
target database's DataTable should add (ie. import) into target

I'm working with NorthWind
My Customers Form uses Untyped Dataset and Bound Controls
(BindingManagerBase). However, deleting a customer and updating the
database is

Please tell  me what could be the problem with this piece of code
Error : Message    "Prepared statement '(@ID int,@fname varchar(50),@lname
varchar(50),@mname varchar(50' expects parameter @ID, which was not
supplied."   

I am using .NET Framework 1.1 on a windows server machine.
I am creating a .NET web application where
I will ask user to select parameters and a query will be generated
dynamically, this query will then be passed to the database server for

I need to merge/copy/import or what ever you want to call it, select rows
from a dataset to another.  for example, say ds1 has 10 rows and I want to
get only the rows where the column 'category' has a value of 2, and merge
these rows into ds2.  I tried doing something like this: