Pass DataGridView's reference

Question

1.00/5 (1 vote)

See more:

I am going for the transition from VB6 to DotNet.
I am working on a generalized code to export DataGridView Control.
How can I pass the reference of the control to the routine exporting the values to Excel?

Posted 19-Jun-11 1:11am

u2q_65

Updated 19-Jun-11 1:12am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-06-19T01:30:00

Depends what you want to do with it: If you just want to access the control and get data from it, you just have to declare a DataGridView parameter:

Private Sub WhatEver()
	ExportDateToExcel(myDataGridView)
End Sub
Private Sub ExportDataToExcel(dgv As DataGridView)
	Dim rows As DataGridViewRowCollection = dgv.Rows
End Sub

Simon_Whale · Answer 2 · 2011-06-19T03:36:00

Solution 2

To Add to Griff's answer make sure that you use a byref keyword when declaring the Datagrid argument else the compiler makes its a ByVal object.

VB

private Sub ExportDataToExcel(Byref dgv as DataGridView)
  'do work here
end sub

Posted 19-Jun-11 3:36am

Simon_Whale

u2q_65 · Answer 3 · 2011-06-19T18:16:00

Solution 3

The problem is that I cannot get the statement "Byref dgv as DataGridView" in ExportDataToExcel subroutine.
I beleive, I have to put some Imports statements in the class module.
What are those statements?

Posted 19-Jun-11 18:16pm

u2q_65

Comments

Simon_Whale 20-Jun-11 7:14am

What does your subroutine header look like? is it in a class? module? or form?

u2q_65 20-Jun-11 7:30am

Thanks.
Its in a module.
But it will be good if class type is also answered.