What's the best aproach to import xml-based data into an oracle 9i
database with ado.net DataAdapters, when the data is in an xml-file?
The operations should insert new rows and update changed rows.
Does ado.net provide some automatisms for this or do i have to do this

For a column in (eg an Access) database that's used to store numeric
data, is there a specific way to designate a missing value for a given
row (ie the value was simply never measured or assigned). Or must I
set up my own convention, ie if it's a short type then to use eg

Hi everyon,
I am experiencing a problem with a stored procedure not returning a value in
the parameter @RETURN_VALUE when debugging in C#.
The stored procedure looks something like this:

I'm executing a stored procedure using a command object
and the executeReader method. The result is returned as a
sqldatareader.
I need to know the number of rows in the sqldatareader and

I'm sorry if this is a repost.
Please reply with existing links, if any.
I have a list box with a datatable as data source.
I edit an item from the list box (by changing the item

   I had wrote 2 app in c#.net one Windows Form base and one Web Base and
those 2 connect to a access database and some time I got this error in my
web
base application and I can't figure out what's wrong,  I just hit reload and

Can anybody help me on how to print excel files that has been read via
ADO.NET.
Or anyway, what I want to avoid is automation (instantiating an excel
application object).

Greets.
A very simple question in the topic, probably takes about 10 seconds for an
expert to answer =)
Thanks ..

Hi every one, i'm trying to use a sqlcommandbuilder in an application using a
table without a primary key, when i call the DataAdapter.Update Method there
comes an Error saying that "the selectcommand does not return information
about the primary key" or some thing like that...

    I am reading a CSV file into a DataTable with the following code :
  internal static DataTable ReadFromCSVFile( string csvFileName ) {
     if ( !File.Exists( csvFileName ) ) {
        throw new ApplicationException( " Cannot find CSV file : \"" +

I have a combobox bound to a smalldatetime column in a table.
The ComboBox displays all available dates.
However it displays them in long format and I want to display them in short
format.

I'm trying to use the SqlHelper.UpdateDataSet method with transactions. The
DAAB 2.0  documentaion only say: "SqlHelper.UpdateDataset does not include
transaction support. If you need this, you can implement it yourself by a
preceding call to the helper method SqlHelper ...

I'm running a long query in a separate thread. If I abort that thread
and then I try to use the same connection string again, I get an
unexpected result.
Details:

Right now I'm putting my query strings into static functions in a DbQuery
class that returns Datatables.
Eg.
public class DbQuery

I have a datagrid with a Select(LinkButton) Column followed by several Bound
Columns.
I have enabled the columns to sort and created the correct event handler (I
think) - however the crux of my problem is that when I click on one of the