c#根据MYSQL数据库中的数据拼接进行下载

学习记录，C#根据MYSQL数据库中的数据拼接进行下载

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace mysql连接
{
    class Program
    {
        static void Main(string[] args)
        {
            string connStr = "Database=tupian;Data Source=127.0.0.1;port=3306;User Id=root;Password=root;"; //修改库名及用户名密码
            MySqlConnection conn = new MySqlConnection(connStr);
            conn.Open();  //打开数据库
            MySqlCommand cmd = new MySqlCommand("select * from tupian ", conn);
            MySqlDataReader reader = cmd.ExecuteReader();
            System.Net.WebClient web = new System.Net.WebClient();            

            while (reader.Read())
            {
                string URL = ("http://csdn.net/images/" + (reader.GetString(0)) + ".jpg"); //拼接地址
                string localFilePath = "D:\\下载\\" + (reader.GetString(0)) + ".jpg";   //保存路径               
                System.Net.ServicePointManager.DefaultConnectionLimit = 50;  //并发数50
                web.DownloadFile(URL, localFilePath);
            }
                
            Console.ReadLine();
            conn.Close();         

        }
    }

   

}