示例#1
0
        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();
        }