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
Announcements
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
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!!!
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
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?
Sathish,
Can you provide more details about your requirement? Where did you create the table in GP DB?
Almas Mahfooz
3
User Group Leader