public void UpdateUser(string[] info)
        {
            SqlConnection sqlconn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\AndrewLaptop\\Documents\\Visual Studio 2010\\Projects\\AccountManagement\\DatabaseService\\App_Data\\UserDatabase.mdf;Integrated Security=True;User Instance=True");
            sqlconn.Open();
            SqlCommand sqlcomm = new SqlCommand("UPDATE SET Username=@iUsername, Password=@iPassword, Email=@iemail, State=@istate, Postcode=@ipostcode, Title=@ititle, FirstName=@ifirstName, LastName=@ilastName, HomeAddress=@ihomeAddress, WHERE username=@iUsername", sqlconn);
            sqlcomm.Parameters.Add(new SqlParameter("@iUsername", SqlDbType.NChar)).Value = info[0];
            sqlcomm.Parameters.Add(new SqlParameter("@iPassword", SqlDbType.NChar)).Value = info[1];
            sqlcomm.Parameters.Add(new SqlParameter("@iemail", SqlDbType.NChar)).Value = info[2];
            sqlcomm.Parameters.Add(new SqlParameter("@istate", SqlDbType.NChar)).Value = info[3];
            sqlcomm.Parameters.Add(new SqlParameter("@ipostcode", SqlDbType.NChar)).Value = info[4];
            sqlcomm.Parameters.Add(new SqlParameter("@ititle", SqlDbType.NChar)).Value = info[5];
            sqlcomm.Parameters.Add(new SqlParameter("@ifirstName", SqlDbType.NChar)).Value = info[6];
            sqlcomm.Parameters.Add(new SqlParameter("@ilastName", SqlDbType.NChar)).Value = info[7];
            sqlcomm.Parameters.Add(new SqlParameter("@ihomeAddress", SqlDbType.NChar)).Value = info[8];
            sqlcomm.ExecuteNonQuery();
            sqlconn.Close();
        }