Simple question:  when accessing column values, is numerical indexing faster
than referencing by column name?  I know that in the case of the DataReader,
the answer is yes; was just wondering if the same applies to a DataTable.
Regards,

Dear reader,
I'm making a general function to update a database with changes on a form
with bound controls. I was wondering if it is possible to:
(1) see in code to which dataset the control is bound to? I'm adding the

I have an unsolvable otherwise cumbersome problem. Currently I am using
SqlCe on my Handheld w/ some data downloaded onto it from Sql Server. The
update/insert/delete commands are then issued onto the Handheld database.
Now with all data are changed/modified on the SqlCe, I created ...

Can anyone suggest a tool that could be used to provide an end-user
interface to import Excel "databases" into a DataSet? I am developing an
application where my users will frequently need to import inventory lists
they get from clients. Unfortunately these lists will frequently ...

Hello, Im +/- newbi
I have a DataTable containing several DataColumns
Some columns have single names, like "IP", others have composite names, like "IP Subnet"
I want to select rows where IP and IP Subnet are not empty strings, so here come my two questions

 Hi Guys
I tried to insert data into SQL server database using the following code. All data that I received from all my connections (10 socket). It runs for sometime It was able to insert some data then suddenly in the middle of the process I encountered
"The connection is already ...

I am making use of the disconnected dataset in C#.
I am writing an MDI App where the Child of the MDI makes use of a
disconnected Dataset. I open two Child forms!
The first Child form I changes some data and save it to the database.

I have the following setup:
1. 5 tables in a SQL database:
       - Protocols
       - Readers

I ran into this toady and I can't figure it out.  Here is the code:
System.Guid guid = this.dsLoop.Device[this.cbDomainPanels.SelectedIndex].ID;
//This doesn't filetr correctly
// DataView dv = new DataView(this.dsPanel.Device, "[Parent]='" +

We have a table in Oracle described as the following:
SQL> desc cubetest
Name                                      Null?    Type
----------------------------------------- --------

As I read about .NET i see that we should use a datareader to read data.
Well, that's OK, but is this det best way of filling a Datagrid just for
reading. I don't want to use a listboks because I want to add some collors
to the cells depending on the values and so on. So, is there ...

I'm using vb.net 1.1 and VS2003.  in the dataset designer I'm trying to set
the default value of a dataset table column (actually its an attribute) to
an empty string so I don't get dbnull error in my code.  How can I do this.
In databases I can set a default value of empty string ...

only some rows are being added to dataset when i run this method repeatedly ---any idea why it would skip some rows?
            double pid= 0
            pid=unique();   \\ generate unique numbe
            DataRow newrow2= dataSet11.Tables["tbl1"].NewRow()

I have filled a dataset.tables("MYTBL") with n records, using the SQLDataAdapter.Fill() method. A Datacol("FNAME") is  defined on the "MYTBL". For a given value , say fn_str, is it possible to find the row number within the Datacol("FNAME") where the value is first available / ...

I am using an OleDb.OleDbCommand to insert a new record using the
ExecuteNonQuery method with an SQL "INSERT INTO" statement.  Is it possible
to somehow retrieve the record/s inserted without having to perform an
additional SQL statement?