Im using a SQLDataAdapter with custom select, update and insertqueries which
i assume work (as they are simple SQL statements).
I use this adapter to fill a table. I also add a few more columns, and set
up primary keys. I make updates to this table. I do this by queuing the data

I'm attempting to read from an Excel file with a oledb.oledbconnection and
get an error "Could not find installable ISAM".
How does one fix this problem and does this fix need be done in both design
time and deployment to the client (as with .net framework)?

I have the following code:
   Public Sub SelectAdminUserByID()
       Try
           Dim oDR As SqlDataReader =

I run this code without error.  I create a recordset of the changes, the row
I want to add,  but the Update command doesn't add the records to the DB.
The Update Command returns a zero indicating that no records change.   I'm
lost does anyone have any ideas?

Ok, I have a dataview that may or may not have a rowfilter.  If I do have a
rowfilter applied, how can I quickly find out what the total number of rows
are from the unfiltered state.
A user can take actions against records during either state, but I need to

I appreciate everyone's help with my connection string for Excel. Here's a
follow-up or two.
How do you get the sheet names from Excel if you don't know them in advance
for your SELECT statement?

I have a typed dataset generated from an xsd file. If I want to add more
functionallity to this, is it a bad idea to inherit from the autogenerated
class file and use that one in all dataset operations?
In that way I can add methods to perform the operations I need without the

I’m having trouble with Typed Datasets
I would like to add functionality to my typed dataset at the business layer such as delete rules or editing rules by inheriting it.
Can I inherit the datatable?  I’m having trouble because of the constructor.
Can I override the row change event ...

Hey there
I know there's a simple answer to this Quesiton because I've asked it before (but I have not yet used it and have now forgotten what the answer was!) so..
I have a simple Datareader returning the value of a field from a SQL Server but if the field is blank, the ...

How to read/write a BLOB object from/to oracle 8i using Oledb?

I have made quite simple Windows Forms application using VB.NET 2003. This
application in workstations only collect data into local Access database
table (4 tables) for manufacturing tracing purposes. Access DB is in
workstations locally as a kind of buffer because network is not ...

I am trying to display some images from SQL Server, the image is displaying
correctly, but when I have more than one row in the table I only get one
image displayed? What am I doing wrong? is there a better way to do this?
Sean - thanks in advance

When I have a text box that is bound to a number field in my dataset (not even a strongly-typed dataset), clearing out that field by selecting the text and pressing delete raises a first-chance exception in mscorlib of Input string was not in a correct format then ignores the ...

When I run an example program on the
http://www.dotnetjunkies.com/quickstart/util/srcview.aspx?path=/quickstart/asppl
us/samples/webforms/data/datagrid1.src&file=VB\datagrid1.aspx&font=3
I received an error message:
"The ConnectionString property has not been initialized.

I can find plenty of documentation on the relation between
System.Data.DbType and System.Type e.g.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cp
conmappingnetdataproviderdatatypestonetframeworkdatatypes.asp
Is there a method anywhere in the .NET ...