birt upc-a

birt upc-a

birt upc-a

birt upc-a

birt upc-a,

birt upc-a,

birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,

birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,

birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,
birt upc-a,

Several data set classes use a Java Database Connectivity (JDBC) connection to retrieve data for the chart. The first step is to create a SQL query that will provide the result set you need out of your database. The JDBCCategoryDataset, JDBCPieDataset, and JDBCXYDataset classes in the org.jfree.data package all have specific requirements for the JDBC result set. For the JDBC pie data set, the result set should contain two columns. The first column should contain the labels for the pie slices, and the column s data type must be VARCHAR. The other column contains the values for the pie chart. The JDBC data set classes can access the database with a portlet-supplied JDBC java.sql.Connection object, or they can create the connection with the JDBC URL, JDBC driver name, and a database user s username and password.

Also, if you look closely at the list containing the controls, you can see that the header ID has been set to theHead in Figure 3-7.

To code our functionality, you need to import two namespaces: System.Net and System.Net.Mail. The latter namespace provides classes for sending emails. Listing 11-9 shows the Click event handler after adding the necessary code. Listing 11-9. Sending Email from the Code-Behind File protected void Button1_Click(object sender, EventArgs e) { SmtpClient client = new SmtpClient("localhost"); client.Credentials = CredentialCache.DefaultNetworkCredentials; MailMessage msg = new MailMessage(); msg.From = new MailAddress(TextBox2.Text); msg.To.Add("you@yourdomain.com"); msg.Subject = TextBox3.Text; msg.Body = "[" + DropDownList1.SelectedItem.Text + "]" + TextBox4.Text + "\r\n" + TextBox1.Text + "\r\n" + TextBox5.Text; client.Send(msg); Label9.Text = "Your message has been sent. Thank you!"; }

JFreeChart will accept XML in its own format as the data source for the category and pie data sets. The org.jfree.data.xml.DatasetReader class provides helper methods for loading data sets from XML files or input streams. The JFreeChart code to parse XML into a data set is not very complicated, so it should be easy to add support for other data set types or XML formats. The XML format used for category data sets and pie data sets mirrors the CategoryDataset and PieDataset objects. Here is an XML data source that demonstrates the structure for the PieDataset:

Because controls are objects, and because the page controls are a collection, you can also create controls at runtime. So, if you consider the previous example, you can add a new list box to the bottom of the form quite easily with this code:

< xml version="1.0" encoding="UTF-8" > <PieDataset> <Item> <Key>Winter</Key> <Value>110</Value> </Item> <Item> <Key>Spring</Key> <Value>180</Value> </Item> <Item> <Key>Summer</Key> <Value>220</Value> </Item> <Item> <Key>Fall</Key> <Value>175</Value> </Item> </PieDataset>

The code declares an object of the SmtpClient class. The SmtpClient class allows you to send emails based on Simple Mail Transfer Protocol (SMTP). The constructor of the SmltpClient class accepts the IP address or name of the machine used for SMTP operations. In our example, it is assumed that you are using a local installation of IIS for sending emails and hence localhost is passed as the parameter. The Credentials property of the SmtpClient class indicates the network credentials of a user for authenticating the sender. The DefaultNetworkCredentials property of the CredentialCache class indicates the authentication credentials of the current Windows user. After the credentials have been set, a new MailMessage is created. The MailMessage class represents an email message. The From and To properties of this class represent the sender and receiver, respectively, and are of type MailAddress. The Subject and Body properties indicate the subject and body of the email, respectively. All these properties are assigned by using the values entered in various web form controls. Finally, the Send() method of the SmtpClient class sends the supplied MailMessage to one or more recipients. A success message is displayed in a label informing the user that the message has been received. Running the Web Application To run the web application that you just finished, you need to choose the Debug Start Debugging menu option. Visual Studio asks whether you would like to turn on debugging (Figure 11-6). Simply keep the default selection and click OK.

protected void Page_Load(object sender, EventArgs e) { foreach(Control ctrl in Page.Controls) { ListBox1.Items.Add(ctrl.GetType().ToString() + ":" + ctrl.ID); } theHead.Title = "Dynamically Created Title!"; ListBox newListBox = new ListBox(); newListBox.Items.Add(new ListItem("Item on my Dynamic List")); Page.Form.Controls.Add(newListBox); }

14

Note After you click OK in the Debugging Not Enabled dialog box, Visual Studio will actually add a file

<CategoryDataset>, and the children of the root element are <Series> XML elements. The <Series> elements contain one more <Item> element. For an example, see the