Avatar of Wilder1626
Wilder1626
Flag for Canada asked on

VB.Net - Connecting to Dynamics CRM tables and feed DataGridView

Hi everyone.

I was wondering if anyone has been able to connect a VB.Net project to Dynamics 365 tables so that it feeds a DataGridView on a Form?

I have Visual Studio 2019 version and i'm using VB code.

What would we need exactly? A driver? A specific connection String? Any NuGets like Microsoft.CrmSdk.CoreTools or others?

Thank you for your help.
Visual Basic.NET* Dynamics CRMMicrosoft Dynamics* Microsoft Dynamics 365

Avatar of undefined
Last Comment
Wilder1626

8/22/2022 - Mon
Wilder1626

ASKER
I've just learned that i may have 2 ways to connect.
  • REST API (Faster recommended option)
  • SOAP
So if i understand it correctly, i should look at REST.

I have already found what i probably need:
  • Service Root URL
  • Endpoint Address
  • ID
  • Unique Name

Now i would normally need to find how to connect first  and see if i need any drivers before i can start pulling data.

Any help / guidance on how to connect using REST would be very appreciated.

Thanks you
ASKER CERTIFIED SOLUTION
Chinmay Patel

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Wilder1626

ASKER
Thanks for your info.

Next week, i will ask what version we have, Online or On-Premise. I will also be able to tell you more about the usage.
Chinmay Patel

Happy to help :)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Wilder1626

ASKER
Hi Chinmay 
To answer the first question about the version we have, It’s Online (public cloud), so in my case, i don’t need a VPN to connect to it.

For business / usage scenario, i need to pull information for a table and populate a DataGridView from my project, but at the end, i would like to also save to Dynamics based on what i have in my form textboxs.