Database connectivity using silverlight

I want to validate username & password in my 'login form' from the database.i am using SQL server 2008 and silverlight 4.Please tell me how to do that... i am getting an error while adding a service reference: "System.InvalidOperationException: The type 'Scragil.Web.Service1', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found"

Hi, I am getting errors in my code. Please help. namespace ApurvHSamantPlanktonprogf500 { public partial class Page : UserControl { public Page() { InitializeComponent(); } private void UserControl_Loaded(object sender, RoutedEventArgs e) { ServiceReference1.ServiceClient webService = new ServiceReference1.ServiceClient(); webService.GetaaSpeciesListsCompleted += new EventHandler<ApurvHSamantPlanktonprogf500.ServiceReference1.GetaaSpeciesListsCompletedEventArgs>(webService_GetaaSpeciesListsCompleted); webService.GetaaSpeciesListsAsync(); } void webService_GetaaSpeciesListsCompleted(Object sender, ServiceReference1.GetaaSpeciesListsCompletedEventArgs e) { grdData.ItemsSource = e.Result; } } The places in bold are the once wherein I am getting errors. Thanking you.

Nice example Raj - really useful and easy to follow. I'm using VWD 2010 Beta so had to change DisplayMemberBinding -> Binding I also got sa is not a trusted user when trying to access the Vendor database. I eventually got round this by using the MS Web Platform Installer to install MS SQL Server 2008 along with its Management tool, attached your DB, added myself as a user, created the ConnectionString using a Test.udl on my Desktop and replacing the one in the WebConfig file with that.

how to edit and save in the datagrid to the service

Hey i tried the given solution in this article. But this is only ofr database retirieval. I would like to know how to do add delete and modify operations in database and also commit the changes. I got many solutions on internet. But htey're very complex. I expect something much simple like this one for retireval is... Please help....