我想用:(saveFileDialog.Title =this.tyuef()+"月水费";)saveFileDialog.Title这个变量也作为文件,当打开导出对话框的时候,文件名也自动为saveFileDialog.Title ,如何可以实现呢,谢谢!!!
private void SaveAs() //另存新档按钮 导出成Excel
{ SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Execl files (*.xls)|*.xls"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.Title =this.tyuef()+"月水费";
saveFileDialog.ShowDialog();
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)//如果选择提醒导出
return; Stream myStream; myStream = saveFileDialog.OpenFile(); //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312")); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); string str = ""; try
{ //写标题 for (int i = 0; i < dataGridView1.ColumnCount; i++)
{ if (i > 0)
{ str += "\t"; } str += dataGridView1.Columns[i].HeaderText; }
sw.WriteLine(str); //写内容 for (int j = 0; j < dataGridView1.Rows.Count; j++)
{ string tempStr = ""; for (int k = 0; k < dataGridView1.Columns.Count; k++)
{ if (k > 0)
{ tempStr += "\t"; } tempStr += dataGridView1.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempStr); } sw.Close(); myStream.Close(); } catch (Exception e)
{ MessageBox.Show(e.ToString()); } finally
{ sw.Close(); myStream.Close(); } }
private void SaveAs() //另存新档按钮 导出成Excel
{ SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Execl files (*.xls)|*.xls"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.Title =this.tyuef()+"月水费";
saveFileDialog.ShowDialog();
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)//如果选择提醒导出
return; Stream myStream; myStream = saveFileDialog.OpenFile(); //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312")); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); string str = ""; try
{ //写标题 for (int i = 0; i < dataGridView1.ColumnCount; i++)
{ if (i > 0)
{ str += "\t"; } str += dataGridView1.Columns[i].HeaderText; }
sw.WriteLine(str); //写内容 for (int j = 0; j < dataGridView1.Rows.Count; j++)
{ string tempStr = ""; for (int k = 0; k < dataGridView1.Columns.Count; k++)
{ if (k > 0)
{ tempStr += "\t"; } tempStr += dataGridView1.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempStr); } sw.Close(); myStream.Close(); } catch (Exception e)
{ MessageBox.Show(e.ToString()); } finally
{ sw.Close(); myStream.Close(); } }
解决方案 »
- 正则表达式
- C#.net中月份控件问题
- 请教关于System.Reflection.Assembly类
- "用于监视的文件名无效,用于监视的文件名必须具有绝对路径,并且不包含通配符"这种错误怎么解决?
- 词条的存储方式
- 一个在DataList中删除记录的问题,已经两天了!!!!!!!!!郁闷,哪位好心人帮帮我!!!!!!!!
- xml不显示
- 从datagridcolumnstyle中派生出新类。。。
- 在循环中想控制循环中每一次运行停留10秒,怎么控制
- C#哪一个类是用于发E_mail,最好给一个例子,非常感谢,给分
- 递归调用造成堆栈溢出,该如何解决??
- SqlDatAadapter中insertcommand批量插入数据不成功
saveFileDialog.Title =this.tyuef()+"月水费";
saveFileDialog.FileName=this.tyuef()+"月水费"; saveFileDialog.ShowDialog(); //多余
if (saveFileDialog.ShowDialog() == DialogResult.Cancel)//如果选择提醒导出
return;