i have a table in a remote database would want to get data from that remote computer and insert it into my database
how best can i do that the remote table has the following fields
Account, Name, class, stream, balance
Account |
Name |
Class |
Stream |
Balance |
05-00001 |
JOHN PAUL |
P1 |
S |
5000 |
05-00002 |
SULAIMAN |
P2 |
D |
10000 |
05-00003 |
JOWERIA MUKISA |
P3 |
A |
40000 |
i wanted something similar to this below but my problem is, I am using asp.net project.
how can i have it implemented because i would want to get the json data on my pc.
public class HomeController : Controller
{
public IActionResult Index()
{
//Fetch the JSON string from URL.
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string json = (new WebClient()).DownloadString("https://raw.githubusercontent.com/aspsnippets/test/master/Customers.json");
//Return the JSON string.
return Content(json);
}
}