Link to home
Start Free TrialLog in
Avatar of Visual_Pro
Visual_ProFlag for Australia

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

ASKER CERTIFIED SOLUTION
Avatar of prakash_prk
prakash_prk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Visual_Pro

ASKER

Hey,

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


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

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
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 :)

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
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

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
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?
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
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.