using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Net;
using System.IO;
using System.Web;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
string _connect = " connection string";
SqlConnection _db = new SqlConnection(_connect);
_db.Open();
string sql1 = " sql expression ";
SqlCommand cmd = new SqlCommand(sql1,_db);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
_db.Close();
foreach (DataRow dd in dt.Rows)
{
string usrid = dd["userid"].ToString();
string url = dd["current_url"].ToString();
// utf-8 & GB2312
string decodeUrl = HttpUtility.UrlDecode(url, Encoding.GetEncoding("GB2312"));
string _connect1 = " connection string2";
Console.WriteLine(decodeUrl);
SqlConnection _db2 = new SqlConnection(_connect1);
_db2.Open();
string _insert = "sql expression2";
SqlCommand cmd2 = new SqlCommand(_insert, _db2);
cmd2.Parameters.Add("@userid", dd["userid"]);
cmd2.Parameters.Add("@current_url", decodeUrl);
cmd2.ExecuteNonQuery();
_db2.Close();
}
}
}
}