No database selected??

[Ikke]

Hi everybody,

At the moment I'm trying to figure out how to access my local database
via C#. So far, I've succeeded in connecting and retrieving records. The
results are displayed in a datagrid.

However, when I load the results again, I get an error:
Unhandled Exception: Microsoft.Data.Odbc.OdbcException: ERROR [HY000]
[MySQL][MyODBC 5.00.11][MySQL] 1046 No database selected

Clearing the datagrid doesn't help (which is to be expected I suppose),
but I cannot fathom why it works the first time but never the second.
Could anybody please shed some light on this issue? What am I doing wrong
here?

Thanks!

Here is my code, it's executed whenever I press the "load" button:
/* code */
string myConnectionString =
"DSN=TgpCelebrity;UID=TgpCelebrity;PWD=tcAdmin ";
OdbcConnection MyConn;
OdbcCommand MyCmd = new OdbcCommand();
MyConn = new OdbcConnection(myConnectionString);
MyConn.Open();
MyCmd.Connection = MyConn;
StringBuilder SQL = new StringBuilder();
SQL.Append("SELECT ");
SQL.Append(" link ");
SQL.Append("FROM ");
SQL.Append(" links ");
MyCmd.CommandText = SQL.ToString();
OdbcDataReader result = MyCmd.ExecuteReader
(CommandBehavior.CloseConnection);
int nResultCount = 0;

DataTable table = new DataTable();
table.Columns.AddRange(
new DataColumn[]
{
new DataColumn("links", typeof(System.String))
}
);

object[] values = new object[1];

while (result.Read())
{
result.GetValues(values);
table.Rows.Add(values);
nResultCount++;
}
System.Console.WriteLine(nResultCount + " links found!");

table.AcceptChanges();
dataGrid1.SetDataBinding(table, null);

MyConn.Close();
/* end code */
Best regards,

Ikke