Database

// Connection string for a typical local MySQL installation<br />
			string cnnString = "Server=localhost;Port=3306;Database=tibia;Uid=client;Pwd=password";<br />
<br />
			// Create a connection object and data adapter<br />
			MySqlConnection cnx = new MySqlConnection(cnnString);<br />
<br />
			// Create a SQL command object<br />
			string cmdText = "SELECT * FROM queue";<br />
			MySqlCommand cmd = new MySqlCommand(cmdText, cnx);<br />
<br />
			cnx.Open();<br />
<br />
			MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(cmdText, cnx);<br />
			string szInsert = "INSERT INTO queue VALUES ('testing')";<br />
			myDataAdapter.InsertCommand = new MySqlCommand(szInsert, cnx);<br />
		<br />
			cnx.Close();