string[] TemLine = File.ReadAllLines(TxtDirectoryPath + "\\" + name, Encoding.GetEncoding("GB2312"));//读出数据有1万4千多条左右

                    

                    foreach (string item in TemLine)

                    {

                        

                        try

                        {

                            string[] Item = item.Split('\t');

			    //Item示例:邵小小	24，河南，未婚.

                            string[,] Values ={ 

                                                { "vName", Item[0] },

                                                {"vInfo",Item[1]}

                                              };

                            Add("UserInfo", Values);//执行数据插入操作

                        }

                        catch

                        {

                            ;

                        }

                    }

	//----------------------------------------------------------------------

	//向数据库插入内容

        /// <summary>

        /// 向数据库添加内容

        /// </summary>

        /// <param name="TableName">表名</param>

        /// <param name="ColumnsAndValues">由列名和值组成的二维数组</param>

        public void Add(string TableName, string[,] ColumnsAndValues)

        {

            string Columns = null;

            string Values = null;

            for (int i = 0; i < ColumnsAndValues.GetLength(0); i++)

            {

                Columns = Columns + ColumnsAndValues[i, 0] + ",";

                Values = "\"" + Values + ColumnsAndValues[i, 1] + "\",";

            }

            Columns = Columns.Substring(0, Columns.Length - 1);

            Values = Values.Substring(0, Values.Length - 1);

            string insertStr = "insert into " + TableName + "(" + Columns + ") values(" + Values + ")";

	    //创建Connection对象

            OleDbConnection conn = CreateConnection();

            conn.Open();

            OleDbCommand cmd = new OleDbCommand(insertStr, conn);

            cmd.ExecuteNonQuery();

            cmd.Dispose();

            conn.Close();

            conn.Dispose();

        }