473,386 Members | 1,823 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Can the first three columns of a datagrid be frozen?

I am trting to simulate the case available in an excel worksheet where the
first three columns are frozen and the rest scroll left and right against
this.

For example: I have a grid which lists the Item and Line of a priduct by
row.
I need to be able to keep the item and line columns frozen so that when I
scroll to the right to view data which is off the right side of the screen,
I can still see the item and line to which this relates.
I am using VB.NET 2002

Is this possible or should I give it up as a too ambitious idea?

Thanks

Terry

Jul 21 '05 #1
2 1410
The only way I've found to do this is to use 2 datagrids. But, you need to
fix the size of both grids in pixels. Then, throw a div tag around the
second datagrid (non-fixed one) with OVERFLOW-X: scroll. Plus, getting the 2
datagrids to match line by line took a long time.
I'd avoid it if you can.

Mark
"anon" <ng*@tdrd.freeserve.co.uk> wrote in message
news:d0**********@newsg2.svr.pol.co.uk...
I am trting to simulate the case available in an excel worksheet where the
first three columns are frozen and the rest scroll left and right against
this.

For example: I have a grid which lists the Item and Line of a priduct by
row.
I need to be able to keep the item and line columns frozen so that when I
scroll to the right to view data which is off the right side of the screen, I can still see the item and line to which this relates.
I am using VB.NET 2002

Is this possible or should I give it up as a too ambitious idea?

Thanks

Terry


Jul 21 '05 #2
Yuk... what a workaround!
I think i'll stick to the simpler means of take it or leave it.

Thanks for the feedback

Terry

"Mark Petersen" <ma***********@hotmail.com> wrote in message
news:OF**************@TK2MSFTNGP12.phx.gbl...
The only way I've found to do this is to use 2 datagrids. But, you need to
fix the size of both grids in pixels. Then, throw a div tag around the
second datagrid (non-fixed one) with OVERFLOW-X: scroll. Plus, getting the 2 datagrids to match line by line took a long time.
I'd avoid it if you can.

Mark
"anon" <ng*@tdrd.freeserve.co.uk> wrote in message
news:d0**********@newsg2.svr.pol.co.uk...
I am trting to simulate the case available in an excel worksheet where the first three columns are frozen and the rest scroll left and right against this.

For example: I have a grid which lists the Item and Line of a priduct by
row.
I need to be able to keep the item and line columns frozen so that when I scroll to the right to view data which is off the right side of the

screen,
I can still see the item and line to which this relates.
I am using VB.NET 2002

Is this possible or should I give it up as a too ambitious idea?

Thanks

Terry



Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Kevin | last post by:
Hi Al Can someone tell me how to hide colums in a datagrid. I have a one datagrid that is a master and child and I would like to hide specific columns, how do I do this TI Kevin
0
by: elime | last post by:
Hi all I have a strange behaving on some PC with my DataGrid. It only occurs on some PC, on others it works perfectly fine. ->(same ..net version installed) it's very confusing. starting...
4
by: | last post by:
I have a datagrid with a template column that has a hyperlink and a label. The hyperlink text is bound to Title from my dataset and the label text is bound to Author in the dataset. The grid...
1
by: John Martin | last post by:
This should be an easy match, but I'm lost. I want to perform a kind of grouping of the data in a datagrid object, so that only the first occurrence of a value in column one is visible. The...
3
by: danc | last post by:
I have a datagrid with a checkbox and dropdown list in each row. Both set AutoPostBack to true and ItemCommand and OnSelectedIndexChanged events for these controls works fine when DataGrid is not...
2
by: anon | last post by:
I am trting to simulate the case available in an excel worksheet where the first three columns are frozen and the rest scroll left and right against this. For example: I have a grid which lists...
4
by: Grace | last post by:
I use a datagrid included in a repeater. as following: (.aspx) <asp:repeater id="rp_perform" Runat="server"> <HeaderTemplate> <table border="0" bgcolor="gray" cellspacing="0" cellpadding="0">...
5
by: Localbar | last post by:
Anyone have idea how to do that? Thanks a lot Localbar
3
by: EByker | last post by:
I need to acquire the number of frozen rows and columns of an Excel worksheet. How can I do this in VBA? Thanks Bertie
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.