Want to use a class level public function in more than one program

Hi Experts,

I have a public function to fill a grid.  I pass the Datagridview name and a query as parameter to this function.
This function is inside a class. How can I use this function in more than one program? At this time, when Prog1 call the function it can fill the grid1. But when Prog1 is open and Prog2 tries to call the function then grid2 is empty.  When I close prog1 and try to fill grid2 in prog2 then it works. So how can I use a function at the same time in more than one program.

Thanks in advance.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndyAinscowFreelance programmer / ConsultantCommented:
Put the function into a dll and each program can reference that dll.
Fernando SotoRetiredCommented:
Is Prog1 and Prog2 in two different executable files? For example Prog1.exe and Prog2.exe or are they two different classes within the same executable file?
RadhaKrishnaKiJayaAuthor Commented:
Thank you for your response. I have not created the EXE yet. My project is "PanelASRS". Under this project I have two forms. "frmInProcess" and "frmOutProcess". Both are filling grids. So I wrote a function to fill these grids. This is my code and it is in a class file.

Public shared Function fillGrid(GridviewName As DataGridView, Sql As String) As Integer
        fillGrid = 0
            If SQLComms.ConnectToDB(sqlConnectionString) = True Then
                cmd.Connection = SQLConn
                cmd = New SqlCommand(Sql, SQLConn)
                cmd.CommandText = Sql
                da.SelectCommand = cmd
                bsource.DataSource = dt
                GridviewName.DataSource = bsource
                fillGrid = dt.Rows.Count

            End If

        Catch ex As Exception
            MsgBox("Error while binding the Datagrid in PopulateGridView sub routine : " & ex.Message)
        End Try

    End Function
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

AndyAinscowFreelance programmer / ConsultantCommented:
This was your question title:
Want to use a class level public function in more than one program

Are you now saying you only want to call the function within the one program?  What is the problem?  A function can be called anywhere in a program - so long as the required permissions (eg. public - as you have) are in place.  Note in your sample you have da and dt which are not declared.  Be careful you do not end up with the grids being linked to the same data unless that is what you want.
Fernando SotoRetiredCommented:
It looks like you are using the same SqlDataAdapter and DataTable objects which are already in use when you try and fill the second data grid.
RadhaKrishnaKiJayaAuthor Commented:
Right...What is the best way to do it?  because I need to fill grid so many times in my project. I need a common function. Can you please suggest some better way?

Thank you.
AndyAinscowFreelance programmer / ConsultantCommented:
You could pass those objects into the function as well as your current parameters.  
Public shared Function fillGrid(GridviewName As DataGridView, Sql As String, da as ???, dt as ???) As Integer
replace the ??? with the correct type of variable you require.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RadhaKrishnaKiJayaAuthor Commented:
I will try and get back to you. Thank you for your help.
Fernando SotoRetiredCommented:
Will you be updating the database with the data that is being displayed from the DataGridView or is it just displaying info to the user.
Fernando SotoRetiredCommented:
I guess no credit to the person who found the error in your code....
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.