关于文件遍历和写入数据库的问题

Question

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.OleDb;
using System.Data.SqlClient;namespace files
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }        private void button1_Click(object sender, EventArgs e)
        {
                       displayItems(textBox1.Text);
        //MessageBox.Show(dirs.Length.ToString()); 
           
        }        private void displayItems(string path)
        {
            try
            {
                DirectoryInfo di = new DirectoryInfo(path);
                FileInfo[] SubFiles = di.GetFiles();                FileSystemInfo[] dirs = di.GetDirectories();                foreach (FileInfo fileNext in SubFiles)
                {
                   
                  
                    string path_total = path + "/" + fileNext.ToString();
                    int path_start = path_total.IndexOf("/") + 1;
                    int path_end = path_total.LastIndexOf("/");
                    string path_name;
                    if (path_start - 1 == path_end)
                    {
                        path_name = "";
                    }
                    else
                    {
                        path_name = path.Substring(path_start, path_end - path_start);
                    }
                    switch (path_start.ToString())
                    {
                        case "....":
                            break;
                    }
/*--------------------------------------------------------------------------------*/
//下面这段代码好象没有起到作用。
                    string Afile = "Provider=SQLOLEDB;DataSourse=192.168.0.254;InitialCatalog=files;uid=sa;pasword=;";
                    OleDbConnection AconnStr = new OleDbConnection(Afile);
                    string sql ="insert into pic_data(pic_name,pic_path,pic_time) values('"+fileNext.ToString()+"','"+path_name+"','"+DateTime.Now.ToString()+"')";
                      OleDbCommand Cmd = new OleDbCommand(sql);
                      
                      //if (checkBox1.Checked == true)
                         // Cmd.ExecuteNonQuery();
                    /*--------------------------------------------------------*/
                    listBox1.Text = listBox1.Text + "\r\n" + path + "\\" + fileNext.ToString(); 
                    richTextBox1.Text = richTextBox1.Text + "\r\n" + path + "\\" + fileNext.ToString();                   
                    
                }
                foreach (DirectoryInfo diNext in dirs)
                {
                    displayItems(path + "/" + diNext.ToString());
                }
            }
            catch (Exception ex)
            {
                richTextBox1.Text = ex.Message + "\r\n" + richTextBox1.Text;
            }
        } 
    }
}
/*--------------------------------------------------------
以上这段代码的数据库操作没有作用。根本没有向数据库里面写入任何文件。
希望各位大虾帮忙指点一下。

Answer 1

OleDbConnection AconnStr = new OleDbConnection(Afile);AconnStr.Open();//连接忘记打开了