could somebody please explain to me how the datatable.newrow method works, i've been trying to figure it out for weeks. I need to emulate it myself.
I can bind my datagrid to a collection of objects with no problem. But that leaves me with a fixed number of properties per object ...

All
I have an Excel worksheet (also saved as .CSV) that I need to read into a .Net dataset
Using System.Data.Oledb namespace, I can connect to either and extract data.  The problem is that one column contains alphanumeric values, or which the majority are numerical in appearance. ...

Hello List!
I have an untyped dataset with a very simple table, two columns A and B and
one extra column ColumnCalc with the Expression "A+B". Details see code
snippet below.

Using ODP.NET latest version - we have a stored proc that returns an Oracle
BOOLEAN type as an OUT parameter. I can't find anyting in the OracleDbType
enumeration that works - there is no Boolean there.
Any idea how to accomplish this? The docs don't even mention the BOOLEAN

I'm having a very frustrating problem executing a stored procedure. I'll put
the code at the bottom.
When I build the SP and add all the parameters everything goes as expected.
However when I run it, the exception tells me that the parameter doesnt

I need to use ADO.Net data adapter for Oracle but I
couldn't find it.
I saw someone has imports like:
imports System;

I have an SqlDataAdapter setup with the following insert command :
insert into SomeTable
([_ID],[ACCOUNT],[DESCRIPTION],[INACTIVE],[LINE_TYPE],[BAL_TYPE],[ACCT_TYPE]
,[SORT_GROUP],[POST_TYPE],[COST_CNTR],[FREIGHT],[PROD_LINE_CD],[TEST_ACCOUNT

I'm trying to insert a long value (the System.DateTime.Tick  value) into a
db, but im having a bear of a time doing so.  I keep getting all kinds of
errors.  Could someone point me in the right direction please?
thanks

Greetings to all-
An ADO newbie question...
Has anyone else encountered this?
When employing DataAdapter.Fill to initially populate a table in a typed

I'm looping thru all the columns in a dataset that was filled from a SQL
Server table. I want to be able to exclude the columns that have an identity
key or are primary keys in SQL Server. Is there any method or property for
this in the dataset? or how do you go about getting that ...

What is the best way to execute a query/datareader that must connect to a
Pervasive SQL2000i database (OleDb works) and a Paradox table (OleDb works)
?  The connection strings I see have one database listed typically.  I have
successfully connected to both using OleDb...

Greeting to all,
A newbie question.
I would like to model an XML schema to match a sql table that uses the GUID
"uniqueidentifier" data type. There is no similar data type on the XML side.

I have a Dataset, I make a change to an item, let's say from 12 to 5. Is
there a way to get the old value? (12). Basically maybe some function oldval
or something to get the old value.
Thanks

I have made the following stored procedure with the following select
statement
select * from user
select * from order, orderdetail where order.id=orderdetail.id

I am using .NET to insert a record into an Access Database. The Access
Database is coming from an external source and used by other applications, I
have no control over the column names. It has 3 columns, "First Name", "Last
Name", and "Work Email". As you can see, all 3 use a ...