Getting C# and mySQL to play together

with C# / mySQL connector / 2008-01-28

There's plenty of good articles online about getting the busy with C# / mySQL connector. Others include this one at nystic.com, and this one at bitdaddys.com. This is meant to be a sort of "Hello, World" set of instructions.

Download and install the Connector/Net software from MySQL.
In a project in Visual Studio, add a reference to MySql.Data. Project > Add Reference, scroll down and select.
The namespace can be added to your project with: using MySql.Data.MySqlClient;

The following code exemplifies usage of the mySQL component. On a form with a button and a text box:

private void button1_Click(object sender, EventArgs e) {

string Server = "your_server";

string Database = "your_database";

string Username = "your_user";

string Password = "your_password";

string Table = "your_table";

string ConnectionString = "SERVER=" + Server + ";DATABASE=" + Database + ";UID=" + Username + ";PASSWORD=" + Password;

MySqlConnection connection = new MySqlConnection(ConnectionString);

MySqlCommand command = connection.CreateCommand();

MySqlDataReader Reader;

command.CommandText = "select * from " + Table;

connection.Open();

Reader = command.ExecuteReader();

textBox1.Text = "";

while (Reader.Read())

textBox1.Text += Reader.GetValue(i).ToString() + "n";

connection.Close();

}

TI-83 Plus Black Scholes (914)

Plug n play / 2009-06-16

A sloppy implementation of Black Scholes on the TI-83 Plus. Read.

Getting C# and mySQL to play together (1188)

with C# / mySQL connector / 2008-01-28

For that project where using MS SQL isn't going to cut it. Read.

Anatomy of a Major League Baseball tryout (2163)

"Ohhh. Let me see that." / 2007-03-12

For the most part, we took it seriously. Read.

Ubuntu 6.06 LTS (Dapper Drake) on Acer Travelmate C110 (13688)

It's thin, it's light. It's a tablet. / 2006-10-18

There's nothing cooler than a really small machine running linux. This is a collection of notes from the install, setup, and tweaking of the system running Ubuntu 6.06 LTS (Dapper Drake). It's probably a little over verbose. Read.