How to get data from web service and store in table

Question

http://xml.flightview.com/fvDemoConsOOOI/fvxml.exe?a=fvxmldemoSoo1&b=thrk$dhxxxxx&depap=CCU&depdate=xxxxx&dephr=xxx[^] What I have tried: I Have Url of Web Service and i want to Get Data in Database Table using MVC or Asp .Net so Please Give Me Code How to Store in a table

Sreekanth Reddy · Answer

GetStudent() is the the method which sends the list of students by connecting to database. public list GetStudents() { //Connection to databse and fetch the list of students. return lststu; } Thank you.

Mukesh · Answer

Please write a Code what is GetStudent()

Sreekanth Reddy · Answer

You needs create the list type that what the service is returning. For Example if your service is returning list of student. Then you needs to create the class of "Student with same properties" Then after you need to create the service reference. By using the service reference you can point the particular method. var a = yourservicereference.GetStudents(); now "a" contains the list of students means like List . Or else you can directly give as like below : List lststu = yourservicereference.GetStudents(); Now your data will be with lststu. To store within table in backend you can do 2 ways : 1) loop the "lststu" and insert 1 by 1 into database for(int i=0;i { lststu[i].... //Code to insert data. } 2)create a DataTable from the lststu and send dt directly. For creation and consumption ofweb service follow the below URL Mark as answer, If it helps. https://www.c-sharpcorner.com/UploadFile/4d9083/sending-list-from-webservice-and-consume-it-in-application/ Thank you.