You can try the following code to get the value from the json txt and transfer it to the sql server table.
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
class Program
{
static void Main(string[] args)
{
string json = File.ReadAllText("D:\\test1.txt");
List<Example> list = JsonConvert.DeserializeObject<List<Example>>(json);
string strcon = @"Connstr";
SqlConnection connection = new SqlConnection(strcon);
connection.Open();
string sql = "Insert into JsonData(orderId,consignmentNumber,itemNumbers,country,orderType,paymentTransactionId,priceInOre,paidAt,orderNumber,articleName) values(@orderId,@consignmentNumber,@itemNumbers,@country,@orderType,@paymentTransactionId,@priceInOre,@paidAt,@orderNumber,@articleName)";
SqlCommand command = new SqlCommand(sql, connection);
foreach (Example item in list)
{
command.Parameters.AddWithValue("@orderId", item.orderId);
command.Parameters.AddWithValue("@consignmentNumber", item.consignmentNumber);
command.Parameters.AddWithValue("@itemNumbers", item.itemNumbers.First());
command.Parameters.AddWithValue("@country", item.country);
command.Parameters.AddWithValue("@orderType", item.orderType);
command.Parameters.AddWithValue("@paidAt", item.paidAt);
command.Parameters.AddWithValue("@paymentTransactionId", item.paymentTransactionId);
command.Parameters.AddWithValue("@priceInOre", item.priceInOre);
command.Parameters.AddWithValue("@articleName", item.articleName);
command.Parameters.AddWithValue("@orderNumber", item.orderNumber);
}
command.ExecuteNonQuery();
connection.Close();
}
}
public class Example
{
public int orderId { get; set; }
public string consignmentNumber { get; set; }
public List<string> itemNumbers { get; set; }
public string country { get; set; }
public string orderType { get; set; }
public string paymentTransactionId { get; set; }
public int priceInOre { get; set; }
public string paidAt { get; set; }
public string orderNumber { get; set; }
public string articleName { get; set; }
}
Final result:
Edit:
var json = new WebClient().DownloadString("URL");
