Click here to Skip to main content

Rasadul Alam Rashed asked:

Open original thread
Problem in Silverlight project in ASP.NET
Hi,
I want to make a simple Silverlight application in ASP.NET and LINQ. I have two talbe
Student :[student_id,student_name,address, phone,country_id]
Country :[country_id,country_name]

Thiw tow table is join by country_id.
I have inluced a LINQ Data Class in my project.
I have included a Silverlight-Enabled-WCF-Serfice. In this service I have made tow method and there code is like
        [OperationContract]
        public List<Country> LoadCountry()
        {
            var result = from coun in oLINQDataClassesDataContext.Countries
                         select coun;
            return result.ToList();
        }
 
        [OperationContract]
        public IList<Student> LoadStudent()
        {
 
            var result = from std in oLINQDataClassesDataContext.Students
                         select std;        
            return result.ToList();
        }
 
Then I add a service reference of that WCF service. Then I include a DataGrid in my silverlight .xml file.
Now I want to show all the students in that DataGrid. For this I have written the following code
 
WCFServiceReference.WCFServiceClient oWCFServiceClient = new WCFServiceReference.WCFServiceClient();
        
        
        public Home()
        {
            InitializeComponent();
            oWCFServiceClient.LoadStudentCompleted += new EventHandler<WCFServiceReference.LoadStudentCompletedEventArgs>(oWCFServiceClient_LoadStudentCompleted);
            oWCFServiceClient.LoadStudentAsync();
           
        }
 
        void oWCFServiceClient_LoadStudentCompleted(object sender, WCFServiceReference.LoadStudentCompletedEventArgs e)
        {
            dataGrid1.ItemsSource = e.Result;
        }
 
Then I build the whole project and found no error. If I run the project then I found an error and it is--

An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Silverlight.WCFServiceReference.LoadStudentCompletedEventArgs.get_Result()
at Silverlight.Home.oWCFServiceClient_LoadStudentCompleted(Object sender, LoadStudentCompletedEventArgse)
at Silverlight.WCFServiceReference.WCFServiceClient.OnLoadStudentCompleted(Object state)

 
If I remove county table form the LINQ class and remove LoadCountry() method form the service and call LoadStudent() method form silverlight form then it runs accurately and all the data is displayed in my DataGrid.
If I remove student table form the LINQ class and remove LoadStudent() method form the service then LoadCountry() method runs accurately. Both methods are not work if the present same time in LINQ WCF Service .
 
NB: Both tables has data. If I run a SQL join query then it returns data
 

I can’t understand what the problem is.
 
Is there anyone to help me regarding this problem?
 
Thanks in advance.
Rashed
Tags: C#, ASP.NET, LINQ, Silverlight

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100