How to Build a SQL 2005 View Style Design Surface??

Posted on 2007-08-02
Last Modified: 2008-03-06
Hi all,

We have a massive corporate application built using C#, we have a query builder that allows our employees to build SQL which can be save in our DB and later can be used in other areas of our app to send out letters, emails or for simple drill down reports.  The query builder itself is basic and requires some understanding of SQL to use.

The company wants to make this more user friendly for everyone and the conceptual designs so far look like the SQL 2000/2005 View Designer where you can drag and drop tables onto a design surface and create joins etc.  I have no idea as to how to build a design surface that can be used at runtime which can have tables dropped onto it, Im thinking designer, xml, meta data and all sorts of crazy stuff.  Does anyone know of any sample code out there or even a tool I can simply integrate into our application.

Many thanks

Question by:DotNetRules
    1 Comment
    LVL 4

    Accepted Solution

    Since its a big company you may want to take it easy and grab this componentOne package (they have a very good reputation)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    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…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 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

    11 Experts available now in Live!

    Get 1:1 Help Now