NEWBIE: Trying to drop column with many columns failing

Posted on 2006-03-29
Last Modified: 2008-01-09
Dear Experts,

I'm trying to drag and drop a table into a tabbed pane in Visual Studio 2005 (C#), and I'm getting this message:

     sum of the columns' FillWeight values cannot exceed 65535

Admittedly, the table has around 400 or so columns...

Is there any way around this?

Question by:BrianMc1958
    1 Comment
    LVL 3

    Accepted Solution


    Seriously, I would consider normailizing your database (split into smaller tables), this will be a serious performance issue if you try to query all of your columns. Another way would be to create a view for a subset of your Data. Don't forget, with 400 columns your transferring a huge chunk of data over the internet or network.

    Good Luck!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    In one of my recent projects, I was working with IP cameras, I need to take some pictures from the camera and do some processing on it. The first step, was to retrieve the image from camera into Image object. So that it can be displayed or …
    This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now