Personal Web & Sample Site
Skip Navigation Links
HOME |
About Me |
Articles
| Contact Us
Filter by category:     Articles per page:

Rating: 6 user(s) have rated this article Average rating: 4.5
Posted by: joet, on 8/10/2011, in category "MS SQL"
Views: this article has been read 4320 times
Location: Houston, Tx, United States
Abstract: In this example we are showing how we can make use of the template field. The example shows how we can concantenate the first and last name into one field. You can choose to delete both the first and last name fields or you can add to either one. In this example I deleted the last name field and then coverted the first name field to a template field and of course changed the text heading to "Name".
Rating: 10 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/10/2011, in category "MS SQL"
Views: this article has been read 4474 times
Location: Houston, Tx, United States
Abstract: Other cool examples from Scott Mitchell's data tutorial involves modifying a template field in the DetailsView control. This time instead of modfying a field I deleted those that I was replacing and then added a new TemplateField. Then I added three lables and then binded each label to a different data source, except for the first label that simply says "(In Stock / On Order)". Of course we added the object data source like before and then used the GetProducts" method and then modified the field names and deleted some others.
Rating: 8 user(s) have rated this article Average rating: 4.6
Posted by: joet, on 8/10/2011, in category "MS SQL"
Views: this article has been read 4202 times
Location: Houston, Tx, United States
Abstract: In the last two tutorials we saw how to customize the GridView and DetailsView controls' outputs using TemplateFields. TemplateFields allow for the contents for a specific field to be highly customized, but in the end both the GridView and DetailsView have a rather boxy, grid-like appearance. For many scenarios such a grid-like layout is ideal, but at times a more fluid, less rigid display is needed. When displaying a single record, such a fluid layout is possible using the FormView control. The FormView was binded to a ObjectDataSource using the GetProducts method and the resulting markup was deleted and replaced with a table and CSS classes.
Rating: 7 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/10/2011, in category "MS SQL"
Views: this article has been read 4066 times
Location: Houston, Tx, United States
Abstract: This example shows how we can add a footer and then calculate the average price and sum the totals for both the "Units in Stock" and "Units on Order". I also styled the footer with a bold and maroon font.
Rating: 6 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/5/2011, in category "MS SQL"
Views: this article has been read 3928 times
Location: Houston, Tx, United States
Abstract: First, we need to add another query to the EmployeesDataTableAdapter that retrieves those employees whose HireDate occured in a specific month. I added the following query to the EmployeesDataTableAdapter and called it "GetEmployeeByHireDateMonth". SELECT EmployeeID, LastName, FirstName, Title, HireDate, ReportsTo, Country FROM Employees WHERE DATEPART(m, HireDate) = @Month
Rating: 11 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/5/2011, in category "MS SQL"
Views: this article has been read 3421 times
Location: Houston, Tx, United States
Abstract:
Rating: 4 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/5/2011, in category "MS SQL"
Views: this article has been read 3476 times
Location: Houston, Tx, United States
Abstract:
Rating: 3 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/5/2011, in category "MS SQL"
Views: this article has been read 3454 times
Location: Houston, Tx, United States
Abstract:
Rating: 4 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 8/2/2011, in category "MS SQL"
Views: this article has been read 3588 times
Location: Houston, Tx, United States
Abstract: In the example below I used a text box to pass in the parameter and filter out all suppliers by country. The difference here is that when the page loads the text box is empty but the gridview's object data source is still invoking the select statement but returning a NULL value. What if we want to show the entire list of suppliers everytime the page loads. Then the visitor can enter a country and filter the list. The point is that we can now simply modify the supplier class file method "GetSupplierByCountry" with the following code.
Rating: 2 user(s) have rated this article Average rating: 5.0
Posted by: joet, on 7/24/2011, in category "MS SQL"
Views: this article has been read 3171 times
Location: Houston, Tx, United States
Abstract: What I did here was simply drop an ObjectDataSource onto the page, configured it using the "GetProducts" method, and then binded it to a gridview.
12

Copyright © 2013 Jose M. Tamez
Last Updated August 18th 2013