473,388 Members | 932 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,388 software developers and data experts.

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 2283
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Aaron Smith | last post by:
Ok, this is an odd one, but I could use some assistance with the framework 2 in VB.Net... I want to have a DataGridViewColumn, only have it use the ComboBox, then when they drop down the...
2
by: Bob | last post by:
How do I show a calendar control or another appropriate control to pick a date and time for a cell in a column in a datagridview? Thanks for any help. Bob
2
by: Martin | last post by:
Hi all, This is the situation... DatagridView Control with datasource set to datatable. I want the user to be able to delete x number of rows by selecting a row with mouse then clicking a...
5
by: explode | last post by:
I made a procedure Public Sub Novo(ByVal nova1 As String, ByVal nova2 As String) that creates a new oledbDataAdapter with insert update select and delete commads. I also added that commands can...
9
by: active | last post by:
I need a control that displays a grid of rectangles. That is, like a brick wall except the rectangles are lined up. In VB6 I used such a control (may have been called FlexGrid but I'm not...
1
by: Jeff | last post by:
Hey ..NET 2.0 I've created a User Control which contain a DataGridView. This User Control is displayed on a TabPage. This TabPage is added to the TabControl during runtime. The problem is...
1
by: =?Utf-8?B?Qi4gQ2hlcm5pY2s=?= | last post by:
I've been away from web programming for a while and I have a situation that's new to me. I'm using VB/Dot Net 2.0. I've created an xsd (dataset) in the project and dragged some fields from a...
3
by: VC | last post by:
Hi, could someone points me to a article, whitepaper or other about how to create a simple custimized column for a (2008 .net) DataGridView windows form control? I've saw a lot of sample over...
0
by: priyamtheone | last post by:
I'm trying to make a datagridview column to act like a datetimepicker column (C#.Net 2005). These are the behaviours that the dgv should have: 1) Initially all the cells of the dtp column should be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.