public static string fUtilityPutDataTable(string handle, object[,] data) { PersistentObjects.AssertReservedWordsTableName(handle); PersistentObjects.AddToMap(handle, ExcelFriendlyConversion.ConvertObjectArrayToDataTable(handle, data), "DATATABLE"); return(handle); }
public static object[,] fUtilityTableSortByHeader(object[,] table, object[] headers, object SortAscending, object noHeadersInput) { bool ascending = Optional.Check(SortAscending, true); bool noHeaders = Optional.Check(noHeadersInput, false); var dataTable = ExcelFriendlyConversion.ConvertObjectArrayToDataTable("TEMPTABLE", table); var header = ""; for (int i = 0; i < headers.Length - 1; i++) { header = headers[i].ToString() + ", " + header; } header = header + headers[headers.Length - 1]; var direction = (ascending) ? "ASC" : "DESC"; dataTable.DefaultView.Sort = header + " " + direction; return(ExcelFriendlyConversion.ConvertDataTableToObjectArray(dataTable.DefaultView.ToTable())); }
static void TestSQLite() { var table = CreateTestTable(); SQLiteDatabase db = new SQLiteDatabase("MYDB"); db.CreateTable("MYTABLE", table); var table2 = db.InspectDatabase(); var table3 = db.GetDataTable("MYTABLE"); var obj = CreateTestArray(); var table4 = ExcelFriendlyConversion.ConvertObjectArrayToDataTable("MYTABLE4", obj); PrintTableInfoToConsole(table4); db.CreateTable("MYTABLE4", table4); var table5 = db.GetDataTable("MYTABLE4"); PrintTableInfoToConsole(table5); Console.WriteLine("Database created .."); }