Please I need the help of experts here:
What I Need To Do:
I need to display several rows of data from a table on a form.
-Each row has 4 columns. I want each column to have no lines between them
-Each row should respond to a click event, displaying details of the row as a result.
-User should be able to edit/delete content of each row clicked
What I Have Done:
-I connected to the database using Jet 4.0 OLE db
-I displayed the rows nicely with a MSHFlexgrid
-I cannot make the HFlexGrid to respond to a click event (i.e each row did not respond to a click event)
-I could not edit data in the table while it is bound to MSHFlexGrid
I have tried using dataGrid (I did not know how to select each row with a single click; moreover, it does not look as I wanted). I tried DataList control (I could only display one column for each row). DBList didn't work either.