c#数据库对文本文件的导入导出

来源：互联网发布：steam免费mac游戏推荐编辑：程序博客网时间：2024/05/18 04:55

1、数据库查询数据导出到文本文件：

string conStr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
string sqlStr = "select empid,empname,empgender,empage,Department.DepName from Employees as el inner join Department on el.DepId=department.DepId";
using (SqlCommand cmd = new SqlCommand(sqlStr, con))
{
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
using (StreamWriter sw = new StreamWriter("1.txt"))
{
while (dr.Read())
{
sw.Write(dr[0] + "\t");
sw.Write(dr[1] + "\t");
sw.Write(dr[2] + "\t");
sw.Write(dr[3] + "\t");
sw.Write(dr[4] + "\t");
sw.WriteLine();
}
}
}
}
}
}

2、文本文件导入数据库表中

using (StreamReader sr = new StreamReader("1.txt"))
{
string conStr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
string sqlStr = "insert into Test1 values(@id,@name,@gender,@age,@department)";
using (SqlCommand cmd = new SqlCommand(sqlStr, con))
{
SqlParameter[] paras ={
new SqlParameter("@id",SqlDbType.Int),
new SqlParameter("@name",SqlDbType.NVarChar),
new SqlParameter("@gender",SqlDbType.NVarChar),
new SqlParameter("@age",SqlDbType.Int),
new SqlParameter("@department",SqlDbType.NVarChar),
};
cmd.Parameters.AddRange(paras);
con.Open();
while (!sr.EndOfStream)
{
string s = sr.ReadLine();
string[] strs = s.Split(new char[] { '\t' }, StringSplitOptions.RemoveEmptyEntries);
paras[0].Value = strs[0];
paras[1].Value = strs[1];
paras[2].Value = strs[2];
paras[3].Value = strs[3];
paras[4].Value = strs[4];
cmd.ExecuteNonQuery();
}
}
}
}

(文本文件内容如下：

1 刘备男 20 经理部
2 曹操男24 经理部
3 孙权男18 经理部
4 张角男30 临时工
5 貂蝉女17 临时工
6 吕布男20 临时工
7 荀彧男21 魏总部
8 郭嘉男20 魏总部
9 甄姬女19 魏总部

)