HYTOS

            LMADataSource dataSource = new LMADataSource();

            LMDrawings drawings = new LMDrawings();

                Project_Info _ProjectInfo = Project_Info.GetInstance();

                _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

                if (Project_DB.ConnTestAndCreateTable())

                {

                    drawings.Collect(dataSource);

                    List<string> drawingNameList = new List<string>();

                    List<string> drawingNumberList = new List<string>();

                    DataTable drawingTable = Project_DB.SelectDrawingInfo();

                    foreach (LMDrawing item in drawings)

                    {

                        drawingNameList.Add(item.Attributes["Name"].get_Value().ToString());

                        drawingNumberList.Add(item.Attributes["DrawingNumber"].get_Value().ToString());

                    }

                }

                else

                {

                    MessageBox.Show(Msg.ConnectionFail, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                }

            finally

            {

                ReleaseCOMObjects(dataSource);

                ReleaseCOMObjects(drawings);

            }

        public void ReleaseCOMObjects(params object[] objVars)

        {

            int intNewRefCount = 0;

            foreach (object obj in objVars)

            {

                if (!Information.IsNothing(obj) && System.Runtime.InteropServices.Marshal.IsComObject(obj))

                    intNewRefCount = intNewRefCount + System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj);

            }

        }

        public static DataTable SelectDrawingInfo()

        {

            DataTable dt = new DataTable();

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                try

                {

                    connection.Open();

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = string.Format("SELECT * FROM {0}",SPPID_DRAWING_INFO);

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                    }

                    connection.Close();

                }

                catch (Exception ex)

                {

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return dt;

        }