SDF文件转换为CSV访问被拒绝

问题描述

我正在尝试制作一个可以将sdf文件中的表转换为csv文件的程序。但不知何故，我不能创建一个csv文件，因为它被拒绝。请忽略评论..

I am trying to make a program which can convert a table out of a sdf file into a csv file. But somehow i cant create a csv file because it is denied. Please ignore the comments..

private void button2_Click(object sender, EventArgs e)
        {

            SqlCeConnection conn = null;
            SqlCeCommand cmd = null;
            SqlCeDataReader rdr = null;


            try
            {
                <code>System.IO.TextWriter stm = new System.IO.StreamWriter(new System.IO.FileStream(@"C:\Users\Name\Desktop\...\...\Columba\Columba-XT-Standard-20180710155851", System.IO.FileMode.Create), Encoding.Default)</code>;
                while (rdr.Read())
                {
                    for (int i = 0; i < rdr.FieldCount - 2; i++)
                    {
                        if (rdr[i] != null)
                        {
                            stm.Write(rdr[i].ToString());
                            stm.Write(";");
                        }
                        else
                        {
                            stm.Write(";");
                        }
                    }
                    if (rdr[rdr.FieldCount - 1] != null)
                    {
                        stm.Write(rdr[0].ToString());
                    }
                    stm.Write(System.Environment.NewLine);
                }
                stm.Close();

                rdr.Close();

                cmd.Dispose();
            }
            finally
            {
                conn.Close();
            }


        }

我的尝试：



我试图在D上创建一个文件夹，但是我没有工作。

然后我试着开始vs管理权限...

What I have tried:

I tried to make a folder on the D, but i did not work.
Then i tried to start vs with admin rights...

推荐答案

System.IO.TextWriter stm = new System.IO.StreamWriter(new System.IO.FileStream(@"D:\\TEST\<code>Data.csv</code>", System.IO.FileMode.Create), Encoding.Default);

这篇关于SDF文件转换为CSV访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！