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;
}
