protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.Main); FontFunction font = new FontFunction(); UserTableDB User = new UserTableDB(this); CheckIfDBExist(); NextPage(User.Count() == 0); }
/// <summary> /// Initialises UserDataTable /// Pulls Data from the database and generates columns and rows to match the said data /// and inputs that dta afterwards /// </summary> /// <param name="context">Allows it to know which activity it is calling it from</param> /// <param name="Name">Used to Determine which spreadsheet is to be openned</param> public UserDataTable(Context context, String Name) : base(Name) { UserTableDB userTabledb = new UserTableDB(context); string userName = "******"; string passWord = "******"; var dataColumns = new Dictionary <string, float>(); dataColumns.Add(" " + userName, 150); dataColumns.Add(passWord, 150); foreach (var key in dataColumns.Keys) { var dc = new DSDataColumn(key); dc.Caption = key; dc.ReadOnly = true; dc.DataType = typeof(string); dc.AllowSort = true; dc.Width = dataColumns[key]; Columns.Add(dc); } List <string> UserNameList = userTabledb.readString(userName); List <string> PassWordList = userTabledb.readString(passWord); int row = userTabledb.Count(); for (int i = 0; i < row; i += 1) { var dataRows = new DSDataRow(); dataRows[" " + userName] = " " + UserNameList[i]; dataRows[passWord] = PassWordList[i]; Rows.Add(dataRows); } }