tailieunhanh - 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 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 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 _ Where CA 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 Function au 172-32-1176 Figure 17-17 612 Chapter 17 Database Programming with SQL Server and 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 Function au 172-32-1176 Test .