（c#）把数据库表格导出为TXT

在Form1中添加一个saveFileDialog

然后在一个导出的按钮中单击事件

private void btExport_Click(object sender, EventArgs e)
        {
            try
            {
                saveFileDialog1.ShowDialog();
                saveFileDialog1.Filter = "txt files(*.txt)|*.txt";
                if (saveFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    //command
                    string sdir = "select * from Table_test";

                    //stringconnect
                    string sconnection = "Data Source=. //SQLEXPRESS;Initial Catalog=Testabc;Integrated Security=true";
                    //create dataset
                    DataSet dsMydataset = new DataSet();
                    //link DataBase
                    SqlConnection sqlcon = new SqlConnection(sconnection);

                    //create sqldataadapter
                    SqlDataAdapter sdaExport = new SqlDataAdapter(sdir, sqlcon);
                    sdaExport.Fill(dsMydataset);

                    //
                    //get rows of the data
                    Int32 irows = dsMydataset.Tables[0].Rows.Count;
                    //give every row recode to every rows of txt
                    string[] stxt = new string[irows];
                    for (Int32 itest = 0; itest < irows; itest++)
                    {
                        DataRow drMydr = dsMydataset.Tables[0].Rows[itest];
                        //get Items from every row
                        for (Int32 iItem = 0; iItem < drMydr.ItemArray.Length; iItem++)
                        {
                            stxt[itest] += drMydr.ItemArray[iItem].ToString();
                            stxt[itest] += "/t";
                        }
                        stxt[itest] += "/n";
                    }
                    string filename = saveFileDialog1.FileName;
                    //
                    FileStream fs = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Write);
                    StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("GB2312"));//通过指定字符编码方式可以实现对汉字的支持，否则在用记 事本打开查看会出现乱码
                    sw.Flush();
                    sw.BaseStream.Seek(0, SeekOrigin.Begin);
                    string ts = "id" + "/t" + "/t" + "name" + "/t" + "sex" + "/t";
                    sw.WriteLine(ts);
                    for (int i = 0; i < irows; i++)
                    {
                        sw.WriteLine(stxt[i]);

                    }
                    sw.Flush();
                    sw.Close();
                    sqlcon.Close();
                }
            }
            catch (SqlException sqle)
            {
                MessageBox.Show(sqle.Message, "notice");
            }
        }