Visual_Pro
asked on
How to create multiple fixed rows with DataGrid?
Hey all,
I remember in old VB 6 that with the Flexgrid control (I think), you could specify how many fixed header rows you wanted up the top.
Unfortunately now that I am using the .NET datagrid I can no longer work out how to do this. Does anyone have any ideas?
Thanks!
Dwayne
I remember in old VB 6 that with the Flexgrid control (I think), you could specify how many fixed header rows you wanted up the top.
Unfortunately now that I am using the .NET datagrid I can no longer work out how to do this. Does anyone have any ideas?
Thanks!
Dwayne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ms Flexgrid control is available for .net
right click the toolbox .select Add/Remove Items . select Com components .
You can see Micosoft flexgrid control
regards
prakash
ASKER
Hey,
I have been trying out the flexgrid control recently but after a lot of failed tests and having done some more research I cannot get it to work.
The only problem is that the flexgrid control doesn't work with my XML dataset so I really need to use the VB .NET Datagrid control.
So do you know how to add 2 fixed header rows with this???
Cheers!
Dwayne
I have been trying out the flexgrid control recently but after a lot of failed tests and having done some more research I cannot get it to work.
The only problem is that the flexgrid control doesn't work with my XML dataset so I really need to use the VB .NET Datagrid control.
So do you know how to add 2 fixed header rows with this???
Cheers!
Dwayne
ASKER
Please I really need help with this and am even offering a lot more points for it so if you can please help me I would really appreciate it.
Thanks :)
Thanks :)
What to you really need with datagrid?.
Can you explain your
you can create a table from the XMLDataset accroding to your need(2 fields and rows..)
then assign this table to the datagrid's datasource property
regrads
prakash
ASKER
Well the flexgrid control has a property called FixedRows where I can make more then 1 row as a fixed header.
But the datagrid control doesn't have this option. So I tried your suggestion of using that flexgrid control but it doesn't work with my ado .net data
Which means that I can't use that but have to use the .net datagrid control instead. However with that I cannot find any fixedrows property and am wondering how else I could make 2 or more fixed rows with it?
Thanks!
Dwayne
But the datagrid control doesn't have this option. So I tried your suggestion of using that flexgrid control but it doesn't work with my ado .net data
Which means that I can't use that but have to use the .net datagrid control instead. However with that I cannot find any fixedrows property and am wondering how else I could make 2 or more fixed rows with it?
Thanks!
Dwayne
Hi Visual_Pro
The datagrid control is a bounded control . it displays the datasets or datatable's we can't add a a fixed row or column . for that purposes microsoft gives the flexgrid control .
You can try this .
Read the rows from dataset individully and add it to flexgrid contol.
regards
prakash
ASKER
Oh I see. That makes sense now.
Well if you wouldn't mind could you please give me a quick example of how to do that then?
Well if you wouldn't mind could you please give me a quick example of how to do that then?
ASKER
Hello TheLearnedOne,
I am still active with this question.
I was just hoping someone might have been able to provide a code example for the solution that prakash suggested since I am not sure how to code that myself.
I was going to start a new question for it but then decided that since I need code for the solution to work someone else might as well so I was hoping someone would be kind enough to provide some code to illustrate what he was saying and then I can close it.
Cheers!
Dwayne
I am still active with this question.
I was just hoping someone might have been able to provide a code example for the solution that prakash suggested since I am not sure how to code that myself.
I was going to start a new question for it but then decided that since I need code for the solution to work someone else might as well so I was hoping someone would be kind enough to provide some code to illustrate what he was saying and then I can close it.
Cheers!
Dwayne
ASKER
Well doesn't look like there is going to be any examples being posted here so to stop this going old I will accept it.
ASKER
Thanks for that but it wasn't quite what I was after.
That only gives me one header row (where the first, second, third, etc. was)
What I want is to have 2 header rows (like you could do with the old flexgrid control from Visual Basic 6). But from what I could see there is no Flexgrid control in VB .NET only the datagrid control so I was wondering how to have 2 header rows by using this?
Cheers!
Dwayne