I´m using MySQLDirect .NET 2.70 TRIAL-Version and there a problems with the MySqlDataReader().
Code: Select all
MySqlCommand myCmd = new MySqlCommand();
try
{
myCmd.Connection = DBBau._MySQLConnect;
MySqlDataReader myReader;
myCmd.Connection.Open();
myCmd.CommandText = mySelect;
myReader = myCmd.ExecuteReader();
if ( myReader.HasRows )
{
while ( myReader.Read() )
{
/// Tabellen- und Bedingungen lesen
myTable1 = myReader.GetValue(2).ToString();
myTable2 = myReader.GetValue(3).ToString();
myTable3 = myReader.GetValue(4).ToString();
myBedin1 = myReader.GetValue(5).ToString();
myBedin2 = myReader.GetValue(6).ToString();
myBedin3 = myReader.GetValue(7).ToString();
myOrder1 = myReader.GetValue(12).ToString();
myOrder2 = myReader.GetValue(13).ToString();
myOrder3 = myReader.GetValue(14).ToString();
SortOrder = myReader.GetValue(15).ToString();
/// Feld-Array mit Informationen füllen
FieldArray[arrayCounter] = myReader.GetValue(8).ToString();
arrayCounter++;
}
myReaderOK = true;
}
myReader.Close();
}
finally
{
myCmd.Connection.Close();
}
Is it a limitation of the TRIAL-Version???
If so, i could stop testing the TRIAL, cause it took a lot of time to convert my code.
If not, where is the problem in my Code, which works fine with ByteFX and .NET-Connector?
thx for answering
jlo - germany