Changes in SQL tables and databinding

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I had a SQL server 2005 table in which I noticed I mispelled a column name.
I changed the column name in the sql server table but after that, in the UI
fortm using the table, the dataset control bound via a binding source and a
table adapter to a datagridview no longer recognized the changed column name
and kept giving me an error on that column, evidentlty I expect that is
normal.
But only way I found to fix and see my changed column was to remove the
datagridview using it and all its associated controls (dataset, etc..) and
create a brand new datagrid with its associated dataset binding source and
table adapter.

Questions is there must be a simpler way to effect changes in the objects
related to databinding controls in the UI when a change is brought to the
underlying SQL server tables. How do you get these controls to get the new
table definitions without having to reprogram your entire form?

Any help appreciated,

Bob


.

Relevant Pages

  • Re: Compact Framework and SqlCe questions
    ... With SQL Server CE, once you fill an adapter from an underlying table, ... > command --> more time expensive. ... >>> CustomerCompanyName, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Compact Framework and SqlCe questions
    ... With SQL Server CE, once you fill an adapter from an underlying table, ... > command --> more time expensive. ... >>> CustomerCompanyName, ...
    (microsoft.public.sqlserver.ce)
  • RE: scope_Identiy() problem vs @@Identity with daAdapter.InsertCommand
    ... server (sql server 2000 standard Edition) table using a sql ... The row gets inserted but it does not display on ... the datagridview on my client app. ... code on Sql server 2000 personal edition - loaded on my workstation, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is there limit to num of tbl cols sql Adapter can support?
    ... > I have some large tables in a Sql Server DB, ... > errors configuring the adapter if I included more than 100 ... > source connection and fill the tables locally on the ... If com ADO can handle ...
    (microsoft.public.dotnet.framework.adonet)
  • newly added record not showing up
    ... SQL Server). ... I have a dataset, binding source, and table adapter used in a form. ... table that I use as a record selection method (for selecting existing ...
    (microsoft.public.dotnet.framework.adonet)