Esempio n. 1
0
        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);
        }
Esempio n. 2
0
 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 + "');");
 }