Best Practice from Oracle DB to DataGridView

[newtonwong]

Hi,

I'm wondering whats the best practice to accomplish the following
display in a DataGridView.

1. Perform a Query to an Oracle DB with a multiple join select that
returns multiple rows. (Should I use a DB object i.e. Stored Procedure,
Function, View, or nothing)

2. Bind the rows/data to a DataGridView via DataAdapter or
DataTable/Set.

What is most people/the best practice for doing the listed? I heard
using ref Cursors but they cause headaches. Is there a practice that
allows me to do everything via the VS2005 IDE?

Thanks in advance.

Newton

 

[Cor Ligthert [MVP]]

Newtonwong,

You asked for the best practise.

Very very often is written in this newsgroup from more than one regular.

"Do not use Joins with dataadapters"

Cor