I currently use ADO.net to write to an access database using the
ExecuteNonQuery function and SQL INSERT statements. The data I write mostly
consists of names - which results in some problems: When I try to write names
like "O'Connor" or "O'Neal" the call fails ('cause of the ' ) ...

I'm having a little problem using a temporary table (MSDE as database
engine).
   Dim cn As New SqlConnection("Data Source=" & SQLServerName _
       & ";Integrated Security=SSPI;Initial Catalog=TestDB;Pooling=No")

Is there a way to join DataTables, kind of like how you do join in SQL?

guys, when using templates like below - this particular one is a date.
are there any properties in the template columns i can access to format the date to show a short.dateString? so it wont show the time 12:00 am
normally with oracle i can to a to_char(my_date,format mask) single ...

I'm trying to create a SQL Server 2000 database via the following TSQL code
in .NET 2003.
if not exists (SELECT * FROM dbo.sysdatabases WHERE name='Test-Co') create
database Test-Co

My .NET 2003 program uses a dataset bound to a form to insert records into a
SQL Server 2000 table. The key column is IDENTITY(1,1). When I perform a
Dataset.Update, I get an error stating that Value '1' is already in the
table. Turns out that ONLY the first row (ID of 1) of the ...

I currently have a SQL join which combines 2 tables.  I then update only one
of the tables with new information.  While this works easily in ADO, I am
having trouble figuring out how to do this in ADO.NET.  I first tried to do
an update using a SQL JOIN DataSet, but that gave me ...

Hi all I hope someone can help me. I am new to VB.NET I am trying to connect
to an access database from a windows form and it is driving me nuts, could
anyone lay it out for me?
thanks all

on SQL Server i have the following sample stored procedure:
CREATE PROC owner.procname (
 @id int,
 @desc varchar(50) output)

I would like to step thru an database table one row at a time.  Forward
and backward.  In a C# .NET program.   In general, which .NET class is
used to to this?
I am thinking my prefered approach is to somehow use "DECLARE ...

I am trying to do a simple ExecuteNonQuery method on a very simple INSERT
statement. Please see code below.
Could anyone see why I would continue to get an "Operation must use an
updateable query" error on such a simple code fragment?

I'm trying to use parameters in a search, but I can't get it right.
Before I add parameters this works:
string cmd =
"SELECT * " +

Is there a way to execute SQL statement on a Dataset?
For example, my Dataset contains 1 table and I want to execute the following
SQL statement:
UPDATE table1 SET  Field1='x' WHERE Field2='y'

I'm hoping that there's something about the underpinnings of the .NET
framework that I don't understand.  Something about the SqlHelper appliaction
block, though, kinda creeps me out.
All of its methods are static/shared.  

I have a Dataset that is built from the following query
USE Northwind
SELECT  * FROM   Orders
ORDER BY Customer