Forum Discussion
Developing custom web part on Sharepoint 2019
Hello everyone,
I need to develop custom web parts that read data from SQL and Oracle databases.
Kindly advise what is the best practice to execute the above on SharePoint 2019.
Many thanks in advance,
- Hi,
You can use SPFx or SharePoint app but both are client side coding, to access the DB, there has to be a API which i think its over kill for your project. If you think that there is an API or web service that can return the data from DB then you can use SPFx or SharePoint App.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
- Hi,
Since it is SharePoint On-Prem, you will have full control over your server, so you can develop the feature as a web part or application page. You can use the default connection method as we use in .Net by having the connection string in web.config. Let me know whether you are looking for some other things.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...Hi Sudharsan K,
Many thanks for your reply.
Any advise on how to deploy/install it on my site?
I am used to create the web part as an ascx file using c# that I copy in the Layouts/ User Controls folder and also install the related dll file in the GAC.
Best regards,
- Hi,
You dont have to do all these manually, follow the below link for step by step process
https://www.sharepointsky.com/sharepoint-2016-visual-web-part-using-visual-studio/#Create_visual_web_parts_using_visual_studio_20152013_in_SharePoint_20162013_step_by_step
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
