is there an easy way to find the index of a string?

Kalzenith · #1 (**permalink**) 11-02-2009, 12:03 PM

in C# i was wondering, if i had a table defined like this

FXCore.TableAut Trades = (FXCore.TableAut)tradeDesk1.FindMainTable("trades" );

is there any way i can do somrthing like this?

Trades.IndexOf("String")

what i need, is a way to find the row containing a specific OpenOrderID without passing the whole table to an array or list if at all possible

edit: sorry, i think ive already answered my own question with the FindRow function.. am i right in assuming that is the function i need? and if im right, how do i use the function? i need to find the row of a specific OpenOrderID, it returns an object but i just need the row number as an integer and i keep getting this error

Unable to cast COM object of type 'System.__ComObject' to interface type 'System.IConvertible'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{805E3B62-B5E9-393D-8941-377D8BF4556B}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

uint d = Convert.ToUInt32(Trades.FindRow("OpenOrderID", "4975537", 0));

Kalzenith · #2 (**permalink**) 11-02-2009, 02:24 PM

i also tried this

uint d = (uint)Trades1.FindRow("OpenOrderID", "4975537", 0);

but it told me "Specified cast is not valid."

Kalzenith · #3 (**permalink**) 11-02-2009, 04:42 PM

ive found another thread pertaining to findrow(), it apparently returns the row, not the index of the row which i believed. so i just wrote a for loop to search the table for the OpenOrderID

for (uint h = 1; h < Trades.RowCount; h++) if ((string)Trades.CellValue(h, "OpenOrderID") == TradeArray[g, 0]) index = h;

fexxxer · #4 (**permalink**) 11-03-2009, 10:55 AM

If you want to find a specific row, you can do it like this:

Finding a QuoteID for specific instrument:

Code:

string instrument = "EUR/USD";
FXCore.TableAut offers = (FXCore.TableAut)tradeDesk.FindMainTable( "offers" );
FXCore.RowAut row = (FXCore.RowAut)offers.FindRow("Instrument", instrument, 0);
string quoteId = row.CellValue("QuoteID").ToString();

You're getting errors cause you're casting returned objects into incorrect data type. Method .FindRow() returns a "FXCore.RowAut" not integer.

Hope it helps,

Cheers

Kalzenith · #5 (**permalink**) 11-03-2009, 01:55 PM

thanks for the reply

yeah i figured out how the findrow() function works, unfortunately the row is not what i need, what i needed was the row number that the data was found on, the way i did that was just by querying each row individually in a for-loop statement.. not what i was hoping for but it worked, and in one line of code too.