• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Pass OledbConnection in between forms

Hello all,

I need to know how to pass a connection (or datareader etc.) between forms in vb.net.

I have 2 forms, on the first one the user drags text from a datagrid and drops it into a listbox. On the drop I open a connection and search for results from a database. If there is only 1 result then the result gets added to the listbox, however, if there is more than one result i want to open another form displaying the results for the user to select from.

I'd prefer to use the same connection I've already opened on the first form on the second form as well rather than opening another connection.

Is there any way to do this other than declaring a public connection in a module?

Alternatively, can I do the search on the first form to a datareader or dataset and then pass this to the second form?


1 Solution
If lets say that form2 has a datagrid you want to fill with the results from the first form you can do something like this


^Pseudo Code
dim ds as new dataset
'your search
if ds.rows.count > 1 then
  dim f as new form2
  f.datagrid1.datasource = ds.tables(0)
elseif ds.rows.count = 1 then
  'add to listbox
  'no rows found
cpk68Author Commented:
Thank you kindly. Almost too simple :o)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now