I have a Form based authentication website in SharePoint 2010 . Now I want to create a custom registration web part in which users themselves can register on the website and can get their account created.
Remember the backend of users information will be in SQL server. My main problem is that I'm not quite sure how to connect SharePoint webpart or SharePoint application page with SQL server.
How to store the values of a custom form in SQL Server?
For ex , I have placed a text box for username and I want that when users save the info the value should get stored in SQL server table.
Also if I can similarly display the values of column into the fields so that user can edit their info.