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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataGridView / who to update tables with FKs 1
Datagridview Binding/Update Question 3
best practice for inserting rows using a dataAdapter? 8
Clearing row selected from DataGridView 7
Deleting a Row from Datatable and from Database 1
Adding Rows to Data-Bound DataGridView 11
Added Unique Contraint by my DataGridView doesn't seem to know about it... 4
Can't add row to datagridview? 3

Back
Top