Connect SQL with Inventor using C#

Connect SQL with Inventor using C#

Anonymous
Not applicable
738 Views
3 Replies
Message 1 of 4

Connect SQL with Inventor using C#

Anonymous
Not applicable

I would like to know if it is possible to connect and send values from a SQL Server Database to Inventor, using Visual Studio C# 2010.

0 Likes
739 Views
3 Replies
Replies (3)
Message 2 of 4

frederic.vandenplas
Collaborator
Collaborator

Hi,

 

Why not, it depends on what you want to do.

 

If you think this answer fullfilled your needs, improved your knowledge or leads to a solution,
please feel free to "kudos"
0 Likes
Message 3 of 4

tolgay.hickiran
Advisor
Advisor
I'd recommend you to install 2017 community version too as its free until 1m$ sales. And it is possible to connect to any database.

Some worthwhile ideas
Copy Design should rename ilogic Rules too!
Why Nastran In-CAD doesn't have an SDK?IMPLEMENTED!

Tolgay Hickiran
Founding Partner
SignatureSignature

website
emailskypelinkedinyoutubeemail

0 Likes
Message 4 of 4

AlexFielder
Advisor
Advisor

You sure can!

 

I last did this ~7 years ago. (I can't believe it's been that long!!!)

 

I just uploaded the solution I created back then to my github.com repositories:

 

https://github.com/AlexFielder/InventorRibbonCmds

 

Please bear in mind that this was created before the "youraddinname.addin" functionality was added to Inventor so it probably won't run without substantial amendments but the forms and everything else should still function correctly; obviously, the database it connected to doesn't exist any more either so you'd need your own connection string such as this:

 

<Connection Mode="AppSettings" ConnectionString="Data Source=YOURSERVERNAME;Initial Catalog=DWGDetails;Integrated Security=True" SettingsObjectName="NewRibbonCmds.My.MySettings" SettingsPropertyName="DWGDetailsConnectionString1" Provider="System.Data.SqlClient" />

I used this to help us when filling out drawing border properties and had a number of the textboxes on our userform set to autocomplete from values in the database. It's a bit of a shame we never used it for more than a few months really.

 

I've been trying to see if I kept a copy of the table structure in .sql format but haven't had any luck so far.

 

Cheers,

 

Alex.

0 Likes