Link to home
Start Free TrialLog in
Avatar of Wilder1626
Wilder1626Flag 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.
Avatar of Wilder1626
Wilder1626
Flag of Canada image

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
Avatar of Chinmay Patel
Chinmay Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Happy to help :)
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.