Different ways for databinding

Question

Hi everyone,

I'm kindda new in working with DB.
As you could guess, pretty soon I found myself working with datagridview <-> DB.

After googeling a little, I see there are few different methods to perform the databinding - bind the datagridview object directly (in its properties), coding SQL connection and adapter, define a stored procedure in the DB, and so on.

Even I guess they all might result the same, I would appreciate if someone could help and settle my mind, putting some order, in regards to the differences as well as pros/cons between these methods.


Moreover, as a rookie, I need to connect to SQL server and Oracle DB (we have at work the both of them). What method whould be recommended for me?

Many thanks in advanced.