What I trying to do,I want to save some data in Database either it Umbraco CMS DB or in seprate DB,
Data would be First Name,Company Info,Upload Image Upload control,Moblile No etc few text boxes & Submit button.
On another page (Which is a page for admin) I ant to fetech saved data & show it in a GridView.
Now I don't know where to crate strored procedure (will it work through Umbraco DB) & do I have to create new connection string or use Umbraco default connection string . Basically my question about Data Accesss Layer.
Firstly, you don't need a separate db, you can use the umbraco db to store custom data as well. Stored procedures are fine too. As for the querying part, there's two options:
- Query data using your own DAL component. Are you using a ORM such as Subsonic? Fine too, you can still use that one. Just make sure to add a connection string to web.config (connectionStrings section)
- Query data using the umbraco datalayer. But, this won't work with stored procs, it will only allow querying data using plain old sql statements.
How to add save data in umbraco website?
I am using Umbraco 4.7 & I really like Umbraco but I stuck at how to make website dynamic & add forms,saving data to Umbraco website.
I know about adding a aspx page as a web control but I want to know , Is this the only way?
Do I need to add another database other than Umbraco's database, How can I save values,custom tables in Umbraco's DB.
Also Please clarify about Stored Procedure & ConnectionString in Umbraco?
Many Many Thanks, It will help me to achieve my goal in Umbraco
Pankaj Sharma,
Can you elaborate a bit more, it seems unclear to me what exactly you're trying to do. Have an example or use case?
Cheers,
/Dirk
Hi Drik Thanks for Response ,
What I trying to do,I want to save some data in Database either it Umbraco CMS DB or in seprate DB,
Data would be First Name,Company Info,Upload Image Upload control,Moblile No etc few text boxes & Submit button.
On another page (Which is a page for admin) I ant to fetech saved data & show it in a GridView.
Now I don't know where to crate strored procedure (will it work through Umbraco DB) & do I have to create new connection string or use Umbraco default connection string . Basically my question about Data Accesss Layer.
Hope it clearify my question
Ah ok, understood!
Firstly, you don't need a separate db, you can use the umbraco db to store custom data as well. Stored procedures are fine too. As for the querying part, there's two options:
- Query data using your own DAL component. Are you using a ORM such as Subsonic? Fine too, you can still use that one. Just make sure to add a connection string to web.config (connectionStrings section)
- Query data using the umbraco datalayer. But, this won't work with stored procs, it will only allow querying data using plain old sql statements.
Hope this helps.
Regards,
/Dirk
Thanks Man It clearify many things,
No i am not using ORM,Also I will use my own DAL & add new connection string in th web config.
Cheers :p
is working on a reply...