Đang chuẩn bị liên kết để tải về tài liệu:
Beginning Microsoft Visual Basic 2008 phần 8

và như vậy. Nếu bạn đang xây dựng giao diện người dùng cho điều khiển của riêng bạn, nó là hợp lý để giả định rằng từ thời gian bạn sẽ cần phải biết những gì các màu sắc để điều khiển của bạn có cái nhìn và cảm thấy như các điều khiển hiện có trong hệ thống. Màu sắc của hệ thống được tiếp xúc. | Chapter 17 Database Programming with SQL Server and ADO.NET Figure 17-14 4. Change the Data Source to Microsoft SQL Server SqlClient . Put in your server name. Choose the type of authentication and user information to login to your database server. For database name enter pubs. Click the Test Connection button to verify your choices. When you get a valid connection click OK. 5. Now expand the new Data Connection in Server Explorer and view the tables as shown in Figure 17-15. Drag the authors table and the titleauthor table on to the designer. You will not use the titleauthor table in this Try It Out but notice the relationship created for you by the Designer. Figure 17-15 611 Chapter 17 Database Programming with SQL Server and ADO.NET 6. Save the project. 7. On the form add a DataGridView with the default properties. Increase the width of the form and DataGridView so you can display more fields on the form. 8. Go to the code behind next. In the form1 load sub add the following code. Dim PubsDB As New PubsDataContext Dim authors From author In PubsDB.authors _ Where author.state CA DataGridViewl.DataSource authors 9. Run the application to see all authors in California. You should see a form like Figure 17-16. Figure 17-16 10. Add the following code to form load. Here you are selecting a single row from the database. Run the application and notice the new form title as shown in Figure 17-17. Dim authorl PubsDB.authors.SingleOrDefault Function au au.au_id 172-32-1176 Me.Text author1.au_fname author1.au_lname Figure 17-17 612 Chapter 17 Database Programming with SQL Server and ADO.NET 11. Add the following code to form load between the last two lines you added. Here you are selecting a single row from the database and then changing it. Run the application and note the new form title and the updated grid last name as shown in Figure 17-18. Dim authorl PubsDB.authors.SingleOrDefault Function au au.au_id 172-32-1176 author1.au_lname Test PubsDB.SubmitChanges Me.Text .