none
Develop Payroll Application RRS feed

  • Question

  • can we develop payroll application in sharepoint using sql server and c# .I means i want to create a payroll in sharepoint but the value of the custom field will not go into WSS_Content database .Inspite of that it will go into the database created by me and here will can also create the custom field from Front End means from sharepoint site as usually we create in sharepoint lists and the fields will automatically get updated in tables in the database.Do needful suggestion.
    Thursday, January 28, 2016 12:36 PM

Answers

  • Hi,

    You could develop your application in SharePoint with most of your columns created inside of the SharePoint List and some others (more complex) could come from your SQL database. 

    This kind of field is called External data column. They are linked to your SQL using the Business Data Connectivity (BDC) service. Here is how you could create such column : https://msdn.microsoft.com/en-us/library/office/ee559346(v=office.14).aspx

    However, since most payroll application often require complex data relationship I would not recommend SharePoint for the backend. 

    See this article for more information about using SharePoint list vs Database Table : https://msdn.microsoft.com/en-us/library/ff647105.aspx

    Best regards

    Samuel Levesque | http://sharepointerie.com | Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Thursday, January 28, 2016 3:10 PM