C# sqlite 查询数据库表中所有字段

  public bool ReadTableFields(string strTableName,out List<string> strFieldNames)
         {
            // 获取表中的所有字段名
            string sqlfieldName = "Pragma Table_Info(" + strTableName + ")";
            // 创建命令对象
            SQLiteCommand cmd = new SQLiteCommand(sqlfieldName, dbConnection);
            List<string> tmpCols = new List<string>();
            try
            {
                using (SQLiteDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        tmpCols.Add(dr["Name"].ToString());
                    }

                }
                strFieldNames = tmpCols;
                return true;
            }
            catch(Exception e)
            {
                strFieldNames = tmpCols;
                return false;
            }
         }