Best Practice from Oracle DB to DataGridView

  • Thread starter Thread starter newtonwong
  • Start date Start date
N

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
 
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
 
Back
Top