Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Programming AutoCAD with SQL Server Database using C#

Name: Programming AutoCAD with SQL Server Database using C#
Rating: 4.7 (58 reviews)

Programming AutoCAD .NET API with SQL Server Database integration using C#. You will perform database CRUD operations

Highest Rated

Created byArnold Higuit

Last updated 3/2026

English

What you'll learn

Learn to connect AutoCAD to SQL Server Database using C#
Learn how to extract AutoCAD Objects and store in SQL Server Database
Learn how to perform CRUD (Create, Retrieve, Update, Delete) Operations using C#

Course content

9 sections • 103 lectures • 8h 5m total length

Course Topics1:55
This video discusses the topics that will be covered in this course.
Introduction2:17
This video provides overview of this section.

Section Overview1:21
This video provides overview of the topics covered in this section.
Downloading Visual Studio 20191:17
This video shows how to download Visual Studio 2019.
Downloading SQL Server Express1:40
This video shows how to download SQL Server Express.
Downloading SQL Server Management Studio (SSMS)1:04
This video shows how to download SQL Server Management Studio (SSMS).
SQL Queries - Overview2:29
This video provides high level overview about SQL INSERT Statement.
INSERT SQL Statement - Demo12:57
This video shows how to use INSERT SQL Statement.
SELECT SQL Statement - Demo8:09
This video shows how to use SELECT SQL Statement.
UPDATE SQL Statement - Demo7:47
This video show how to use UPDATE SQL Statement.
DELETE SQL Statement - Demo10:40
This video shows how to use SQL DELETE Statement.

Section Overview1:17
This videos provides overview of this section.
Creating the CADDB Database3:14
This video shows how to create the CADDB Database.
Creating the Lines Table6:44
This video shows how to create the Lines table.
Creating the MTexts Table4:10
This video shows how to create the MTexts Table.
Creating the Plines Table3:45
This video shows how to create the Plines Table.
Creating the BlocksNoAttribute Table3:48
This video shows how to create the BlocksNoAttribute Table.
Creating the BlocksWithAttributes Table3:36
This video shows how to create the BlocksWithAttributes Table.

Section Overview2:20
This video provides overview of this section.
Loading Lines into SQL Server Database0:58
This video provides overview about loading Lines from AutoCAD into SQL Server database.
Creating the CADDB Project4:06
This video shows how to create the CADDB Project in Visual Studio 2019.
Creating the Settings File3:56
This video shows how to create a Settings File for the to stored the database connection.
Creating the GetConnection Method3:20
This video shows how to code the GetConnection Method.
Creating the LoadLines() Method22:17
This video shows how to code the LoadLines() method.
Creating the User Interface for the LoadLines() method6:53
This videos shows how to create the User Interface to call the LoadLines() method.
Running the LoadLines() Method4:59
This video shows the execution of the LoadLines() method.
Loading MTexts into SQL Server Database - Overview0:47
This video provides a overview of loading MTexts into SQL Server database.
Creating the LoadMTexts() Method9:38
This video shows how to code LoadMTexts() method.
Running the LoadMTexts() Method5:29
This video shows the execution of the LoadMTexts() method.
Loading LWPolylines into SQL Server Database - Overview1:17
This video provides overview of loading LWPolylines into SQL Server database.
Creating the LoadPolylines() Method12:59
This video shows how to code the LoadLWPolylines() method.
Running the LoadPlines() Method3:00
This video shows the execution of LoadLWPolylines() method.
Loading Blocks (No Attribute) into SQL Server Database - Overview1:22
This video provides overview of loading Blocks (no attribute) into SQL Server database.
Creating the LoadBlocksNoAttribute() Method10:29
This video shows how to code LoadBlocksNoAttribute() method.
Running the LoadBlocksNoAttribute() Method2:35
This video shows the execution of LoadBlocksNoAttribute() method.
Loading Blocks (with Attributes) into SQL Server Database - Overview1:06
This video provides overview of loading Blocks (with Attributes) into SQL Server database.
Creating the LoadBlocksWithAttributes() Method7:21
This video shows how to code the LoadBlocksWithAttributes() method.
Running the BlocksWithAttributes() Method2:14
This video shows the execution of LoadBlocksWithAttributes() method.

Section Overview2:02
This video discusses the topics to be covered in this section.
Retrieving Lines from SQL Server Database - Overview1:22
This video provides overview of retrieving Lines from SQL Server database.
Creating the DBRetrieveUtil Class2:36
This video shows the creation of DBRetrieveUtil Class to be used for creating all the retrieval methods.
Creating the RetrieveAndDrawLines() Method (Part 1)16:32
This video shows the creation of RetrieveAndDrawLines() method.
Creating the GetColorIndex() Method4:30
This video shows the creation of GetColorIndex() method.
Creating the RetrieveAndDrawLines() Method (Part 2)10:44
This is a continuation video of creating the RetrieveAndDrawLines() method.
Running and Testing the RetrieveAndDrawLines() Method8:36
This video shows the execution of RetrieveAndDrawLines() method.
Retrieving MTexts from SQL Server Database - Overview1:15
This video discusses about retrieving MTexts from SQL Server database.
Creating the RetrieveAndDrawMTexts() Method11:28
This video shows the creation of RetrieveAndDrawMTexts() method.
Running and Testing the CreateAndDrawMTexts() Method4:37
This video shows the execution of CreateAndDrawMTexts() method.
Retrieving LWPolylines from SQL Server Database - Overview1:16
This video provides overview of retrieving LWPolylines from SQL Server database.
Creating the RetrieveAndDrawPlines() Method12:14
This video shows the creation of RetrieveAndDrawPlines() method.
Running and Testing the RetrieveAndDrawPlines() Method4:47
This video shows the execution of RetrieveAndDrawPlines() method.
Retrieving Blocks (No Attribute) from SQL Server Database - Overview1:05
This video shows provides overview of retrieving Blocks (No Attributes) from SQL Server database.
Creating the RetrieveAndDrawBlocksNoAttribute() Method11:05
This video shows the creation of RetrieveAndDrawBlocksNoAttributes() method.
Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method4:37
This video shows the execution of RetrieveAndDrawBlocksNoAttribute() method.
Retrieving Blocks (with Attributes) from SQL Server Database - Overview1:27
This video provides overview of retrieving Blocks (with Attributes) from SQL Server database.
Creating the RetrieveAndDrawBlocksWithAttributes() Method21:16
This video shows the creation the RetrieveAndDrawBlocksWithAttributes() method.
Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method9:38
This video shows the execution of RetrieveAndDrawBlocksWithAttributes() method.

Section Overview0:58
This video provides overview of updating data in SQL Server database from AutoCAD.
Updating Lines in SQL Server Database - Overview1:04
This video provides overview of updating lines from SQL Server database from AutoCAD.
Creating the DBUpdateUtil Class1:55
This video shows how the creation of DBUpdateUtil Class to be used for creating all the update methods.
Creating the UpdateLines() Method24:41
This videos shows the creation of UpdateLines() method.
Creating the User Interface for UpdateLines() Method2:02
This shows the creation of User Interface for the UpdateLines() method.
Running and Testing the UpdateLines() Method7:33
This video shows the execution of UpdateLines() method.
Updating MTexts in SQL Server Database - Overview1:05
This video provides overview of updating MTexts from SQL Server database.
Creating the UpdateMTexts() Method9:28
This video shows the creation of UpdateMTexts() method.
Creating the User Interface for UpdateMTexts()1:05
This video shows the creation of User Interface for UpdateMTexts() method.
Running and Testing the UpdateMTexts() Method7:27
This video shows the execution of UpdateMTexts() method.
Updating the LWPolylines in SQL Server Database - Overview0:53
This video provides overview of updating LWPolylines in SQL Server Database from AutoCAD.
Creating the UpdateLWPolylines() Method8:52
This video shows the creation of UpdateLWPolylines() method.
Creating the User Interface for UpdatePolylines() Method1:08
This video shows the creation of User Interface for UpdatePolylines() method.
Running and Testing the UpdateLWPolylines() Method6:45
This video shows the execution of UpdateLWPolylines() method.
Updating Blocks (No Attributes) in SQL Server Database - Overview1:10
This video provides overview about updating Blocks (No Attributes) in SQL Server database.
Creating the UpdateBlocksNoAttributes() Method9:38
This video shows the creation of UpdateBlocksNoAttributes() method.
Creating the User Interface for UpdateBlocksNoAttributes() Method1:21
This video shows the creation of User Interface for the UpdateBlocksNoAttributes() method.
Running and Testing the UpdateBlocksNoAttributes() Method4:08
This video shows the execution of UpdateBlocksNoAttributes() method.
Updating Blocks With Attributes in SQL Server Database - Overview1:02
This video provides overview of updating Blocks (with Attributes) in SQL Server.
Creating the UpdateBlocksWithAttributes() Method8:12
This video shows the creation of UpdateBlocksWithAttributes() method.
Creating the User Interface for UpdateBlocksNoAttributes() Method1:09
This video shows the creation of User Interface for the UpdateBlocksWithAttributes() method.
Running and Testing the UpdateBlocksWithAttributes() Method8:39
This video shows the execution of UpdateBlocksWithAttributes() method.

Section Overview1:38
This video provides overview of this section.
Deleting Lines in SQL Server from AutoCAD - Overview1:12
This video provides overview of deleting Lines in SQL Server from AutoCAD.
Creating the DBDeleteUtil Class1:27
This video shows the creation of DBDeleteUtil Class.
Creating the DeleteLines() Method13:02
This video shows the creation of DeleteLines() method.
Creating the User Interface for the DeleteLines() Method2:02
This video shows the creation of User Interface for DeleteLines() method.
Running and Testing the DeleteLines() Method3:29
This video shows the execution of DeleteLines() method.
Deleting MTexts in SQL Server Database from AutoCAD - Overview0:55
This video provides overview of deleting MTexts in SQL Server Database from AutoCAD.
Creating the DeleteMTexts() Method3:33
This video shows the creation of DeleteMTexts() method.
Creating the User Interface for DeleteMTexts() Method1:03
This video shows the creation of User Interface for the DeleteMTexts() method.
Running and Testing the DeleteMTexts() Method2:30
This video shows the execution of DeleteMTexts() method.
Deleting LWPolylines in SQL Server Database from AutoCAD - Overview0:58
This video provides overview of deleting LWPolylines in SQL Server Database from AutoCAD.
Creating the DeletePlines() Method3:30
This video shows the creation of DeletePlines() method.
Creating the User Interface for the DeletePlines() Method0:59
This video shows the creation of UI for DeletePlines() method.
Running and Testing the DeletePlines() Method1:51
This video shows the execution of DeletePlines() method.
Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD - Overview1:04
This video provides overview of deleting Blocks (No Attribute) from database.
Creating the DeleteBlocksNoAttribute() Method2:49
This video shows the creation of DeleteBlocksNoAttribute() method.
Creating the User Interface for DeleteBlocksNoAttribute() Method0:55
This video shows the creation of UI for DeleteBlocksNoAttribute() method.
Running and Testing DeleteBlocksNoAttribute() Method2:02
This video shows the execution of DeleteBlocksNoAttribute() method.
Deleting Blocks (With Attributes) in SQL Server Database from AutoCAD - Overview1:12
This video provides overview of deleting Blocks (with Attributes) in SQL Server database from AutoCAD.
Creating the DeleteBlocksWithAttributes() Method2:22
This video shows the creation of DeleteBlocksWithAttributes() method.
Creating the User Interface for DeleteBlocksWithAttributes() Method1:04
This video shows the creation of UI for DeleteBlocksWithAttributes() method.
Running and Testing the DeleteBlocksWithAttributes() Method1:44
This video shows the execution of DeleteBlocksWithAttributes() method.

Requirements

Basic knowledge of AutoCAD Programming using C#
Basic knowledge of SQL Server Database

Description

This course will walk you through programming AutoCAD .NET API with SQL Server Database integration using C#. This is a hands-on course with lots of coding to teach you how to perform basic database operations like Create, Read, Update, and Delete (CRUD). You will learn how to extract AutoCAD objects' properties and load them into SQL Server database.

You will learn the following:

- Learn AutoCAD .NET API Programming using C#

- Learn how to use Windows Forms for your User Interface

- Learn how to use XDATA to attach to and read from the object

- Learn how to connect to SQL Server database using ActiveX Data Object (ADO)

- Learn to perform Create, Read, Update and Delete (CRUD) using SQL Server Database

- Learn how to use SQL Server Management Studio

- Learn how to extract Line Object's Properties and store/retrieve into/from SQL Server Database

- Learn how to extract MText Object's Properties and store/retrieve into/from SQL Server Database

- Learn how to extract LWPolyline Object's Properties and store/retrieve into/from SQL Server Database

- Learn how to extract Blocks (with/without attributes) Object's Properties and store/retrieve into/from SQL Server Database

After taking this course, you will have a strong knowledge working with AutoCAD and SQL Server Database by storing your data persistently that you can use for other Applications.

Who this course is for:

AutoCAD Developers who want to learn database processes
Anyone who wants to learn how to interface AutoCAD and SQL Server Database

Programming AutoCAD with SQL Server Database using C#

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 4min

Section 2 - Tools and SQL Queries9 lectures • 47min

Section 3 - Create Database and Tables7 lectures • 27min

Section 4 - Loading into SQL Server Database20 lectures • 1hr 47min

Section 5 - Retrieving Data from Database19 lectures • 2hr 11min

Section 6 - Updating Data in SQL Server Database - Overview22 lectures • 1hr 50min

Section 7 - Deleting Data in SQL Server Database from AutoCAD - Overview22 lectures • 51min

Section 8 - Conclusion1 lecture • 1min

Miscellaneous1 lecture • 7min

Requirements

Description

Who this course is for: