Berikut ini adalah code yg digunakan untuk menampilkan data hierarchical dengan ultrawingrid..

ultrawingrid merupakan salah satu komponen Infragistics yg digunakan untuk menampilkan data. Data yang ditampilkan mungkin agak berbeda, karena bisa ditampilkan seperti windows explorer( treeview )..

ini adalah code na untuk hasil tampilan di atas :

[code]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Infragistics.Win.UltraWinGrid;

namespace Infragistics
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
string source = "server=localhost; integrated security=SSPI; database=Northwind";

SqlConnection conn = new SqlConnection(source);// untuk linking database

DataSet myDataSet = new DataSet();

/*

dataset adalah sebuah object, yg isinya adalah tabel - tabel, dan juga relasinya..

*/

conn.Open();

SqlDataAdapter dataAdapter = new SqlDataAdapter("Select * from TrHeaderPeminjaman", conn );
/*

dataadapter adalah sebuah object yg berfungsi untuk menyimpan database yg telah kita akses menjadi object di dlam variabel.. jadi kita tidak berhubungan terus dengan database. Database pertama dibaca, kemudian yg hendak kita ambil isinya, dimasukkan di dalam dataadapter..

*/
dataAdapter.Fill(myDataSet, "TrHeaderPeminjaman");

dataAdapter = new SqlDataAdapter("SELECT * FROM MsCustomer", conn);
dataAdapter.Fill(myDataSet, "MsCustomer");

dataAdapter = new SqlDataAdapter("SELECT * FROM MsKaryawan", conn);
dataAdapter.Fill(myDataSet, "MsKaryawan");

//DataRelation r1 = new DataRelation("relation1", myDataSet.Tables["TrHeaderPeminjaman"].Columns["KdCustomer"], myDataSet.Tables["MsCustomer"].Columns["KdCustomer"]);
//DataRelation r2 = new DataRelation("relation2", myDataSet.Tables["TrHeaderPeminjaman"].Columns["KdKaryawan"], myDataSet.Tables["MsKaryawan"].Columns["KdKaryawan"]);

myDataSet.Relations.Add("relation1",myDataSet.Tables["TrHeaderPeminjaman"].Columns["KdCustomer"], myDataSet.Tables["MsCustomer"].Columns["KdCustomer"]);
myDataSet.Relations.Add("relation2", myDataSet.Tables["TrHeaderPeminjaman"].Columns["KdKaryawan"], myDataSet.Tables["MsKaryawan"].Columns["KdKaryawan"]);

//ultraGrid1.DataSource = myDataSet;
//ultraGrid1.DataMember = myDataSet.Relations[0];

conn.Close();

ultraGrid1.DataSource = myDataSet;

}

}
}

[/code]

Greetings, one and all. I had been added to the blog as an author a couple of months ago, but haven't managed a word since. Profound apologies for that. Saying that I got married and was carried away with that may sound like an excuse, but I don't think so myself.

In his generous introduction, Jai had mentioned that I hail from Trivandrum. Beyond that I am a management professional, an ex-strategy consultant, with a deep interest in all things civil, massive and tall. Right now I work for one of the world's top property development firms which has recently entered India (hush-hush, but they are building something which just beat the pants off Taipei 101....lol!)

I will try and maintain a regular update of the vertical and horizontal happenings from Trivandrum and the rest of Kerala.

Trivandrum is a city of over a million people and the greenest of its size in the country. It is the capital of Kerala and traces its history back nearly 2000 years, having been the capital of many a powerful kingdom. It is one of the most popular tourist destinations in India with its combination of beautiful beaches, culture, architecture and much more.

Of late, it has also become a top Tier II IT destination. The Technopark, located here, is the largest single IT park in India with over 3.5 million sq.ft of completed space and another 4 million sq.ft in various stages of development. Its tenants include Infosys, TCS, UST Global, IBS, Mckinsey, E&Y, Allianz, Tata Elxsi, NEST, McFaden, Office Tiger and more than 125 other firms from across the world. Last year IT exports reached Rs 1200 Crores placing it just behind Kolkata in the pecking order and 18,000 IT/ITES professionals are employed here as of today. Technopark has an aggressive growth plan charted out, which will make it one of the largest IT/knowledge ecosystems in the world with an extent of close to 1000 acres. You can read more at the Technopark thread at Skyscrapercity.com

The city also hosts a major cluster of research institutions in the aerospace, computer sciences, electronics, biotechnology and medicine. They include the Vikram Sarabhai Space Centre, Centre for Development of Advance Computing, Centre for Development of Imaging Technology, National Institute of Interdisciplinary Science and Technology, Centre for Earth Science Studies, Tropical Botanical Garden, Rajiv Gandhi Centre for Biotechnology, Sree Chitra Tirunal Institute of Medical Science and Technology and so on.

Another facet of Trivandrum is the presence of many top-class educational institutes including the Indian Institute of Space Technology, Indian Institute of Science, Education and Research, Indian Institute of Informationa Technology and Management, the College of Engineering Trivandrum, Trivandrum Medical College, Kerala University, Asian School of Business and Kerala Agricultural University. The city has no less than 17 engineering colleges, 4 medical colleges, 30-plus arts and science colleges, 30 central syllabus schools and an international school.

And each of these institutions are housed in their own campuses whose architecture ranges from traditional Kerala styles to post-modern designs.

Traditionally a laid-back, scenic city known for its intellectual and cultural prowess, Trivandrum is now rapidly advancing to meet and become part of the explosive growth story that is India. I look forward to sharing this saga with all of you going forward.

For more updates, do go through the Trivandrum thread at Skyscrapercity.com

Quick Updates:

1. The first phase of the 450,000 sq.ft. campus of IBS, a leading global player in the travel and logistics domain, was inaugurated in Technopark last month.
2. The work on the 1.5 million sq.ft. campus of UST Global, a US-based IT major, was inaugurated by the Kerala CM at Technopark Phase II.
3. The civil structural work of a 460,000 sq.ft IT park by the Leela Group is nearing completion at Technopark Phase I and is due to be finished by Dec.
4. The final date of submission of bids for the Rs 5300 Crore Vizhinjam deepwater container transshipment port was shifted to Dec 15 after international and Indian firms requested more time to prepare bids for India' deepest port. As many as 34 firms including the likes of PSA, Maersk, Rotterdam Port, Reliance, Gammon and so on are in the running for the mega-project.
5. The Union Minister of Civil Aviation, Praful Patel, announced that GoI would invest another Rs 500 Crores into the expansion of the Trivandrum International Airport, where work on a Rs 250 Crore terminal is in progress.
6. The Govt. of Kerala is poised to commence development of the 100 acre Technopark Phase III and the 500 acre Phase IV - also referred to as the Technocity Project.
7. Technocity is expected to garner an investment of over Rs 6000 Crores and become one of the biggest IT parks in the world. Leading international and national developers have expressed interest in the mega-project. More news about the project at the Technocity thread at Skyscrapercity.com

Stay tuned for more, in a few days time! Thanks for reading and take care. See you all soon!

Satu lagi putra Indonesia yang berhasil menorehkan prestasi luar biasa di kancah Internasional. Dia adalah Junius Albertho mahasiswa Jurusan Ilmu Komputer, Universitas Sumatera Utara yang berhasil menjuarai kompetisi coding dunia atau yang dikenal dengan TopCoder Collegiate Challenge 2007 yang dilaksanakan di Disney World, Orlando, Amerika Serikat dan di sponsori oleh Lilly, Deutsche Bank serta NSA. Read the rest of this entry »

Tadi pagi (Jum'at, 30 November 2007) saya memberikan presentasi tentang perkembangan teknologi informasi dan bisnis di UNPAR. Acaranya diadakan oleh Himpunan Mahasiswa Program Studi Teknik Industri (HMPSTI), Universitas Katolik Parahyangan, Bandung. Judul acaranya "educathree" (entah mengapa demikian? mungkin ini acara yang ketiga?).

Sebetulnya pagi ini saya masih agak teler dan hidung meler. Untungnya suara masih ada karena sehari sebelumnya tenggorokan sakit. Setelah badan digosok minyak kayu putih, saya berangkat ke tempat presentasi. (Maaf yang terganggu dengan "parfum" ini. Apa boleh buat. he he he.)

Acara dimulai tepat waktu dan saya memulai presentasi jam 8:30 pagi. Setelah saya pak Reyhan dari Telkomsel bercerita tentang sistem electronic payment t-cash milik Telkomsel yang baru diluncurkan hari Selasa kemarin. Acara tanya jawabnya berlangsung cukup baik. (Dalam update berikutnya akan saya coba tampilkan pertanyaan dan jawaban saya di sini. Itu pun kalau sempat. Nggak janji ya. hi hi hi.)

Materi presentasi dapat diambil dari web saya, budi.insan.co.id, pada bagian presentations. Selamat menikmati.

Seperti biasa, saya tidak punya foto yang bisa ditampilkan di sini. Kalau ada adik-adik panitia yang punya fotonya, bisa dong dibagi.

Kao i dobar dio Techno frikova ili prihvatljivije Techno Nomada i sve većom popularizacijom prijenosnika ostao sam pomalo zatečen definitivno NAJPOVOLJNIJOM cijenom prijenosnika do sad viđenoj, a u ponudi HGspot-a objavljenoj u ''24 sata'' točnije Extra TEHNOMAGAZIN ''24 TEHNO'' ;D
U oglasu HGspota poznatom po cijenama relativno prihvatljivim za Hrvatska primanja (HGspot je poznat po iznimno lošoj korisničkoj podršci i prozvan ''HGšrot'' u krugovima koji su imali posla sa njihovim servisima i svima onima kojima je trebala asistencija istih) stoji posebna ponuda ...

PRIJENOSNO RAČUNALO
HP nx6515s, AMD Turion64 X2 1.9GHz, 15,4" WXGA 1280x800, RAM 1GB, disk 160GB, OS FreeDOS 2499kn

Lijepa cijena zar ne? Tko god je to vidio sigurno si je odmah pomiso ''Super, novi Laptop ;D'' neki su možda išli zvat HGspot rezervirat jedan primjerak za sebe, možda i više njih ;) no naravno u HGspotu niti igdje drugdje na netu nitko nema pojma o dotičnom modelu HP-ovog prijenosnika ;D hehehe ... Na Newsima sam čak pročitao ''Matija: eto raspitao se, netko ih zahebava i dao lazni oglas, taj model ni ne postoji '' ... Naravno da ne postoji!
O čemu je tu riječ i tko je koga zapravo pravi budalom??? Radi se o dobrom MARKETINGU točnije o marketinškom triku jer svi koji se bave prodajom i marketingom negdje u kutu jako sitnim slovima napišu da 'ne odgovaraju za eventualne tiskarske greške' ... naravno da neće odgovarat nisu blesavi, najlakše se izvadit na tiskarsku grešku, no kako god bilo takav jedan ''kvalitetan'' marketinški potez napravit će svoje kako god okrenuli i povećat broj posjeta na stranice dotične tvrtke HGspot Online i povećat broj posjeta njihovim dućanima diljem hrvatske. Uostalom tko nebi kupio prijenosnik i još izvrsne konfiguracije za prihvatljivih 2499 kn s obzirom kakve su nam plaće? Hrvatska je željna potrošačke elektronike po prihvatljivim cijenama, većina ima MP3 player ili mobitel s mogućnosti reprodukcije omiljenog glazbenog formata, pa tko nebi htio dobar Laptop i još k tome Brand name kao što je HP ''Hewlett-Packard'' za tako povoljnu cijenu!
E sad jedno malo prosvjetljenje ... svima koji su se našli u nedoumici i zbunjeni zbog tog istog prijenosnika ;) ...

HP Compaq 6715s (GR795ES) temeljen na AMD tehnologiji Turion X2, 1 GB RAM memorije, 15.4“ WXGA Brightview ekran, 160 GB HDD (opremljen sustavom zaštite od fizičkih oštećenja [najvjerojatnije je riječ o zaštiti diska zaključavanjem glave diska], DVD-RW sa LightScribe-om za prženje na gornju stranu DVD-a, Wi-Fi WLAN (bežična mreža).

Cijena ovog prijenosnika je 4.899 kn sa PDV-om u HGspot-u, što je kad se sve zbroji opet relativno prihvatljiva cijena za gornju konfiguraciju, jedino što ja svejedno nisam na HP-ovim stranicam uspio pronaći detaljne specifikacije za ''GR795ES'' jer isti model ne postoji (ili nije izlistan na njihovim stranicama - što je čudno s obzirom da si HP nebi smio dozvoliti takvo sramoćenje Branda). No ako svejedno nekoga zanima više o prijenosniku HP Compaq 6715s neka pogleda link (HP preporuča cijenu 6216 kn s PDV-om, sa predinstaliranim OS-om ''Genuine Windows Vista® Business). Link na ''FANTOMSKI'' HP Compaq 6715s (GR795ES) potražite na HGspot-ovim stranicama u članku sa naslovom ''Posebna ponuda HP prijenosnih računala samo u HGspot centrima'' [još samo kad bi se naučili prilagodit javascript pop-up przorčić specifikacijama proizvoda, no valjda bi dobili kugu ili kakvu drugu bolest, ili nedaj bog pomislili da neke ljude zanima na što će potrošit novac] ...

APDEJT:
Pronađoh još jednu sličnu konfiguraciju prijenosnika HP 6715b GR794ES u Ve-Mil-u po cijeni od 5.299,01kn (gdje nađoše ovu jednu lipu da mi je samo znati), a specifikacije bez OS-a možete pogledati ovdje, a ovaj ima čak i BlueTooth. ;D

If you thought you were safe from online advertisements when you clicked on a pdf file, you are sadly mistaken. Adobe and Yahoo have partnered to insert advertisements into pdfs. Publishers will upload their documents to Adobe who will analyze them to see which ads should be added. The document will then be made ad-friendly and sold to advertisers.

While the idea is still in beta phase and only open to certain advertisers, it will soon be open to everyone. 

Che ruolo hanno le aziende nel mondo Open Source? Hanno rapporti con la community? Il sito ICTv.it pubblica un video con un'interessante intervista a Bob Alexander, Executive IT Architect di IBM: viene definito qual'è il ruolo di IBM nell'Open Source e cosa deve considerare un'azienda che vuole operare in questo ambito e implementare l'Open Source al suo interno. Il link è questo (sfortunatamente non posso integrare il video sul blog, dato che Wordpress, purtroppo, non sopporta il Java).

Quick quiz to start things off: Who is the market leader in the enterprise software space? If you guessed Oracle, IBM and SAP, you got 5 points and a bonus. Question 2: who rules the consumer space? 5 points if you guessed Google and an extra 1 if you added Microsoft. Question number 3: who is the market leader in SMB? If “let me think” is your answer, you are in good company (and you got 2 points for having a brain...). So how come such a large market doesn't have a market leader? Read the rest of this entry »

Un anno fa abbiamo lanciato l’iniziativa Regala Flickr — un modo facile e veloce per donare un account Flickr pro agli amici e alla famiglia. Quest’anno, alla gioia di chi riceve un anno di pro, si aggiunge anche un piccolo omaggio per chi fa il regalo.

Per ogni anno di pro acquistato da oggi fino al 31 gennaio 2008, riceverai, infatti, 3 mesi di Flickr pro. Per esempio, se regali 4 pro ai tuoi amici, riceverai subito un anno gratis! Non è fantastico?

Per maggiori informazioni, visita Regala Flickr.

Foto di Nigel Dourley.

A business partner recently sent over a very interesting article from ZDnet with a subjective list of the all-time greatest IT disasters. The article lists events ranging from Y2K to AT&T's switch catastrophe in the early 1990's. Other than the obvious information technology history 101, what does it really mean to me? What do I care? This is the question I always ask, and always look for an appropriate answer... I am often surprised at how much I really do care, because of the lessons learned.

Article link here...

We often talk about "system risk" as the most prevalent type of operational risk within the information technology industry.  In the early 1980's, the Soviet Union found itself at the cusp of creating a virtual Hiroshima due to a software bug in its early warning system.  Because of this bug, the Soviet system indicated that the United States had fired five ballistic missiles, which did not actually happen. What we fail to discuss often enough are "external event risks" beyond the cookie cutter principles around disaster recovery. A single bug in a system could have triggered historical effects on the nature of world politics. Lives would have been lost, countries wiped off the map, and the safety of human kind were at stake. Luckily, there were process and system controls in place, along with a quick thinking Russian,  to catch this gap. And we are still breathing because of it. Most operational losses are actually prevented when risk management is successful, but measuring success is difficult. In this example, I think it is obvious that the potential loss would have been immeasurable.

In 1990, AT&T's network collapsed when one single switch within its network experienced a malfunction and over 75 million customers were impacted. This represented only 0.87% of AT&T's switching centers, yet the operational loss was drastic. Not only this, but upon restoration, all upstream and downstream systems then experienced outages. One single line of code caused this meltdown. One of AT&T's largest customers at the time, American Airlines, lost over 200,000 reservations due to this bug. This is a direct example of how better testing, and end to end perspective, and increased scrutiny over controls could have reduced these operational losses. The result of the collapse was a damaged reputation for AT&T and its customers, and significant financial loss.

These examples contrast situations where operational loss was prevented, and operational loss was realized. In both cases, it emphasizes the need for improved operational risk management, but in the haste to avoid future losses does this always mean improving operational risk management should lead to an independent and centralized function? Absolutely not! In fact, I feel quite the contrary. A centralized operational risk function is great to ensure that there is a place to pull back in the single view for an organization. Additionally, there must be some organizational level that has the ability to seek the risk appetite for its business. But, the true success of operational risk management is based on the ability for worker bees to understand the potential for operating loss, to know what they can do to contribute to the success or failure, and to be able to partner with their business to find the optimal risk/reward balance.

We often find ourselves backed into this corner because we constantly push the theme of reducing risk. In a very conservative world, this is wonderful. But in the business world, our goal should be to maximize our reward, based on our risk appetite, while taking risk into consideration. This risk/reward balance is the most important part of managing operational risk. The right answer is not always to reduce risk. The right answer is not always to do nothing. The right answer is understanding your business, and its appetite for risk tolerance. This balance is the only way that publicly held companies can provide an appropriate return to its shareholders, while ensuring that risks are mitigated appropriately. (notice I did not use the word remediate)

The most difficult part of getting to this target state is influencing others to articulate their risk appetite. Educating others on potential for operating loss is challenging, because the first question that pops into their head is “why should I care?”  If you can’t explain why they should care, then they can’t articulate their risk appetite.  Then you move to the inevitable question, "how probable is it that this will happen?" The answer may very well be "not probable at all", or “We really don’t know, we can’t measure it” but what-if... just what-if that slim chance did occur? Will we be ready? Will we have addressed the controls that would need to be put in place? (regardless of whether they have actually been put in place)

The last thing I'd like to add to this rant is that this concept is applicable regardless of industry. The idea of finding the optimal risk/reward balance for your business and working towards that balance is crucial in every industry. Avoiding excessive risk and/or excessive controls is the game we will play for eternity. Those who know where that point is are experts - those who can actually get their organization to that point are pioneers.