Question Red exclamation mark in DGV bound to SQL

Super_Grover

Active member
Joined
Apr 7, 2010
Messages
32
Programming Experience
Beginner
Hi all,
Hope you can help me with this silly question:
In my application I have bound a datagridview to a SQL2005 bindingsource.

I really had to change a database field (more length allowed) and now de DGV displays red exclamation marks and states: 'Colomn 'password' exceeds the MaxLength limit'. (the 'password'-colomn isn't even displayed, but that's a sidenote).

I tried different things but can't get rid of the exclamation marks. Any ideas how I can manage this. I really don't want to create a new DGV, because there a lot of code and stuff involved.

Thanks in advance!
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,570
Location
Sydney, Australia
Programming Experience
10+
It's nothing to do with the DataGridView. You have presumably generated a Data Source and typed DataSet from your database. If you then make changes to the database schema, you need to regenerate that Data Source and typed DataSet. If you don't do that, they still work using the old schema so the DataTable bound to your grid still assumes the old maximum length for that column. There's a button at the top of the Data Sources window to re-run the configuration wizard.
 
Top Bottom