例子:
private void btncsv_ButtonClick(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count <= 0)
{
return;
}
saveFileDialog1.Title = "CSV出力"; saveFileDialog1.DefaultExt = ".csv";
//saveFileDialog1.InitialDirectory = @"c:\";
saveFileDialog1.RestoreDirectory = false; saveFileDialog1.FileName = "";
saveFileDialog1.FileOk += new CancelEventHandler(this.saveFileDialog1_FileOk);
saveFileDialog1.Filter = "CSVファイル(*.CSV)|*.CSV|所有文件(*.*)|*.*";
saveFileDialog1.ShowDialog(this);
} #region saveFileDialog_fileok
private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
string path = saveFileDialog1.FileName;
try
{
if (path != "")
{
StreamWriter strmCsv = new StreamWriter(path, true, System.Text.Encoding.GetEncoding("shift-jis"));
strmCsv.WriteLine("ID,銀行区分,銀行コード,銀行名(漢字),(カナ),支店コード,支店名(漢字),(カナ),口座種別,口座番号,口座名義人(漢字),(カナ),出力フォーマット,表示順");
for (int i = 0; i < dtdata.Rows.Count; i++)
{
string displayData = dtdata.Rows[i]["sysbankinfo_id"]
+ "," + dtdata.Rows[i]["banktype"]
+ "," + dtdata.Rows[i]["bankcode"]
+ "," + dtdata.Rows[i]["bankcname"]
+ "," + dtdata.Rows[i]["bankaname"]
+ "," + dtdata.Rows[i]["cbankcode"]
+ "," + dtdata.Rows[i]["cbankcname"]
+ "," + dtdata.Rows[i]["cbankaname"]
+ "," + dtdata.Rows[i]["accounttype"]
+ "," + dtdata.Rows[i]["accountno"]
+ "," + dtdata.Rows[i]["accountcname"]
+ "," + dtdata.Rows[i]["accountaname"]
+ "," + dtdata.Rows[i]["outtype"]
+ "," + dtdata.Rows[i]["orderby"];
strmCsv.WriteLine(displayData);
}
strmCsv.Close();
}
}
catch (IOException ev)
{
MessageBox.Show(this, ev.Message);
return;
}
finally
{
saveFileDialog1.FileName = "";
path = "";
}
}
private void btncsv_ButtonClick(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count <= 0)
{
return;
}
saveFileDialog1.Title = "CSV出力"; saveFileDialog1.DefaultExt = ".csv";
//saveFileDialog1.InitialDirectory = @"c:\";
saveFileDialog1.RestoreDirectory = false; saveFileDialog1.FileName = "";
saveFileDialog1.FileOk += new CancelEventHandler(this.saveFileDialog1_FileOk);
saveFileDialog1.Filter = "CSVファイル(*.CSV)|*.CSV|所有文件(*.*)|*.*";
saveFileDialog1.ShowDialog(this);
} #region saveFileDialog_fileok
private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
string path = saveFileDialog1.FileName;
try
{
if (path != "")
{
StreamWriter strmCsv = new StreamWriter(path, true, System.Text.Encoding.GetEncoding("shift-jis"));
strmCsv.WriteLine("ID,銀行区分,銀行コード,銀行名(漢字),(カナ),支店コード,支店名(漢字),(カナ),口座種別,口座番号,口座名義人(漢字),(カナ),出力フォーマット,表示順");
for (int i = 0; i < dtdata.Rows.Count; i++)
{
string displayData = dtdata.Rows[i]["sysbankinfo_id"]
+ "," + dtdata.Rows[i]["banktype"]
+ "," + dtdata.Rows[i]["bankcode"]
+ "," + dtdata.Rows[i]["bankcname"]
+ "," + dtdata.Rows[i]["bankaname"]
+ "," + dtdata.Rows[i]["cbankcode"]
+ "," + dtdata.Rows[i]["cbankcname"]
+ "," + dtdata.Rows[i]["cbankaname"]
+ "," + dtdata.Rows[i]["accounttype"]
+ "," + dtdata.Rows[i]["accountno"]
+ "," + dtdata.Rows[i]["accountcname"]
+ "," + dtdata.Rows[i]["accountaname"]
+ "," + dtdata.Rows[i]["outtype"]
+ "," + dtdata.Rows[i]["orderby"];
strmCsv.WriteLine(displayData);
}
strmCsv.Close();
}
}
catch (IOException ev)
{
MessageBox.Show(this, ev.Message);
return;
}
finally
{
saveFileDialog1.FileName = "";
path = "";
}
}
解决方案 »
- 列名 'InDate' 无效。 求高手 谢谢
- 緊急求助一個web鐘錶
- 如和在List<object>对象的第一个位置添加一个对象?
- c#打印错位
- 请问datagridview如何实现combobox
- 這個為什麼報錯。
- 如何把table中的数据全部提交到数据库中?
- 像"Nhiberate"这些框架的实体绑定到dataGrid,它们在后台怎么样绑定到datagrid的记录那些是新增的、修改的、删除的
- 如何让ListView显示水平滚动条
- 我想把sqlserver里的一个table数据,取道access里,要用dataset来做,有什么简单的方法,
- 有人熟悉mutli-scale的图像分割吗?
- 关于DataTable复制数据
应该是用streamReader(Stream)读出来,再写入.
FileStream fs = new FileStream("22.txt",FileMode.OpenOrCreate,FileAccess.Write);
StreamWriter writer = new StreamWriter(fs);