using (var client = new SftpClient("Host", 22, "UserName", "Password"))
{
client.Connect();
try
{
var data = File.ReadAllBytes("C:\\test.zip")
using (SftpFileStream sw = client.OpenWrite("/home/test.zip"))
{
sw.Write(data, 0, data.Length);
}
}
catch(Exception ex)
{
throw ex;
}
finally
{
client.Disconnect();
}
}月度归档： 2019年10月
C# .NET DataTable 转 CSV
DataTable 导出 CSV，支持.NET Framework 4.0以上。
public byte[] DataTableToCSV(DataTable data)
{
StringBuilder sb = new StringBuilder();
IEnumerable<string> columnNames = data.Columns.Cast<DataColumn>().
Select(column => column.ColumnName);
sb.AppendLine(string.Join(",", columnNames));
foreach (DataRow row in data.Rows)
{
IEnumerable<string> fields = row.ItemArray.Select(field =>
string.Concat("\"", field.ToString().Replace("\"", "\"\""), "\""));
sb.AppendLine(string.Join(",", fields));
}
return System.Text.Encoding.Default.GetBytes(sb.ToString());
}