Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 56 Minute(s)
Language
English
Taught by
Arnold Higuit
Rating
Course Overview
Programming AutoCAD .NET API with SQL Server Database integration using C#. You will perform database CRUD operations
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.
Course Content
- 7 section(s)
- 100 lecture(s)
- Section 1 Introduction
- Section 2 Section 2 - Tools and SQL Queries
- Section 3 Section 3 - Create Database and Tables
- Section 4 Section 4 - Loading into SQL Server Database
- Section 5 Section 5 - Retrieving Data from Database
- Section 6 Section 6 - Updating Data in SQL Server Database - Overview
- Section 7 Section 7 - Deleting Data in SQL Server Database from AutoCAD - Overview
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#
Skills covered in this course
Reviews
-
YYazid Hamodah
Very structered and easy to learn course, easy to learn and develop your skills with short period of time, there are plenty of elements to try on. Once you complete the first part of section you can consider the rest is practice and learning at same time.
-
RRichard Harris
So far yes. I took the first quarter of this on Youtube, that's how I found out about this website.
-
정정호연
Thanks so much
-
SSteven Brubaker
Thank you for making this course! I had tried this with AutoCAD Map 3D 2011 years ago and it did not go well. I ended up using the FDO portion (Map and Civil 3D subsystem) instead. This time, with your coding/demos, I got it running with PostgreSQL (PostGIS) and SQLite (Spatial) as a database both with and without FDO/georeferenced objects as a datasource. [Yes, I didn't use MSSQL but if you are new to the AutoCAD and/or C# API's , I recommend you follow along with MSSQL the first time.]
