How to retreive data from SQL server in silver light application

Question

        I have added silver light application in my web site.Now i am having sql connection in web.config.How to access the website web.config sqlconnection from silver light application.

        If its not possible give me any good link to access SQL database from silver light application.

Muralidharan Deenathayalan · Answer

Yes it is possible , you can read connection string values from web.config in SilverLight application. From ASP.net application , you can read web.config values assign the values in Init param in SilverLight object tag. http://asimsajjad.blogspot.com/2010/11/reading-webconfig-to-pass-values-to.html http://kevindockx.blogspot.com/2008/12/silverlight-easily-reading-application.html Try this , if you're are not able to do i will do sample and I'll attach it. If you want to access any value from database, they you may need to WCF services. Hope this helps you.

Suthish Nair · Answer

I don't have a working sample right now, give me some time will attach sample code. Or wait for more replies. Did you read the answers posted on above thread. Using SilverLight InitParameters property you can assign and retrieve the values. refer thread: http://forums.silverlight.net/forums/p/87279/399949.aspx

Gomathi Palaniswamy · Answer

Suthis, I have not get any clear view about this issue.Give me any article link.If possible give me some sample code.

Suthish Nair · Answer

good link

How to retreive data from SQL server in silver light application

Answers (4)