有一个问题,假设有一个表,3个字段,temp1,temp2,temp3 3个字段下有数据,需要把这个数据导出为txt,我需要在导出的时候,在每个字段后有一个逗号,例如:temp1 temp2 temp3
aaaaa bbbbb ccccc
ddddd eeeee fffff
导出后即为:aaaaa,bbbbb,ccccc,ddddd,eeeee,fffff请教怎么做?
aaaaa bbbbb ccccc
ddddd eeeee fffff
导出后即为:aaaaa,bbbbb,ccccc,ddddd,eeeee,fffff请教怎么做?
while(dr.Read())
{
File.WriteAllText("",dr["temp1"].ToString()+","+dr["temp2"].ToString());
}
set @output = ''
select @output = @output + ',' + temp1 + ',' + temp2 + ',' + temp3 from 表
set @output = substring(2, len(@output) - 1)
select @output
StringBuilder sb = new StringBuilder();
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["mainConnStr"].ConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand(sql, conn))
{
conn.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
for (int i = 0; i < sdr.FieldCount; i++)
{
sb.AppendFormat("{0},", sdr[i].ToString());
}
}
}
}
}
sb.Length--;
//sb就是你想要的