After getting data through api, how to post in sql using c#

Vikas

I have C# Console Application where I'm getting data from google-news-api and after that I want to post whole data to my sql server. So how is it possible

namespace ConsoleApp {
class Program {
static void Main(string[] args) {
SqlConnection conn = new SqlConnection(@ "Server=SQLEXPRESS;Initial Catalog=testingnews;User Id=abctesting;Password=sabc;");
conn.Open();
SqlCommand cmd = new SqlCommand("insert into newstbl values ('50AE4E66-07C0-4AB0-936B-2778AFCB9787', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', 1, 0, '')", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
Console.WriteLine("{0},{1}", reader.GetString(0), reader.GetString(1));
Console.ReadLine();
}
reader.Close();
conn.Close();
try {
GetNewsDetails().Wait();
} catch (Exception ex) {}
}
public static async Task < string > GetNewsDetails() {
using(var _http = new HttpClient()) {
_http.BaseAddress = new Uri("https://newsapi.org/v2/");
_http.DefaultRequestHeaders.Clear();
_http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = await _http.GetAsync("everything?sources=&q=bbc-news&sortBy=publishedAt&pageSize=80&apiKey=4dbc17e007ab436fb66416009dfb59a8");
response.EnsureSuccessStatusCode();
using(HttpContent content = response.Content) {
string responseBody = await content.ReadAsStringAsync();
Console.WriteLine(responseBody); // In responseBody I'm getting multiple data
Console.ReadLine();
}
}
return "objNewsRoot";
}
}
}

as per my logic some changes in line no 6 so please help me how to post array type data.

3 Replies

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

Vikas6y ago
Hi Sreekanth,
here is my responsebody data
Vishvjit Shinde6y ago
Hi,
Check what response is coming. and based on the response
Two ways you can do it:

In the line no 06 Do mention table column also when inserting like this:
insert into newstbl (Column1,Column2....) values('','',....)
Secondly:
Create a model Class like this
public class class_Name
{
public dataType FiledName1{get;set;}
public dataType FiledName2{get;set;}
public dataType FiledName3{get;set;}
public dataType FiledName4{get;set;}
.
.
.
.
}
take the values in modal Class and loop it
Sreekanth Reddy6y ago
Can you post your responsebody data ?

Actually, Based on your response the columns should be created in your table.
First create a table, And create columns in the table based on the response key values. Loop the response value and fetch into variables and save.

If you show your response we can try to make clear the solution.

If it helps, Mark as answer. Thank you.