I have a need where I need to get data from a table that I created that I would like to run using the connection credentials GP is using.
How can I get the connection string using VS Tools for GP?
Or is there a way for VS tools run a query and retrieve a record set?
*This post is locked for comments
Here is the code I use to establish the connection
You will need to register with Microsoft to get the license keys. I believe you can ask your partner to get you these keys.
GPConnObj.Init("MyCompanyName", "MyLicenseKeys");
private SqlConnection GetConnection()
{
SqlConnection DataConnection = new SqlConnection();
/* Call Startup */
resp = GPConnection.Startup();
/* Create the connection object */
GPConnObj = new GPConnection();
/* Initialize the connection object */
GPConnObj.Init("MyCompanyName", "MyLicenseKeys");
/* Make the connection */
DataConnection.ConnectionString = "Database=" + Dynamics.Globals.IntercompanyId.Value;
GPConnObj.Connect(DataConnection, Dynamics.Globals.SqlDataSourceName.Value, Dynamics.Globals.UserId.Value, Dynamics.Globals.SqlPassword.Value);
/* Check the return code */
if ((GPConnObj.ReturnCode & (int)GPConnection.ReturnCodeFlags.SuccessfulLogin) !=
(int)GPConnection.ReturnCodeFlags.SuccessfulLogin)
{
MessageBox.Show("Login failed");
}
return DataConnection;
}
If you look through the the VS for GP documentation you will find example code. If you want I could paste a portion of my code in here next time.
Table is in GP Dynamics database. I'll look for those sample code. I might need some examples, though.
Is this table inside the GP company database or in a database outside of GP? If you have installed VS Tools for GP you will have sample code showing you how to use GPConnNet. This will alow you to use the user ID and password from the user ID currently logged into GP. You add options to a screen by adding an Additional Button and then you access to all the fields on that screen. But first, you create a data connection using the GP user ID/Password and company ID. Let me know if you need specific examples.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (