I have a product (running on .NET 1.1) that needs to maintain a local
database on the machine it's installed on.  I want something with extremely
low resource overhead (i.e. no SQL Server, no MSDE).  It needs to be quick
with inserts and selects.  It also can not be a memory hog.

The following example from "MURACH's VB.NET database programming with ADO.NET"
seems to be missing something: particularly a type for ('As Vendor'?? )
Maybe someone can help clarify what I need to make this work.
This example demonstrates how to create a VendorDB class with the ...

I am sponsoring a contest to see if someone can come up with ADO.net code to
insert records into a MS Access 2003 database faster than ADODB methods (MS
ActiveX Data Object 2.x library).  My experiece has shown that I can write
records to Access at least 4 times faster using ...

I'm trying to write some DB-independent code using ADO.NET 2.0 and the
System.Data.Common.DbX classes, as suggested before; but I'm encountering
another weird problem.
Here's some code (let's assume the provider name and the connection string

I am seeking to hand-roll my own blog in ASP.NET 2.0 and SQLExpress
2005. Why? Because I can. Because I will gain experience.
The one thing that has me stumped at square one is inline images. That
is, images inline with the actual content of the blog itself. Is there

I am trying to check the date of my field to check if it is greater that
today, but I am getting an error.
I am using :
       <asp:CompareValidator runat="server"

I am building an asp.net application wich collect data from an SQL server
database.
Those data in this database can be huge with the time.
Actually, I am retriving those data through store procedure return in a

Given a technique similar to the following, instead of actually
executing the Stored Procedure, I need the resulting SQL command string
written to a file and then manually executed in Query Analyzer.
Dim objSqlConn As New SqlClient.SqlConnection

I have an app that reads & writes to XML files.  I now would like to
create some reports using Crystal Reports, and the usual way I do this
is by creating a dataset in Visual Studio & inserting the fields
graphically.  However, I cannot find out how to do this within the VS

I have been misunderstanding the closing of the connection.
If I have set CommandBehavior.CloseConnection, I thought that connection
would be closed when you had read through the dataread.  As a matter of fact
I found that if I had it set, I couldn't seem to get to the next results, ...

I am currently architecting .NET Application for an Enterpise Level
client.
The customer has a natural Oracle bias. I think that Oracle is a great
DBMS too. Probably still better thatn SQL Server.

I have seen a thread similar to this problem earlier in this thread
unfortuantely did not really see a solution.  My problem is as follows.
I am opening a connection to an access database performing some operations
and the closing (typical use)  I notice however that upon calling ...

I'm quite new to VS 2005, and tries to connect several controls at my form.
I thought this should be simple without writing code, but I can't get it to
work.
I have one dataset with two related tables.

When using the smalldatetime data type in a SQL database, how do I prevent
the field from storing the time? All I want in the field is the date, but is
keeps adding 12:00:00 AM at the end of the field.
Thanks!

I have begrudgingly decided to use Strongly Typed Datasets but hate the
code that is generated by dragging and dropping ADO.Net controls and
using Configure Data Adapter and letting the 'Wizard' build my SQL, for
the following reasons: