Azavea.NijPredictivePolicing.Test.Common.DB.SpatialiteTests.queryDB C# (CSharp) Method

queryDB() public static method

public static queryDB ( SQLiteConnection conn, string sql ) : DataTable
conn System.Data.SQLite.SQLiteConnection
sql string
return System.Data.DataTable
        public static DataTable queryDB(SQLiteConnection conn, string sql)
        {
            SQLiteCommand cmd = conn.CreateCommand();
            cmd.CommandText = sql;

            DataTable dt = new DataTable("results");
            SQLiteDataAdapter sda = new SQLiteDataAdapter(cmd);
            sda.Fill(dt);
            return dt;
        }