public void exportarcsv() { DataTable dt = new DataTable(); dt = BPedidosCompra.PedidoCompra_Lista(); var lines = new List <string>(); string[] columnNames = dt.Columns .Cast <DataColumn>() .Select(column => column.ColumnName) .ToArray(); var header = string.Join(",", columnNames.Select(name => $"\"{name}\"")); lines.Add(header); var valueLines = dt.AsEnumerable() .Select(row => string.Join(",", row.ItemArray.Select(val => $"\"{val}\""))); lines.AddRange(valueLines); File.WriteAllLines("excel.csv", lines); Process.Start("excel.csv"); }
public void Pedidos() { dgvRegistros.DataSource = BPedidosCompra.PedidoCompra_Lista(); dgvRegistros.Columns["id"].HeaderText = "Número"; dgvRegistros.Columns["delete"].DisplayIndex = 5; }