string ConStr = "Data Source=……;database=……;uid=……;pwd=……;";
SqlConnection con = new SqlConnection(ConStr);
SqlCommand cmd = new SqlCommand("", con);
cmd.CommandText = "SELECT city,jc FROM CityConfig WITH(NOLOCK)";
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
string m = "";
while (dr.Read())
{
m += dr.GetValue(0).ToString() + "," + dr.GetValue(1).ToString()+"\r\n";
}
con.Close();
FileStream fs1 = new FileStream("E:\\SqlTxt.txt", FileMode.Create, FileAccess.Write);//创建写入文件
StreamWriter sw = new StreamWriter(fs1);
sw.WriteLine(m);//开始写入值
sw.Close();
fs1.Close();
读取SQL生成txt文件
最新推荐文章于 2023-03-27 15:26:55 发布