pass & return datagrid on a function

Question

5.00/5 (1 vote)

See more:

Hi I've used this code for so long

VB

Public Sub ShowDataTable(Optional ByVal field As String = "*", Optional ByVal range As String = Nothing)
    SQL = "CALL Phonedb.MyPhonebook('" & field & "','" & range & "')"
    Dim ds As New DataSet
    Using condb As New MySqlConnection(con)
        condb.Open()
        Using cmd As MySqlCommand = condb.CreateCommand
            cmd.CommandText = SQL
            Using sqlAdapter As New MySqlDataAdapter(SQL, condb)
                sqlAdapter.Fill(ds)
            End Using
        End Using
        condb.Close()
    End Using
    DTG.DataSource = ds.Tables(0)
End Sub

and I wan't to try to make it as a Class/sub
my quest is how can i Pass datagridview on a function/sub and return it ?

adding parameters on a Sub is my problem

Public Sub ShowDataTable(ByVal STRD As String, ByVal conStr As String)

Posted 10-May-13 19:08pm

iMaker.ph

Updated 10-May-13 19:28pm

v3

Add a Solution

1 solution

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)

Mohammed Hameed · Answer 1 · 2013-05-10T19:40:00

Solution 1

There is a class called DataGrid, which you can use as a type to send in you method as a parameter and also you can return the same. I'm not much familiar with the VB but anyhow I have given example method in C#, which would obviously can help u to implement the same in VB.

public DataGrid SomeMethod(DataGrid dg)
        {
            DataGrid grid = new DataGrid();
            grid.AllowPaging = true;
            return grid;
        }

Posted 10-May-13 19:40pm

Mohammed Hameed

Comments

iMaker.ph 11-May-13 2:31am

thanks I'll give it a feedback :)

Mohammed Hameed 11-May-13 2:32am

You're welcome!!!

iMaker.ph 11-May-13 2:41am

how Can I implement your code ?

if I add dg as datagrid it says that Datagrid is not define.

Mohammed Hameed 11-May-13 2:47am

Note that 'dg' is parameter of type DataGrid, which you need pass to this method from the calling code. This is like input (existing grid name you are using in ur app) for the method.

Note: DataGrid class for data grid and GridView class for grid view. You have to use the class as per your control accordingly.