public void LoadData() { DataTable dt = new DataTable(); string persons = "SELECT * FROM PersonTest ORDER BY Id"; using (var connection = new SqlConnection(connectionString)) { connection.Open(); SqlDataAdapter sqlData = new SqlDataAdapter(persons, connection); sqlData.Fill(dt); } PhoneBook.DataSource = dt; PhoneBook.DataBind(); }