将选择内容从DataGrid导出到.csv
问题描述:
更具体的问题:导出数据库(.mdb / .accdb)到.csv
More specific asked question: Export DataBase (.mdb / .accdb) to .csv
我是Data Grid的新用户,需要导出已标记(选定)的特定行。
Im new to Data Grid and Need to Export specific lines that are marked (selected).
我找不到只导出所选字段的简单方法。
I cant find a easy way to Export only the selected fields.
现在没有选择的代码:
StringBuilder sb = new StringBuilder();
IEnumerable<string> columnNames = DataSet_DB.Tables[0].Columns.Cast<DataColumn>().
sb.AppendLine(string.Join(";", columnNames));
foreach (DataRow row in DataSet_DB.Tables[0].Columns)
{
IEnumerable<string> fields = row.ItemArray.Select(field => field.ToString());
sb.AppendLine(string.Join(";", fields));
}
File.WriteAllText(SFD.FileName, sb.ToString());
答
您可以使用DataGridView.SelectedRows获取选定的行采集。如果您的DataGridView只允许选择一个,请看一下我的示例。
You can get the selected row using the DataGridView.SelectedRows Collection. If your DataGridView allows only one selected, have a look at my sample.
DataGridView.SelectedRows获取由$ b选择的行的集合。 $ b用户。
DataGridView.SelectedRows Gets the collection of rows selected by the user.
示例
if (dataGridView1.SelectedRows.Count != 0)
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
row.Cells["ColumnName"].Value
}
更多信息: