claracruz
asked on
datagrid vs MsFlexgrid
Hello experts,
I have a couple of questions on MsFlexgrid, I have been using Datagrid, and need to swap over, so the questions;-
1.) Is it possible to do a fullrowselect in MsFlexgrid.
2.) Is there an AllowArrows = True method for MsFlexgrid
If these are possible, how do I do this?
thank you
I have a couple of questions on MsFlexgrid, I have been using Datagrid, and need to swap over, so the questions;-
1.) Is it possible to do a fullrowselect in MsFlexgrid.
2.) Is there an AllowArrows = True method for MsFlexgrid
If these are possible, how do I do this?
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi claracruz,
FlexGrid is much batter option then dbgrid as its static and no addition and deletion is not possible and ya also no updation. but ......but .......every thing is posible in flexgrid but u have to code for that thats the difference between flexgrid and dbgrid u there is not requirement of coding .
if u required code then may be i can help u.....
Amit Jain
FlexGrid is much batter option then dbgrid as its static and no addition and deletion is not possible and ya also no updation. but ......but .......every thing is posible in flexgrid but u have to code for that thats the difference between flexgrid and dbgrid u there is not requirement of coding .
if u required code then may be i can help u.....
Amit Jain
ASKER
yes please, that is exactly what I need, the code for the methods I listed.
thank you
thank you
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am sorry but I don't think this is what I need.
I have an SQL query that looks like this;
strDates = "SELECT [First Name], [Last Name], Players.[Date Of Birth], WHERE [Course Code]= '" & .DataGrid1.Columns(0) & "'
what would be the equivalent of - '" & .DataGrid1.Columns(0) & "'- when using an MsFlexgrid.
My other question is this:-
With the datagrid, I can move from one row to the next (and mimic the datagrid's click event ) using up or down arrows (and NOT the mouse) by setting AllowArrow property to "True", How do I do this with the MsFlexgrid.
I have an SQL query that looks like this;
strDates = "SELECT [First Name], [Last Name], Players.[Date Of Birth], WHERE [Course Code]= '" & .DataGrid1.Columns(0) & "'
what would be the equivalent of - '" & .DataGrid1.Columns(0) & "'- when using an MsFlexgrid.
My other question is this:-
With the datagrid, I can move from one row to the next (and mimic the datagrid's click event ) using up or down arrows (and NOT the mouse) by setting AllowArrow property to "True", How do I do this with the MsFlexgrid.
ASKER
My question has been answered by RIMVIS, posted at;-
(https://www.experts-exchange.com/questions/20946101/help-with-MsFlexGrid.html)
1)
To get value of MSFlexGrid cell, use TextMatrix property
TextMatrix(rowindex, colindex) [=string]
To get current row and columd, use Row and Col properties respectively.
So, value of current cell wil be MSFlexGrid1.TextMatrix(MSF lexGrid1.R ow, MSFlexGrid1.Col)
2)
You can navigate in flex grid using arrow keys without any additional code.
If you want to have entire row selected, set SelectionMode to 1 (select by row)
But thank you for all your contributions...
(https://www.experts-exchange.com/questions/20946101/help-with-MsFlexGrid.html)
1)
To get value of MSFlexGrid cell, use TextMatrix property
TextMatrix(rowindex, colindex) [=string]
To get current row and columd, use Row and Col properties respectively.
So, value of current cell wil be MSFlexGrid1.TextMatrix(MSF
2)
You can navigate in flex grid using arrow keys without any additional code.
If you want to have entire row selected, set SelectionMode to 1 (select by row)
But thank you for all your contributions...
Hai,
I have done a tutorial on how to use Flexgrid as Datagrid you can get it on the folowing link.
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=42344&lngWId=1
Inform me if it is usefull.
Bye Bye,
R.K.T. ASHOKA.
I have done a tutorial on how to use Flexgrid as Datagrid you can get it on the folowing link.
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=42344&lngWId=1
Inform me if it is usefull.
Bye Bye,
R.K.T. ASHOKA.
ASKER
And also since 'AllowArrow = true' is not available in MsFlexgrid, is it at all possible for a user to move from one row to the next row down, without using the mouse.