I need to create a form as part of the workflow with details and validation by taking some data from leave database such as Leave available and work replacement with other details.

So, i need to create form which reads data from a sql server database and validates input in in a format.

I know this can be done in two ways,

  1. With Webpart in Visual Studio by fully coding
  2. with Infopath by drag and drop, customization.

I want to know are there any other ways to do it, if there what it is ?

Are there any way to do it fully in Administrative mode i.e not so much coding, just doing customization and change some parameters, if that can you share any link of a tutorial of it.

I was trying with the Webpart in VS way, but couldn't finish it totally, are there any good tutorials available, i google a lot, but couldn't find the perfect one to meet my requirements. Please also share good materials on infopath on this.

1 Answer 1


InfoPath Way:
Have a look at this, seems like he is showing what you want to achieve!

And if you want to learn more about InfoPath forms with SharePoint without any coding then you must follow Laura Roger's Blog, she has written a book on InfoPath with SharePoint as well

Visual Web Pary Way:
Visual Web Parts are just like you are using ASP.NET Application to build your custom solution [with a slight difference of SharePoint Controls availability and SharePoint Object Model]... I would suggest you to read SharePoint Object Model, and you will be doing Web Part development as a piece of cake :-)

Another Way:
You may create a custom list and modify its default form in SharePoint Designer to meet the custom validations and create a workflow on Custom List, again using OOB Workflows or custom Workflow in SharePoint Designer... But modifying list forms is quite a hectic, and is not preferred over InfoPath

SUGGESTED: Go for InfoPath Form, you will make your life easier!

I hope this helps

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.