What do I use to load a amount of bytes into the Oracle database?
I've to choose from:
CHAR
VARCHAR2

We have found that when you populate and or select from an excel file using
ado.net, ado.net will only insert and or select 255 characters from an excel
field?  Does anyone know how to get around this limitation?

Hi I am impelementing a replication procedure to synchronize local Data Set record supdate with a SQL Server 2000 DB. I have written a stored procedure that accepts as one of its paraeters a timestamp parameter to check the rowversion of the server record before it can apply the ...

I want to use dynamic SQL to add a new dataset to an existing Oracle
Table. The table is 'CONTENTTYPE' and contains only 1 field named
'CONTENTTYPE' which is Char(100).
When I create the SQL-String  manually' (see example below, for

Is it possible to store a byte[] array as a type for a DataColumn?  I
was thinking of a generic way to store *anything* in a DataColumn
without seriously typing it, then I can pass the DataSet that contains
it anywhere.

I have a struck a problem updating adapters when there are database relationships.  If I setup two adapters for the Orders, and OrderDetails tables from Northwind, and then I delete an Order with related order details, I get a constraint violation in the database (because I am ...

Does anyone know how can I connect to a Postgres database from an C#
project?
Ivana

I am trying to compile two web service proxies into a dll for use in a web app.  I am compiling from the command line and all I get for version is 0.0.0.0
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\csc.exe /t:library /out:ReportsBusiness.dll UpdateProcessID.cs InsertReport.cs /r ...

I am disposing the dataset using the using block
like
using(DataSet ds = new DataSet()
..

Hi there , I'm experiencing problems accessing a row for which i called the my_row.Delete(), I need to access the row
as I can do if I call on my_table.rejectChanges().I need some data from that row
the general idea of the code is as brought in the code below, it fails on access to ...

I have a datagrid populated from a dataadapter that is databound when the user picks a choice from a dropdownlist
Depending on the choice, the user queries the database and may get considerable amount of rows returned. But then again, no rows may be returned at all - because of ...

As far as I understand, setting a relation between two tables in a
dataset means creating a unique (primary key) constraint in one table
and a ForeignKey constrainf in another. If this is correct, than why
do we need both? If am wrong, than what is the difference?

I have a simple SQL Server 2000 stored procedure as follows
ALTER PROCEDURE pos_GetTransactionProduct
   @authID in
A

I have read the article about data paging in msdn. But when I come
across the Master/Detail tables, I find it will be another problem.
If I want to select 100 records into the master table in a dataset,
how can I select just all the records associating with those in master

I need to use the .NET framework (using C#) to create a system service that
makes a connection to a SQL Server database during start up, and then
performs a SELECT statement to poll a few tables once every x minutes.  Upon
finding some work to do (if the SELECT clause returns rows), ...