private void Btndaochu_Click(object sender, EventArgs e)
{
string str = "select * from CustomerInfo";
dtInfo = sqlhelper.getTable(str, CommandType.Text);
SaveAS();
}
private void SaveAS()
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "excel文件(*.xls)|*.xls|文本文件(*.txt)|*.txt";
sfd.FilterIndex = 0;
sfd.RestoreDirectory = true;
sfd.CreatePrompt = true;
sfd.Title = "Expot excel file to";
if (sfd.ShowDialog() == DialogResult.OK)
{
openwritemessage(sfd);
}
}
DataTable dtInfo = null;
private void openwritemessage(SaveFileDialog sfd)
{
Stream mystream;
mystream = sfd.OpenFile();
StreamWriter sw = new StreamWriter(mystream, Encoding.Default);
//string str = "";
try //写标题
{
int count = dtInfo.Columns.Count;
string sstr = string.Empty;
for (int i = 0; i < count; i++)
{
if (i > 0)
{
sstr += "\t";
}
sstr += dtInfo.Columns[i].ColumnName;
}
sw.WriteLine(sstr);
for (int j = 0; j < dtInfo.Rows.Count; j++)
{
string tempstr = "";
for (int k = 0; k < count; k++)
{
if (k > 0)
{
tempstr += "\t";
}
tempstr += dtInfo.Rows[j][k].ToString();
}
sw.WriteLine(tempstr);
}
sw.Close();
mystream.Close();
MessageBox.Show("成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sw.Close();
mystream.Close();
}
}