How to lock some columns in a datagrid

[SushmitaP]

Hi,
I don't know if it is possible or not.
I am working on Vb.Net platform & need to know if its possible?
Is it possible to lock some columns from the datagrid & the user can scroll the remaining columns?

Thanks in advance.

[AFFAN]

You can use 2 different datagrid for this requirement.
One is locked & second is free to scroll.

DataGridTextBoxColumn has a ReadOnly property. You must define a
DataGridTableStyle that refer to your source and add a DataGridTextBoxColumn
for each column you want to show. You set the ReadOnly property to true if
you want to prevent the user from modifying the data.

[Anywhere]

I created an application with a datagrid and textboxes on a form. The datagrid and textboxes are bound to the same data set from a data adapter, using an Access data base. So when you navigate through the datagrid information, the textboxes also show the corresponding fields. My problem is, I want the datagrid to only show a few of the columns, and just have the rest of the information in the textboxes. I tried looking up hiding or deleting columns in vb help, but none helped. It had information on adding columns and something about a tables style collection and gridcolumns style, but that is all empty in mine. I know I can get rid of columns in the data adapter but that means I cannot access that information for the textboxes. I hope I am making enough sense, but any help would be greatly appreciated! I know hiding columns is easier for web apps, and apparently there's a datagrid property builder thing for that, but a stupid windows form is much more complicated. Thanks in advance!!!