Inserting data into manually created table in umbraco db
Hi ,
I need to create a simple form to capture user details and save into the database, The form consist of personal details, the user has to enter and then on pressing confirm, the system should save all the information into db, I have created a separate table in the umbraco database, but i am out of ideas of how to implement this , how to inject sql select queries , insert queries and how to get connecting string inorder to use ado.net for insertion. I cant find any example of carrying out these steps using umbraco. I have created a usercontrol just for a start but don,t know how to start from there.
Any assistance or suggestions will be highly appreciated.
Inserting data into manually created table in umbraco db
Hi ,
I need to create a simple form to capture user details and save into the database, The form consist of personal details, the user has to enter and then on pressing confirm, the system should save all the information into db, I have created a separate table in the umbraco database, but i am out of ideas of how to implement this , how to inject sql select queries , insert queries and how to get connecting string inorder to use ado.net for insertion. I cant find any example of carrying out these steps using umbraco. I have created a usercontrol just for a start but don,t know how to start from there.
Any assistance or suggestions will be highly appreciated.
Regards
Thanks
hi mr A.
you can wrap your form with user control.
how to get all the connection string stuff
if your table/s are on your umbraco site DB you can find the connection string in web config, search for :
<appSettings>
<add key="umbracoDbDSN" value="connection string" />
Well to get ConfigurationManager.AppSettings["umbracoDbDSN"] working , what libraries i have to call?
is working on a reply...