Hi, can anyone help me with the following error. I'm trying to do a select * from a table1 to view all the entries using llblgen's method calls and I'm receiving the following error message when I run it:
A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
Unhandled Exception: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Order'.
There is a relationship between 2 tables ie table1 also contains the FK for table2 Here is the section of code that is causing the error.
public void viewTransTable (object sender, EventArgs e)
{
SyTranHDRCollection viewAll = new SyTranHDRCollection();
viewAll.GetMulti(null);
transDG.DataSource = viewAll;
}
thanks
Mike