I'd like to INSERT a string into a database using C#. The way I've tried
it is the following:
sQuery = string.Format("INSERT INTO myTable (Header, Body) VALUES
('{0}','{1}')", sHeader, sBody);

Hi, i wanted to get this groups opinions on a design issue ive run into:
a programmer has coded a common data access class which is supposed to be
inherited by all data access layers at my firm.  This class instantiates a
connection in the constructor, relies heavily on OleDb ...

I'm airly new to .net and I can't seem to figure out this problem, I hope you
can help...
I'm filling a dataset from an Access database with columns of type =
Decimal. When I load a datagrid with the dataset, the numbers are truncated,

I am building an App that takes an Excel file and populates 3 DataTable's in
a Dataset.  I then was to create a relationship between these 3 DataTables.
After dong so I want to run some code to process / modify the data in the
tables and then return the result back into an Excel ...