DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

help:how to select a record in MSH flexgrid

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jun 2007

Posts: 33

Reputation: ITech is an unknown quantity at this point

Solved Threads: 0

ITech

Offline

Light Poster

help:how to select a record in MSH flexgrid

Mar 31st, 2008

my problem is that i have a search form for customers ,i want to use msh flex grid to show the results of search, i am searching for a customer which are stored in a database.
suppose i want to update some information of a specific customer listed in msh flexgrid after the search.so i want to select the whole row and wen i press updatebutton these fields are retrieved into some textboxes...the problem is that with msh flex grid i can search for customers,,but cant selct a row and retrieve to text boxes for updation.

when i did with datagrid its working fine..absolutely fine...but i want to use mshflexgrid...

is there a solution for my problem

•

Join Date: Apr 2008

Posts: 34

Reputation: techtix is an unknown quantity at this point

Solved Threads: 4

techtix

Offline

Light Poster

Re: help:how to select a record in MSH flexgrid

Apr 3rd, 2008

First, unless you plan on using the hierarchical aspects of the grid, I'd suggest using the standard MSFlexGrid rather than the MSHFlexGrid.

To address your question, you can use the TextMatrix property to retrieve the text from each column in the selected row.

You can find the complete reference to both FlexGrid controls in the Microsoft MSDN Library.
http://msdn2.microsoft.com/en-us/lib...39(VS.60).aspx

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Private Sub UpdateButton_Click()
 
   Dim RowNum as long
 
   'Return the selected row number
   RowNum = MyGrid.Row
 
   'Example:  Returns the text from column 5 of the selected row
   Text1.Text = MyGrid.TextMatrix(RowNum, 5)
 
   'NOTE: The reverse will set the column text
   'MyGrid.TextMatrix(RowNum, 5) = "Some text value"
 
End Sub
Private Sub UpdateButton_Click()

   Dim RowNum as long

   'Return the selected row number
   RowNum = MyGrid.Row

   'Example:  Returns the text from column 5 of the selected row
   Text1.Text = MyGrid.TextMatrix(RowNum, 5)
   
   'NOTE: The reverse will set the column text
   'MyGrid.TextMatrix(RowNum, 5) = "Some text value"

End Sub