Displaying more than one row using Nusoap/php and visual studio (windowss phone)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hary4kings
    New Member
    • Apr 2015
    • 1

    #1

    Displaying more than one row using Nusoap/php and visual studio (windowss phone)

    THE Database is working fine with the php script/nusoap. but if i try to retrieving information about a particular student, visual studio (c#) crashes. I have another code that retrieve only a single row but i want every subject remain about a student. The attach file is the error message from visual studio.
    please i need urgent help.

    Code:
    Here is my nusoap/php script 
    
    function GetRemainingSubject($Sid){
           $connect = mysql_pconnect("******","****","*******")
           or die ('could not connect :'. mysql_error());
    	   IF ($connect){
    		   IF( mysql_select_db('theabani_sg',$connect));{       
      //$sql = ("select Subject_code,SemName,SemYear from enrolment_record where Sid =".$Sid." and Score < 50");
      $sql = ("select Subject_code,SemName,SemYear from enrolment_record,student where student.Sid =enrolment_record.Sid And enrolment_record.Sid = ".$Sid." and Score < 50");
        //  $result = mysql_fetch_array(mysql_query($sql));
            $result = mysql_query($sql);
        
            while($rows = mysql_fetch_array($result)){
           print  $rows['Subject_code']. "<BR>";
           print  $rows['SemName']. "<BR>";
           print  $rows['SemYear']. "<BR>";  
          
          // return $result['Subject_code']."  ".$result['SemName']."  ".$result ['SemYear'];
      } mysql_close($connect);  
       }     } }
       
            $HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
            $server->service($HTTP_RAW_POST_DATA); 
            
    ?>
           
    visual studio code
    
     private void Button_Click(object sender, RoutedEventArgs e)
            { 
              //  Creating new proxy object of our service;
                MyServicePortTypeClient read = new MyServicePortTypeClient();
                read.GetRemainingSubjectCompleted += new EventHandler<GetRemainingSubjectCompletedEventArgs>(read_GetRemainingSubjectCompleted);
             //   Calling method, as a parameters we type text contained in IdTextBox
             //   but we must change text type of string to integer (ID in web service have integer type)
                read.GetRemainingSubjectAsync(Rbox1.Text);
            
            }
    
            void read_GetRemainingSubjectCompleted(object sender, GetRemainingSubjectCompletedEventArgs e)
            {
              //  MessageBox.Show(e.Result);
               libox.Items.Add(e.Result.ToString());
              //  libox(e.Result);
    
            }
    
        }
    Attached Files
Working...