I have posted an article on code project on how to use ODBC.NET and a DataAdapter with a DataGrid. You can switch out the DataGrid and use the Syncfusion Grid quite easily.
http://www.codeproject.com/useritems/ODBCnet_syb_stp.asp
Many thanks to Clay @ Syncfusion for his help with this. If anyone knows how to get the Update working please reply to this post.