Looking for Sample Code for displaying row entries

[Martijn Damen]

Hi,

I just started with the mysql .NET API and have managed to create a connection to my database. Now I want to extract some info and display it in a simple winform application, but here I'm getting into trouble.

Sofar I have the following code:

using Mysql.Data.MySqlClient;

...

private void Form1_Load(object sender, System.EventArgs e)
{
string myConnectionString = "Database=damen;Data Source=server User Id=user;Password=pass";
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
string myQuery = "SELECT Tiefe FROM Logbuch WHERE Nr=1";
MySqlCommand myCommand = new MySqlCommand(myQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteReader();
myCommand.Connection.Close();
}

With this I get no errors whatsoever, but how can I get the results of ExecuteReader(); in a form that I can actually use to manipulate or display the data?

Hope one of you guys can post some sample code, thanks in advance!

Enjoy your day!

Cheers, Martijn
www.dusja.net