468,307 Members | 1,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,307 developers. It's quick & easy.

problem with a column in datagridview control

Hello,

I am reading data from a sql server table that is under replication. This
table has the replicatin GUID column that is generated with replicatin. I am
reading the data from a dataAdapter/Dataset using a dataview which is the
data source for a datagridview control. When I scroll horizontally in the
datagridview control and reach this GUID column (which is not at the end of
the table) it raises the datagridview dataError event. If I continue to
click on the scrollbar button I keep getting the dataerror until I am past
the GUID column. Then I can scroll to the end of the datagridview control
backwards OK. But when I scroll forward again and reach the GUID column, I
raise the error again.

Is there a way in the dataview object that I can limit what columns are
visible from my table. I realize I could do this in the datasource select
statement, but that is a lot of columns. I am doing Select * from tbl...
How can I make this GUID column not show up in the datagridview control? Or
is there a way to deal with GUID columns in a dataview/datagridview control?

Thanks,
Rich
May 15 '06 #1
1 2025
I figured this one out. The trick is in the datagridview control not the
dataview object:

datagridview("GUIDcol").Visiblie = False

Now this column does not show up, and my problem has gone away.

"Rich" wrote:
Hello,

I am reading data from a sql server table that is under replication. This
table has the replicatin GUID column that is generated with replicatin. I am
reading the data from a dataAdapter/Dataset using a dataview which is the
data source for a datagridview control. When I scroll horizontally in the
datagridview control and reach this GUID column (which is not at the end of
the table) it raises the datagridview dataError event. If I continue to
click on the scrollbar button I keep getting the dataerror until I am past
the GUID column. Then I can scroll to the end of the datagridview control
backwards OK. But when I scroll forward again and reach the GUID column, I
raise the error again.

Is there a way in the dataview object that I can limit what columns are
visible from my table. I realize I could do this in the datasource select
statement, but that is a lot of columns. I am doing Select * from tbl...
How can I make this GUID column not show up in the datagridview control? Or
is there a way to deal with GUID columns in a dataview/datagridview control?

Thanks,
Rich

May 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Aaron Smith | last post: by
2 posts views Thread by Martin | last post: by
5 posts views Thread by explode | last post: by
1 post views Thread by Jeff | last post: by
1 post views Thread by =?Utf-8?B?Qi4gQ2hlcm5pY2s=?= | last post: by
3 posts views Thread by VC | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.