IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Coder
Search Coder Group:

Advanced
-Collapse +Expand Coder Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Coder Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCoding & OO BoardCoding Techniques Topic   Print This    All Groups  

Column Modification Checklist

Column Modification Checklist in Coding Techniques topic (part of our Coding & OO group).

Quick Search: Modification   Checklist   Column Modification   Column Modification Checklist  
Most Recent Post
Moderator
Bryan Valencia
209 Software
Home office in Manteca, CA

This is one of those things that I always forget part of, so because I just went through this, I thought I would document what needs to be done to sync your application whenever you modify any column in your database.

This tutorial is designed for:

  • MS SQL Server
  • Visual Studio (for web or desktop)

Quick Checklist:

  1. In SQL Server Management Studio (SSMS)
    1. Check for source and destination columns (for instance if widening "Address1" from 40 to 50, make sure all the columns in the order table, shipping, address book, Shipping and Billing etc are all the same)
    2. Update All Views that depend on this column. (SQL Server does not do this automatically)
    3. Update all stored procedures that operate on this column (for instance in and out parameters that access the changed column)
  2. In your Desktop App:
    1. Check all dataset xsd files to ensure the result column maxlengths are updated.
    2. Check all dataset xsd files to ensure the query parameter maxlengths are updated.
    3. Ensure all databound textboxes are set to the correct MaxLength.
    4. Ensure all DataGridView Columns are set to the correct MaxInputLength.

Yahoo ID: Commander_Bombast

Opportunity is missed by most because it is dressed in overalls and looks like work.

--THOMAS ALVA EDISON

 

 Posted 57 months ago (Thread Starter)
Comment Quote
About Bryan Valencia -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Bryan Valencia

Bryan Valencia is the author of millions of lines of code and writes for PrestwoodBoards and Visual Studio Journey on-line magazines.

Web Presence
LinkedIn, Bryan On LinkedIn (Visit Me)
Website, Software Services (http://209software.com/)
Website, Visual Studio Journey (http://vstudiojourney.blogspot.com/)

Post ID #15090, No Replies Be the first!
Thread Started 1/7/2014 2:35:52 PM
View Counter=2181
Location=Home office in Manteca, CA 
Joined=11 years ago   MB Posts=23   KB Posts=27   KB Comments=4   BLOG, Topics=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1233A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15090 Counter
2181
Since 1/7/2014
-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


Go ahead!   Use Us! Call: 916-726-5675 


©1995-2018 Prestwood IT Solutions.   [Security & Privacy]