C#实用方法集合

1.递归取出一个文件夹下的所有指定文件（包括子文件夹）

        public void ListFiles(FileSystemInfo info)
        {
            if (!info.Exists)
            {
                return;
            }
            DirectoryInfo dir = info as DirectoryInfo;
            //不是目录
            if (dir == null)
            {
                return;
            }

            FileSystemInfo[] files = dir.GetFileSystemInfos();
            for (int i = 0; i < files.Length; i++)
            {
                FileInfo file = files[i] as FileInfo;
                //是文件
                if (file != null&&file.Extension.ToLower ()==".xls")
                {
                    FileNameList.Add(file.FullName);
                }
                //对于子目录，进行递归调用
                else
                {
                    ListFiles(files[i]);
                }
            }
        }
2.杀掉EXCEL的进程

private void KillProcess()
        {
            try
            {
                //结束打开的Excel进程
                Process[] process = Process.GetProcessesByName("EXCEL");
                foreach (Process instance in process)
                {
                    instance.Kill();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

3.打开文件夹

   private void Btn_OpenFile_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog folderBrowserDialog1 = new FolderBrowserDialog();
            DialogResult result = folderBrowserDialog1.ShowDialog();

            if (result == DialogResult.OK)
            {
                string folderName = folderBrowserDialog1.SelectedPath;
                if (folderName != "")
                {
                    txtFileName.Text = folderName;
                }
            }
        }

4.判断sql表是否存在

private bool IsTableCreated(string tableName)
        {
            bool re;
            string sql = "select count(name) from sysobjects where name='" + tableName + "'";
            re = Convert.ToInt32 (DBHelper.SqlHelper.ExecuteScalar(sql,CommandType.Text)) > 0 ? true : false;
            return re;
        }