Performing XSLT Transformations inside the Database |
|
Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr e
|
|
ODP.NET - Presenting Master-Detail Information Using a Dataset |
|
ODP NET Presenting Master Detail Information Using a Dataset As mentioned before a DataSet object can have its own relations between data tables existing in it We can add these relations dynamically at the client side within an application to represent master detail or hierarchical information The f
|
|
ODP.NET - Populating a Dataset with a Single Data Table |
|
ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
|
|
ODP.NET - Working with DataTableReader |
|
ODP NET Working with DataTableReader DataTableReader is complementary to a DataTable object and is mainly used as a type of Data Reader in the disconnected mode The following is the modified code mosgoogle geshibot language VB NET" create connection to db Dim cn As New OracleConnection D
|
|
ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter |
|
ODP NET Retrieving a Single Row of Information Using OracleDataAdapter In the previous example we worked with a set of rows in the DataTable object Now we shall work with a particular row using the DataTable object The following code accepts an employee number from the user and gives you the details
|
|
ODP.NET - Filling a DataTable Using OracleDataReader |
|
ODP NET Filling a DataTable Using OracleDataReader So far we have been filling data tables using OracleDataAdapter ADO NET 2 0 gives us the flexibility to fill a data table using OracleDataReader as well The following code gives you the details of all employees available in the emp table by filling
|
|
ODP.NET - Retrieving Multiple Rows on to the Grid |
|
ODP NET Retrieving Multiple Rows on to the Grid In the previous section we tried to retrieve only one row using OracleDataReader In this section we will try to retrieve more than one row or a result set and populate a DataGridView on a WinForm mosgoogle The following code lists out the details of al
|
|
SQL Server Integration Services |
|
SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
|
|
jQuery Table Row Finished Code |
|
jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
|
|
jQuery Interacting with Other Code |
|
jQuery Interacting with Other Code We learned with our sorting and paging code that we can t treat the various features we write as islands The behaviors we build can interact in sometimes surprising ways; for this reason it is worth revisiting our earlier efforts to examine how they coexist with t
|
|
|
