Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using Newtonsoft.Json;
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.IO;
- using System.Linq;
- using System.Net;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace WindowsFormsApp15
- {
- public partial class Form1 : Form
- {
- public class JsonResult
- {
- public int id { get; set; }
- public string name { get; set; }
- }
- public Form1()
- {
- InitializeComponent();
- string html = string.Empty;
- string url = @"http://localhost:8080/users";
- HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
- request.AutomaticDecompression = DecompressionMethods.GZip;
- using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
- using (Stream stream = response.GetResponseStream())
- using (StreamReader reader = new StreamReader(stream))
- {
- html = reader.ReadToEnd();
- }
- //Console.WriteLine(html);
- label1.Text = html;
- var result = JsonConvert.DeserializeObject<List<JsonResult>>(html);
- dataGridView1.DataSource = result;
- }
- private void label1_Click(object sender, EventArgs e)
- {
- }
- }
- }
- var mysql = require('mysql');
- var express = require('express')
- var app = express()
- var con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "experiment"
- });
- /*
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- });
- */
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- con.query("SELECT * FROM users", function (err, result) {
- if (err) throw err;
- console.log("Result: " + result);
- var len = result.length;
- for ( var i = 0; i < len; i++ ){
- console.log(result[i].name)
- }
- app.get('/', function (req, res) {
- res.send('hello world')
- })
- app.get('/users', function (req, res) {
- //res.write('connected!\n');
- /*
- for ( var i = 0; i < len; i++ ){
- res.write(result[i].name + '\n')
- }
- */
- //https://www.nuget.org/packages/Newtonsoft.Json/6.0.3
- res.setHeader('Content-Type', 'application/json');
- res.write(JSON.stringify(result))
- res.end()
- })
- /*
- http.createServer(function (req, res) {
- res.writeHead(200, {'Content-Type': 'text/plain'});
- res.write('connected!\n');
- for ( var i = 0; i < len; i++ ){
- res.write(result[i].name + '\n')
- }
- res.end();
- }).listen(8080);
- */
- app.listen(8080, () => console.log(`Example app listening on port ${8080}!`))
- //con.end()
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement