I need to fetch some information from sql database (either from table created by me in umbraco database or from external databse) . how to do that in umbraco...
You can use any database access method you choose. If you want to use Umbraco's SQLhelper then there's a simple example here (though I think you should close the reader after you're done)
With Visual studio create a usercontrol that fetch the data you need and register into umbraco as macro. Connection string you can add to either to web.config either directly in usercontrol.
Connect to sql datatbase
Hi
I need to fetch some information from sql database (either from table created by me in umbraco database or from external databse) . how to do that in umbraco...
Hi,
You can use any database access method you choose. If you want to use Umbraco's SQLhelper then there's a simple example here (though I think you should close the reader after you're done)
http://our.umbraco.org/forum/developers/api-questions/23592-how-to-use-SqlHelper-and-read-table-data?p=0
Rich
Hello,
With Visual studio create a usercontrol that fetch the data you need and register into umbraco as macro. Connection string you can add to either to web.config either directly in usercontrol.
Hey rich,
Thanks for the reply .. in the link u have given.. umbraco.businesslogic dll is used .. where can i get that Dll.
Hey,
In your Umbraco install, check the /bin directory, all the dlls are in there.
Regards
Rich
Hey,
I cant find that Dll in my Bin .. thats y asked .. is it associated with some default package alone???
It's in there, it's named 'businessLogic.dll'
Rich
oh.. its there .. sorry for my stupidity.. thanks rich.
is working on a reply...