[CSharp] MySQL 접속 처리

using (dbConnection = new MySqlConnection("Server={0}Port={1};Database={2};Uid={3};Pwd={4}"))
{
	try
	{
		/* INSERT, UPDATE 처리 */
		dbConnection.Open();
		dbQuery = string.Format("UPDATE `table` SET colume = '{0}' WHERE idx = '{1}'",
				VALUE, IDX);
		dbConnection.Open();
		dbCmd = new MySqlCommand(dbQuery, dbConnection);
		dbCmd.ExecuteNonQuery();
		dbConnection.Close();
		
		/* bind 형식 */
		dbConnection.Open();
		dbQuery = "INSERT INTO log (`content`,`ip`,`creator`) VALUES (@content,@ip,@creator); ";
		dbCmd = new MySqlCommand(dbQuery, dbConnection);
		var bind1 = new MySqlParameter("@content", this.logString() + TEXT +"했습니다.");
		dbCmd.Parameters.Add(bind1);
		if( dbCmd.ExecuteNonQuery() == 1)
		{
			//성공
		}
		dbConnection.Close();
		
		/* SELECT */
		dbConnection.Open();
		dbQuery = string.Format("SELECT * FROM `table` WHERE idx = '{0}'; ", IDX);
		dbCmd = new MySqlCommand(dbQuery, dbConnection);
		dbTable = dbCmd.ExecuteReader();
		if (dbTable.HasRows)
		{
			while (dbTable.Read())
			{
				dbTable["cnt"].ToString().Trim();
			}
		}
		
		
	}
	catch (MySqlException db_ex)
	{
		MessageBox.Show(db_ex.Message, "경고");
	}
	finally
	{

	}
}