winform 将数据库的信息导出到txt文本或excel中

来源：互联网发布：问道钓鱼软件编辑：程序博客网时间：2024/05/29 16:09

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

}