Loading

How to get data from web service and store in table

How to get data from web service and store in table

Mukesh

Mukesh

7y854Learn iOS Programming

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
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.
Mukesh7y ago
Please write a Code what is GetStudent()
Sreekanth Reddy7y ago
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.