Home Notices Documents Classes Download Others Rice
Classes  >  dbreader  >  Ordinal(string)
dbreader class : Ordinal(string) method

Description

Gets the index of a column specified its name.

Syntax

dbreaderInstance.Ordinal(string columnName)

Arguments

ClassNameDescription
stringcolumnNameThe column name.

Return value

ClassDescription
intA column number.

Sample code

1:

connection cnn = new connection("Data Source=c:\somedirectory\somedatabase.sqlite3;Version=3;");

2:

cnn.Open();

3:

command cmm = new command("select * from sometable where id < 100;", cnn);

4:

dbreader dbr = cmm.Reader(); // Command execution. A multi-line result is returned.

5:

int columnNumber = dbr.Ordinal("shop");

6:

dbr.Release();

7:

cmm.Release();

8:

cnn.Close();

9:

cnn.Release();

Notes

Returns the index (zero based) if the column exists. Otherwise -1 is returned.

Links for reference

None.

Copyright © Rice All rights reserved.