Best Practice from Oracle DB to DataGridView

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

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

<newtonwong@gmail.com> schreef in bericht
news:1158186290.713440.194840@i42g2000cwa.googlegroups.com...
> 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
>