using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.IO;
namespace _02导出数据
{
class Program
{
static void Main(string[] args)
{
string str = "Data Source=XY-PC;Initial Catalog=MyItcast;Integrated Security=True";
using (SqlConnection con=new SqlConnection(str))
{
string sql = "select UserId, UserName, UserPwd from UserLogin";
using (SqlCommand cmd=new SqlCommand(sql,con))
{
con.Open();
using (SqlDataReader reader=cmd.ExecuteReader())
{
if (reader.HasRows)
{
using (StreamWriter sw=new StreamWriter("1.txt"))
{
sw.WriteLine("{0},{1},{2}", reader.GetName(0), reader.GetName(1), reader.GetName(2));//获取指定列的名称,参数是下标,只写一次,因此放在循环外面
while (reader.Read())
{
sw.WriteLine("{0},{1},{2}",reader[0],reader[1],reader[2]);//获取指定列的value,参数是下标
}// end while
}//end using
}// end if
}// end using
}//end using
}// end using
Console.WriteLine("我要用计算机控制挖掘机炒菜");
Console.ReadKey();
}
}
}
SQL导出数据到TXT
最新推荐文章于 2024-06-08 23:11:47 发布