HOT

Programming AutoCAD with SQL Server Database using C#

Development

Rating4.5
Enroll Now

Programming AutoCAD with SQL Server Database using C#, available at $69.99, has an average rating of 4.45, with 102 lectures, based on 46 reviews, and has 420 subscribers.

You will learn about 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# This course is ideal for individuals who are AutoCAD Developers who want to learn database processes or Anyone who wants to learn how to interface AutoCAD and SQL Server Database It is particularly useful for AutoCAD Developers who want to learn database processes or Anyone who wants to learn how to interface AutoCAD and SQL Server Database.

Enroll now: Programming AutoCAD with SQL Server Database using C#

Summary

Title: Programming AutoCAD with SQL Server Database using C#

Price: $69.99

Average Rating: 4.45

Number of Lectures: 102

Number of Published Lectures: 100

Number of Curriculum Items: 102

Number of Published Curriculum Objects: 100

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will 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#

Who Should Attend

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

Target Audiences

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

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 Curriculum

Chapter 1: Introduction

Lecture 1: Course Topics

Lecture 2: Introduction

Chapter 2: Section 2 – Tools and SQL Queries

Lecture 1: Section Overview

Lecture 2: Downloading Visual Studio 2019

Lecture 3: Downloading SQL Server Express

Lecture 4: Downloading SQL Server Management Studio (SSMS)

Lecture 5: SQL Queries – Overview

Lecture 6: INSERT SQL Statement – Demo

Lecture 7: SELECT SQL Statement – Demo

Lecture 8: UPDATE SQL Statement – Demo

Lecture 9: DELETE SQL Statement – Demo

Chapter 3: Section 3 – Create Database and Tables

Lecture 1: Section Overview

Lecture 2: Creating the CADDB Database

Lecture 3: Creating the Lines Table

Lecture 4: Creating the MTexts Table

Lecture 5: Creating the Plines Table

Lecture 6: Creating the BlocksNoAttribute Table

Lecture 7: Creating the BlocksWithAttributes Table

Chapter 4: Section 4 – Loading into SQL Server Database

Lecture 1: Section Overview

Lecture 2: Loading Lines into SQL Server Database

Lecture 3: Creating the CADDB Project

Lecture 4: Creating the Settings File

Lecture 5: Creating the GetConnection Method

Lecture 6: Creating the LoadLines() Method

Lecture 7: Creating the User Interface for the LoadLines() method

Lecture 8: Running the LoadLines() Method

Lecture 9: Loading MTexts into SQL Server Database – Overview

Lecture 10: Creating the LoadMTexts() Method

Lecture 11: Running the LoadMTexts() Method

Lecture 12: Loading LWPolylines into SQL Server Database – Overview

Lecture 13: Creating the LoadPolylines() Method

Lecture 14: Running the LoadPlines() Method

Lecture 15: Loading Blocks (No Attribute) into SQL Server Database – Overview

Lecture 16: Creating the LoadBlocksNoAttribute() Method

Lecture 17: Running the LoadBlocksNoAttribute() Method

Lecture 18: Loading Blocks (with Attributes) into SQL Server Database – Overview

Lecture 19: Creating the LoadBlocksWithAttributes() Method

Lecture 20: Running the BlocksWithAttributes() Method

Chapter 5: Section 5 – Retrieving Data from Database

Lecture 1: Section Overview

Lecture 2: Retrieving Lines from SQL Server Database – Overview

Lecture 3: Creating the DBRetrieveUtil Class

Lecture 4: Creating the RetrieveAndDrawLines() Method (Part 1)

Lecture 5: Creating the GetColorIndex() Method

Lecture 6: Creating the RetrieveAndDrawLines() Method (Part 2)

Lecture 7: Running and Testing the RetrieveAndDrawLines() Method

Lecture 8: Retrieving MTexts from SQL Server Database – Overview

Lecture 9: Creating the RetrieveAndDrawMTexts() Method

Lecture 10: Running and Testing the CreateAndDrawMTexts() Method

Lecture 11: Retrieving LWPolylines from SQL Server Database – Overview

Lecture 12: Creating the RetrieveAndDrawPlines() Method

Lecture 13: Running and Testing the RetrieveAndDrawPlines() Method

Lecture 14: Retrieving Blocks (No Attribute) from SQL Server Database – Overview

Lecture 15: Creating the RetrieveAndDrawBlocksNoAttribute() Method

Lecture 16: Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method

Lecture 17: Retrieving Blocks (with Attributes) from SQL Server Database – Overview

Lecture 18: Creating the RetrieveAndDrawBlocksWithAttributes() Method

Lecture 19: Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method

Chapter 6: Section 6 – Updating Data in SQL Server Database – Overview

Lecture 1: Section Overview

Lecture 2: Updating Lines in SQL Server Database – Overview

Lecture 3: Creating the DBUpdateUtil Class

Lecture 4: Creating the UpdateLines() Method

Lecture 5: Creating the User Interface for UpdateLines() Method

Lecture 6: Running and Testing the UpdateLines() Method

Lecture 7: Updating MTexts in SQL Server Database – Overview

Lecture 8: Creating the UpdateMTexts() Method

Lecture 9: Creating the User Interface for UpdateMTexts()

Lecture 10: Running and Testing the UpdateMTexts() Method

Lecture 11: Updating the LWPolylines in SQL Server Database – Overview

Lecture 12: Creating the UpdateLWPolylines() Method

Lecture 13: Running and Testing the UpdateLWPolylines() Method

Lecture 14: Updating Blocks (No Attributes) in SQL Server Database – Overview

Lecture 15: Creating the UpdateBlocksNoAttributes() Method

Lecture 16: Creating the User Interface for UpdateBlocksNoAttributes() Method

Lecture 17: Running and Testing the UpdateBlocksNoAttributes() Method

Lecture 18: Updating Blocks With Attributes in SQL Server Database – Overview

Lecture 19: Creating the UpdateBlocksWithAttributes() Method

Lecture 20: Creating the User Interface for UpdateBlocksNoAttributes() Method

Lecture 21: Running and Testing the UpdateBlocksWithAttributes() Method

Chapter 7: Section 7 – Deleting Data in SQL Server Database from AutoCAD – Overview

Lecture 1: Section Overview

Lecture 2: Deleting Lines in SQL Server from AutoCAD – Overview

Lecture 3: Creating the DBDeleteUtil Class

Lecture 4: Creating the DeleteLines() Method

Lecture 5: Creating the User Interface for the DeleteLines() Method

Lecture 6: Running and Testing the DeleteLines() Method

Lecture 7: Deleting MTexts in SQL Server Database from AutoCAD – Overview

Lecture 8: Creating the DeleteMTexts() Method

Lecture 9: Creating the User Interface for DeleteMTexts() Method

Lecture 10: Running and Testing the DeleteMTexts() Method

Lecture 11: Deleting LWPolylines in SQL Server Database from AutoCAD – Overview

Lecture 12: Creating the DeletePlines() Method

Lecture 13: Creating the User Interface for the DeletePlines() Method

Lecture 14: Running and Testing the DeletePlines() Method

Lecture 15: Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD – Overview

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 2 votes
  • 4 stars: 13 votes
  • 5 stars: 31 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Content Creation with ChatGPT + AI Tools

Blogging For Beginners: Start, Grow and Monetize (Sinhala)

(NEW) The Complete Growth Hacking & Conversion Course