Programming AutoCAD with SQL Server Database Using C#

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#

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

TAKE THIS COURSE

1 Year Access

Intermediate

3 Students

7 hours, 58 minutes

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.

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

Course Ratings

N.A

ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Ratings found for this course.

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.

Welcome!

Let's Begin!

Create Account

Programming AutoCAD with SQL Server Database Using C#

Programming AutoCAD with SQL Server Database Using C#