Extend the web service

(0) Share

Report

Posted on by Sathish Sivakumar

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

I have the same question (0)

All responses (4)

Answers (0)

soma 24,410 on at

Like (0)

Report

Sathish,

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

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No