Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i want to return an array to from winrt(c#) so i have two way either through db.execute or db.query... please suggest me what should i do for returning array

C#
public static string getQX(string Squery)
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                var qu = db.Query<NR_FS_FW_TASK_TYPES>(Squery);
                //return resultset in array
            }
        }

C#
public static string getQXn(string Squery)
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                db.Execute(Squery);
                //return resultset in array
            }
        }
Posted
Updated 30-Mar-14 22:01pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900