Programming AutoCAD with SQL Server Database Using C#

Overview This course, Programming AutoCAD with SQL Server Database Using C#, is designed to equip participants with the skills needed …

Programming AutoCAD with SQL Server Database Using C#

Programming AutoCAD with SQL Server Database Using C#

Original price was: $417.25.Current price is: $35.30.

TAKE THIS COURSE 14-Day Money-Back Guarantee

are
are
are
clender

1 Year Access

teacher

4 Students

durantion

7 hours, 58 minutes

All Courses For Lifetime At £99
Gift this course

Programming AutoCAD with SQL Server Database Using C# Overview

This course, Programming AutoCAD with SQL Server Database Using C#, is designed to equip participants with the skills needed to integrate AutoCAD with SQL Server databases using C#. The curriculum covers essential topics from basic SQL queries to advanced techniques in data retrieval, updating, and deletion within AutoCAD environments.

Learning Outcomes

  • Understand the fundamentals of SQL queries.
  • Create and manage databases and tables in SQL Server.
  • Load data into SQL Server databases from AutoCAD.
  • Retrieve and display data from SQL Server within AutoCAD.
  • Implement techniques for updating data in SQL Server from AutoCAD.
  • Develop strategies for deleting data in SQL Server from AutoCAD.
  • Apply C# programming principles to automate tasks in AutoCAD.
  • Troubleshoot common integration issues between AutoCAD and SQL Server.
  • Optimise SQL queries for performance in AutoCAD applications.
  • Implement security measures to protect data integrity in SQL Server.

Who Is This Course For

This course is ideal for architects, engineers, drafters, and professionals working with AutoCAD who wish to enhance their productivity by integrating database functionalities using SQL Server and C#.

Eligibility Requirements

Participants should have a basic understanding of AutoCAD and familiarity with fundamental programming concepts in C#. Knowledge of SQL Server basics would be advantageous but not essential for entry into the course.

Career Path

  • Age Requirement: Applicants must be aged 16 or above, allowing both young learners and adults to engage in this educational pursuit.
  • Academic Background: There are no specific educational prerequisites, opening the door to individuals from diverse academic histories.
  • Language Proficiency: A good command of the English language is essential for comprehension and engagement with the course materials.
  • Numeracy Skills: Basic numeracy skills are required to effectively understand and work with course-related information. 

Why Choose Us

  • Affordable, engaging & high-quality e-learning study materials;
  • Tutorial videos/materials from the industry-leading experts;
  • Study in a user-friendly, advanced online learning platform;
  • Efficient exam systems for the assessment and instant result;
  • The UK & internationally recognised accredited
  • Access to course content on mobile, tablet or desktop from anywhere, anytime;
  • The benefit of career advancement opportunities;
  • 24/7 student support via email.

Career Path

Upon completion, participants can pursue roles such as CAD programmer, database engineer, architectural technologist, or engineering consultant, focusing on automated design processes and data management in CAD environments.

Programming AutoCAD with SQL Server Database Using C#

Course Curriculum

Section 01: Introduction
Course Topics 00:02:00
Introduction 00:02:00
Section 2 - Tools and SQL Queries
Section Overview 00:01:00
Downloading Visual Studio 2019 00:01:00
Downloading SQL Server Express 00:02:00
Downloading SQL Server Management Studio (SSMS) 00:01:00
SQL Queries – Overview 00:03:00
INSERT SQL Statement – Demo 00:13:00
SELECT SQL Statement – Demo 00:08:00
UPDATE SQL Statement – Demo 00:08:00
DELETE SQL Statement – Demo 00:11:00
Section 3 - Create Database and Tables
Section Overview 00:01:00
Creating the CADDB Database 00:03:00
Creating the Lines Table 00:07:00
Creating the MTexts Table 00:04:00
Creating the Plines Table 00:04:00
Creating the Blocks No Attribute Table 00:04:00
Creating the Blocks With Attributes Table 00:04:00
Section 4 - Loading into SQL Server Database
Section Overview 00:02:00
Loading Lines into SQL Server Database 00:01:00
Creating the CADDB Project 00:04:00
Creating the Settings File 00:04:00
Creating the Get Connection Method 00:03:00
Creating the LoadLines() Method 00:22:00
Creating the User Interface for the LoadLines() method 00:07:00
Running the LoadLines() Method 00:05:00
Loading MTexts into SQL Server Database – Overview 00:01:00
Creating the LoadMTexts() Method 00:10:00
Running the LoadMTexts() Method 00:06:00
Loading LWPolylines into SQL Server Database – Overview 00:01:00
Creating the LoadPolylines() Method 00:13:00
Running the LoadPlines() Method 00:03:00
Loading Blocks (No Attribute) into SQL Server Database – Overview 00:01:00
Creating the LoadBlocksNoAttribute() Method 00:11:00
Running the LoadBlocksNoAttribute() Method 00:03:00
Loading Blocks (with Attributes) into SQL Server Database – Overview 00:01:00
Creating the LoadBlocksWithAttributes() Method 00:07:00
Running the BlocksWithAttributes() Method 00:02:00
Section 5 - Retrieving Data from Database
Section Overview 00:02:00
Retrieving LWPolylines from SQL Server Database – Overview 00:01:00
Creating the DBRetrieveUtil Class 00:03:00
Creating the RetrieveAndDrawLines() Method (Part 1) 00:17:00
Creating the GetColorIndex() Method 00:05:00
Creating the RetrieveAndDrawLines() Method (Part 2) 00:11:00
Running and Testing the RetrieveAndDrawLines() Method 00:09:00
Retrieving MTexts from SQL Server Database – Overview 00:01:00
Creating the RetrieveAndDrawMTexts() Method 00:11:00
Running and Testing the CreateAndDrawMTexts() Method 00:05:00
Retrieving LWPolylines from SQL Server Database – Overview 00:01:00
Creating the RetrieveAndDrawPlines() Method 00:12:00
Running and Testing the RetrieveAndDrawPlines() Method 00:05:00
Retrieving Blocks (No Attribute) from SQL Server Database – Overview 00:01:00
Creating the RetrieveAndDrawBlocksNoAttribute() Method 00:11:00
Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method 00:05:00
Retrieving Blocks (with Attributes) from SQL Server Database – Overview 00:01:00
Creating the RetrieveAndDrawBlocksWithAttributes() Method 00:21:00
Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method 00:10:00
Section 6 - Updating Data in SQL Server Database - Overview
Section Overview 00:01:00
Updating the LWPolylines in SQL Server Database – Overview 00:01:00
Creating the DBUpdateUtil Class 00:02:00
Creating the UpdateLines() Method 00:23:00
Creating the User Interface for UpdateLines() Method 00:02:00
Running and Testing the UpdateLines() Method 00:08:00
Updating MTexts in SQL Server Database – Overview 00:01:00
Creating the UpdateMTexts() Method 00:09:00
Creating the User Interface for UpdateMTexts() 00:01:00
Running and Testing the UpdateMTexts() Method 00:07:00
Updating the LWPolylines in SQL Server Database – Overview 00:01:00
Creating the UpdateLWPolylines() Method 00:09:00
Running and Testing the UpdateLWPolylines() Method 00:07:00
Updating Blocks (No Attributes) in SQL Server Database – Overview 00:01:00
Creating the UpdateBlocksNoAttributes() Method 00:10:00
Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00
Running and Testing the UpdateBlocksNoAttributes() Method 00:04:00
Updating Blocks With Attributes in SQL Server Database – Overview 00:01:00
Creating the UpdateBlocksWithAttributes() Method 00:08:00
Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00
Running and Testing the UpdateBlocksWithAttributes() Method 00:09:00
Section 7 - Deleting Data in SQL Server Database from AutoCAD - Overview
Section Overview 00:02:00
Deleting Lines in SQL Server from AutoCAD – Overview 00:01:00
Creating the DBDeleteUtil Class 00:01:00
Creating the DeleteLines() Method 00:13:00
Creating the User Interface for the DeleteLines() Method 00:02:00
Running and Testing the DeleteLines() Method 00:04:00
Deleting MTexts in SQL Server Database from AutoCAD – Overview 00:01:00
Creating the DeleteMTexts() Method 00:04:00
Creating the User Interface for DeleteMTexts() Method 00:01:00
Running and Testing the DeleteMTexts() Method 00:03:00
Deleting LWPolylines in SQL Server Database from AutoCAD – Overview 00:01:00
Creating the DeletePlines() Method 00:04:00
Creating the User Interface for the DeletePlines() Method 00:01:00
Running and Testing the DeletePlines() Method 00:02:00
Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD – Overview 00:01:00
Creating the DeleteBlocksNoAttribute() Method 00:03:00
Creating the User Interface for DeleteBlocksNoAttribute() Method 00:01:00
Running and Testing DeleteBlocksNoAttribute() Method 00:02:00
Deleting Blocks (With Attributes) in SQL Server Database from AutoCAD – Overview 00:01:00
Creating the DeleteBlocksWithAttributes() Method 00:02:00
Creating the User Interface for DeleteBlocksWithAttributes() Method 00:01:00
Running and Testing the DeleteBlocksWithAttributes() Method 00:02:00
Order Certificate
Order Certificate 00:00:00

How Do Our Courses Work?

Purchase and payment

Add your chosen course to your basket. Once you’ve added all the courses you need.

Course access

Add your chosen course to your basket. Once you’ve added all the courses you need.

Certificate

Add your chosen course to your basket. Once you’ve added all the courses you need.

Continued support

Add your chosen course to your basket. Once you’ve added all the courses you need.

Dive into an enriching online learning journey with Alpha Academy. We pride ourselves on offering a diverse range of courses tailored to your needs. Elevate your expertise or discover a new passion. With Alpha Academy, your pursuit of knowledge has no bounds.

Contact

For Business

Certificate validator

Payment methods possible

© ALPHA ACADEMY IS A PART OF ADAMS ACADEMY INC. LTD.

top
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    HOLIDAY SALE – ALL COURSES FOR Original price was: $652.69.Current price is: $64.09. / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon