public static string[,] GetValues() { string[,] array = new string[10, 10]; string[] FieldsArr = { "Firstname", "Secondname", "Thirdname", "Email", "Phone", "Age", "Region", "College", "CollegeProfession", "Course" }; for (int i = 0; i < 10; i++) { for (int s = 0; s < FieldsArr.Length; s++) { string bufstr = DatabaseLogicClass.SQLiteGet("SELECT " + FieldsArr[s] + " from users WHERE id=" + (i + 1).ToString()); if (bufstr == "") { break; } array[i, s] = bufstr; } } return(array); }
public static void AddValues(string FirstNameString, string SecondNameString, string ThirdNameString, string EmailString, string PhoneString, string AgeString, string RegionString, string CollegeString, string CollegeProfession, string CollegeCourse) { DatabaseLogicClass.SQLiteExecute("INSERT INTO users(Firstname, Secondname, Thirdname, Email, Phone, Age, Region, College, CollegeProfession, Course) VALUES ('" + FirstNameString + "','" + SecondNameString + "','" + ThirdNameString + "','" + EmailString + "','" + PhoneString + "','" + AgeString + "','" + RegionString + "','" + CollegeString + "','" + CollegeProfession + "','" + CollegeCourse + "');"); }