I have a simple query that I need to bind to a datagrid for viewing. I have seen several tutorials but not many using MySql. I need to be able to bind this using my query method below. Can someone help me out here. I could figure it out eventually but really don't want to waste much time on this.
The query method I use works, but how do I bind the results to the datadridview control.
private void SetHistoryListView()
clsMySqlODBCConnection MySqlCnn = new clsMySqlODBCConnection();
string strQry = null;
int tserialnumber = 0;
strQry = "Select * FROM HIstory WHERE SerialNumber = " + tserialnumber + "";
datagridView.DataSource = 1;