I'm using the dotConnect for Oracle drivers in my C# application. I've got my Table Adapter working, and executing a custom query of mine. I'm able to see the results, in code, by looping over the Rows DataRowCollection object.
But, I see that there is a provided Row class - in my case USERSRow. I'm trying to figure out how to use this class with the results from the query. This would be nice so I can reference the columns by property name rather than an obscure index value in the DataRowCollection array.
How do I make use of this class? Here's my small chunk of code. Thanks in advance!
Code: Select all
// Perform the query
USERSTableAdapter usersAdapter = new USERSTableAdapter();
DataArchive.USERSDataTable usersTable = usersAdapter.GetData(this.Username.Text, this.Password.Text);
if (usersTable.Rows.Count == 1)
{
// Successfull login attempt
}