Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Extend the web service

(0) ShareShare
ReportReport
Posted on by 3,732

Hi,

I am working on the extending the web service. I have created the table in the GP database, but I don't know how to map the object in the database table.

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    24,410 on at
    RE: Extend the web service

    Creating tables in SQL server is not a recommended solution. You need to create table from dexterity. After tables created from dexterity you can use this from visual studio.

    For creating new fields and tables follow the below link.

    community.dynamics.com/.../106975.aspx

    Hope this helps!!!

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Extend the web service

    Hi Sathish,

    you can use SQL connection class to connect to the server back-end tables.

    please find the attached links with examples that may guide you.

    www.codeproject.com/.../sqlplusconnectionplusstringplusinplusc

    www.codeproject.com/.../Beginners-guide-to-accessing-SQL-Server-through-C

    msdn.microsoft.com/.../system.data.sqlclient.sqlconnection.aspx

    www.daniweb.com/.../how-do-you-connect-to-a-sql-database-using-c

  • Sathish Sivakumar Profile Picture
    3,732 on at
    RE: Extend the web service

    Hi Soma,

    Thanks for you reply.

    I am working on creating new field in the "Customer Maintenance" form. So that I created 3 tables in the SQL Server.

    How can I call that object from the database table in the visual studio?

  • soma Profile Picture
    24,410 on at
    RE: Extend the web service

    Sathish,

    Can you provide more details about your requirement? Where did you create the table in GP DB?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans