Ordinal Numbers

Similar Threads:

1.ordinal number

Hi,

Is there a way to read out the ordinal number of a control in existing 
VB applicaion at run time, like in VisualTest(_ord())?

Thanks!

b

2.retrieving ordinal number

Hi,

Is there a way to read out the ordinal number of a control in existing 
VB applicaion at run time, like in VisualTest(_ord())?

Thanks!

b

3.Format Ordinal date in Report using Visual Basic

4.SqlDataReader accessed only by field ordinals?

I notice that using the SqlDataReader requires the use of ordinal field 
references rather than by name.
For example,

      do while (myDataReader.Read())
        Console.Write(myDataReader.GetInt32(0).ToString() + Chr(9))
        Console.Write(myDataReader.GetString(2) + " " + 
myDataReader.GetString(1) + Chr(9))
        Console.Write(myDataReader.GetString(3) + Chr(9))
        if (myDataReader.IsDBNull(4)) then
          Console.Write("N/A" + Chr(10))
        else
          Console.Write(myDataReader.GetInt32(4).ToString() + Chr(10))
        end if
      loop

Is there a way for me to read data from SQL by field name (ie: column name) 
rather than by ordinal? It is much easier to program this way and also 
handles situations where fields have been inserted or otherwise changed 
position in a table.

Thanks in advance,

Tom

5.how to get true ordinal of Excel Table

"Tim_Mac" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
> hi,
> i am importing excel data through a web form, using ADOX.
> i only want to grab the first worksheet, but unfortunately if the user
> re-arranges the worksheets in the excel file, the ADOX Catalog.Tables
> collection still presents the tables in the original order of the
> worksheets.
>
> does anyone know how to identify the ordinal of an excel
> worksheet, as it appears to the user when the file is open?
>
> thanks
> tim.
>
> if it is of relevance, the c# code i'm using is below:
>
> ADOX.CatalogClass cat = new ADOX.CatalogClass();
> ADODB.ConnectionClass connAdox = new ADODB.ConnectionClass();
> string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=\"" + path + "\";Extended Properties=Excel 8.0;";
> connAdox.Open(connectionString, "admin","",0);
> cat.ActiveConnection = connAdox;
> DataSet ds = new DataSet();
> OleDbConnection connOleDb = new OleDbConnection (connectionString);
> connOleDb.Open();
> cat.Tables[0]... etc. etc.  // isn't the first worksheet in the file
>

If you are using C# then posting to this newsgroup is not appropriate.

However, in any case you will be better off asking in an Excel newsgroup.

-ralph

6. ADOX: how to get true ordinal of Excel Table

7. Item cannot be found in the collection corresponding to the requested name or ordinal

8. Ordinal Position in Access DB