?
Solved

Return grid columns from a grid to another existing grid VB.NET

Posted on 2009-04-05
2
Medium Priority
?
155 Views
Last Modified: 2013-11-26
I have a datagrid that is set up when I do a search against a database.
When I do the search, the columns are added correctly with the type of table I get the data from in mind. So I can represent different tables and different sets of columns in the same datagrid.

The thing is that I can only do this when accessing the form manually and doing the search my self. I want to use the same capabillities in other parts of the program by just calling a function. The function sets up the search like i want it to, controlled by the arguments I pass to it. The search gets done and gets stored in the datagrid of the form where all the code is written. This is the same form and the same datagrid I see when I do the search manually through that form.

I dont want the results of the search to stay in that datagrid at the original form. I want them returned from the function to whatever part of the program/ whatever form I call the function from. So I tried to return the datagrid from where the search results were stored.

I did not succeed. Any one have any ideas / comments?
Public Function get_Search(ByVal RegNumber As Integer, ByVal chkBoxes As Integer, ByVal indexNumber As Integer, ByVal SearchString As String)
        Dim sender As System.Object = Me
        Dim e As System.EventArgs
  '... the code handles the arguments and sets up the search as if it were the user selecting in the search form....
 ' The search is the executed..
        btnFind_Click(sender, e)
 
' In the btnFind_Click procedure, the results are stored in datagridSok. I want to return the 
' datagrid or the columns and assign them to another already existing datagrid in another form:
        Return datagridSok.Columns
End Function
 
'What I have come up with so far is this(done in another form):
 
Private Sub btnTestSok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTestSok.Click
        dgCustomer.Columns.Clear()
        Dim tempDataGridViewColumnCollection As System.Windows.Forms.DataGridViewColumnCollection
        tempDataGridViewColumnCollection = frmSok.get_Search(1, 1, 1, "String")
 
'The following does not work, I have tried numerous variants...
        dgCustomer.Columns.Add(tempDataGridViewColumnCollection.Item(1))
End Sub

Open in new window

0
Comment
Question by:itnifl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
Ramone_Hamilton earned 2000 total points
ID: 24071449
Have you tried returning the results of the search as a datatable or dataset from your function.  This way you can simply bind your results to any bindable control on the form.
0
 
LVL 2

Author Closing Comment

by:itnifl
ID: 31566753
Yes, that worked great! Thanks!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question