Jsp, Tomcat, J2Ee, Linux Web Hosting, Hibernate Programming Blog

To test the drop-down list, you have to view the page in a Web browser. Using the example in which I opted to show the UserName and Email columns from the vw_aspnet_MembershipUsers view, my drop-down list looks like the one shown in Figure 12-22. Using a DropDownList to filter records To use a DropDownList control to filter records in another data-bound control (such as a GridView), several steps are required. I ll use a GridView control to explain the basic process, but the same idea works with other Data controls described later. The first step is to add the control to the page and bind it to the values you want the control to show. For example, suppose that after you choose a user name from the drop-down list, you want to see all the transactions that user has made. You could get that result by dragging a GridView control to the same page as the DropDownList control and using the drop-down list control to filter the records it displays. Any time you add a second Data control to a page, you want to be sure to choose , and not try to use the same data source that the first control uses. That s because the data source defines the exact rows and columns that the control will show. And the rows and columns the second control shows will be different from what the first control shows. By default, the new data source is named SqlDateSrc2. When you choose a connection string, you want to reuse the same connection string you use for everything else. That s because the connection string only tells the control where the database is located it doesn t specify any tables or views within the database. When you re choosing a table, view, or column, choose one that has the same column as the DropDownList control; UserName, in this example. That s because rows to be retrieved need to be filtered by values in that column name. Figure 12-22: A Drop DownList control showing data from vw_ aspnet_ Membership Users. 282 Part III: Personalization and Databases
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.

This entry was posted on Thursday, September 20th, 2007 at 4:04 am and is filed under Linux. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.