Info Bss
Understanding transaction management with ADO.NET Before you can access any part of a database, you need to establish a connection to it. You can use either the OleDbConnection or SqlConnection object to represent that connection. Throughout our discussion of ADO.NET, we are going to use a simple analogy to try and relate ADO.NET objects to something most people use everyday a telephone. This will help you visualize what is actually happening when you use the ADO.NET objects. In the telephone...
Introducing DataSets Part II
Learning to construct a DataSet without a DataAdapter object Learning to navigate the DataSet's object model Understanding the relationship between DataSet, DataTable, DataRow, and DataColumn objects In the previous session, we began our discussion of DataSet objects, the cornerstone of ADO.NET. You learned that a dataset is effectively a disconnected copy of a database and that you can populate a DataSet using a DataAdapter object. In this session, you're going to attack some of the DataSet...
ASP and ASPNET Compatibility
After installing the .NET Framework in your existing ASP environment, you will find that you are able to continue running your ASP pages without modification. Additionally, as you begin to write your own ASP.NET pages you will find that they operate nicely side by side with your existing ASP pages. However, as you begin to migrate code from your ASP pages to ASP.NET you will find that there are at least four major areas of differences in how you coded in ASP versus how you will code in ASP.NET...
The PageOnLoad event
Listing 8-4 demonstrates how you can handle HTML control events with the Page_OnLoad event. Listing 8-4 Using HTML control events with the Page_OnLoad event lt script runat server language VB gt Sub Page_Load Sender As Object, E As EventArgs If Page.IsPostBack Then Select cmbPeople.value Case Bill Gates Case Larry Ellison Response.Redirect http www.oracle.com Case Steve Case Response.Redirect http www.aol.com Case Else End Select End If End Sub lt script gt lt html gt lt body gt form id...
Consuming a Web Service
There are basically two ways to use a Web Service. You can either call the Web Service directly from your browser, as you just did, or you can use some application to programmat-ically call the service. Making a direct browser request is easy, but programmatically accessing a Web Service can be a little more difficult especially if you don't know anything about the particular Web Service you'd like to use. In order to communicate with a Web Service, you need to know what methods it supports,...
MasterDetail Relationships with the DataGrid Control
When implementing user interfaces, a very common technique for navigating through sets of data is to utilize Master Detail controls to facilitate data searching. For example, Figure 23-2 shows the data relationships that exist between the Authors table and the Titles Table in the Pubs database. Figure 23-2 Diagram of authors and titles relationship Figure 23-2 Diagram of authors and titles relationship In Figure 23-2, there is a many-to-many relationship between authors and titles. The...