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 - Handling Nulls when Working with OracleDataReader |
|
ODP NET Handling Nulls when Working with OracleDataReader When we work with OracleDataReader or for that matter even with data rows in a data table we may come across nulls The following is the efficient way to deal in with such scenarios mosgoogle geshibot language VB NET" create connect
|
|
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
|
|
SQA Implementation |
|
SQA Implementation Developers and the SQA team create a development plan before they build an application The developers write following the SDLC plan while the SQA team writes the Software Quality Assurance Plan to ensure that the SDLC plan was executed If these documents by the developers and the
|
|
SQA Approaches and Methodologies |
|
SQA Approaches and Methodologies A scientific approach should have methods As a scientific process a stage or a step should be established or used to ensure the final product is according to the user’ s specifications The method is usually determined through the wishes of the clients the a
|
|
|
Online Test 
