Changing Output with the ItemCreated Event Using the DataGrid and DataList
You might want to alter the way an item is rendered based on certain criteria, using either the DataGrid or DataList controls. For example, you might have a DataGrid which displays accounting information and you want negative numbers to be red instead of black. You can use the ItemCreated event to accomplish this. This event is fired every time an item is created for either control. Listing 10.4 illustrates how to use this feature in the DataGrid.
Listing 10.4. Using the ItemCreated Event with the DataGrid
[Visual Basic]
01: <%@ import namespace="System.Data" %>
02: <%@ import namespace="System.Data.SqlClient" %>
03: <script language="c#" runat="server">
04: private string sSqlCon = "server=localhost;uid=sa;pwd=;database=northwind";
05:
06: public void Page_Load(Object sender, EventArgs e){
07:
08: if (! IsPostBack){
09: Bind();
10: }
11:
12: }
13:
14: private void Bind() {
15:
16: SqlConnection SqlCon = new SqlConnection(sSqlCon);
17: StringBuilder SqlCmd = new StringBuilder();
18: SqlCmd.Append("SELECT ProductName,UnitPrice,");
19: SqlCmd.Append("UnitsInStock,UnitsOnOrder,");
20: SqlCmd.Append("ProductID FROM Products");
21: SqlDataAdapter sda = new SqlDataAdapter(SqlCmd.ToString(),SqlCon);
22: DataSet ds = new DataSet();
23: sda.Fill(ds,"products");
24: DGProducts.DataSource = ds.Tables["Products"].DefaultView;
25: DGProducts.DataBind();
26:
27: }
28:
29: public void DGProducts_ItemCreated(Object sender, DataGridItemEventArgs e) {
30:
31: if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType
|
.AlternatingItem) {
32: int iUnitsInStock = int.Parse(DataBinder.Eval(e.Item.DataItem, "UnitsInStock")
One of the things to do when you want to use the ItemCreated event is set the OnItemCreated attribute equal to the name of the method that will handle the ItemCreated event (line 67). In this example, it's DGProducts_ItemCreated (lines 29–38) and it expects Object and DataGridItemEventArgs as parameters. DataGridItemEventArgs contains the Item that's going to be added to the container, and you have programmatic access to all its attributes. In our example we are going to check the value of the UnitsInStock field from our data source. If it is equal to 10 or less than that cells ForeColor will be red.
Because the ItemCreated event is fired for each item including the DataGrid's Header and Footer we need to evaluate the item to make sure it is either of the Item or AlternatingItem type (line 31); otherwise you would receive an exception. Figure 10.4 is an illustration of this page.
Figure 10.4. Using the ItemCreated event to change the ForeColor attribute of the item to red if the value of the UnitsInStock field is less than 10.
Listing 10.5 illustrates how to handle the ItemCreated event using the DataList control.
Listing 10.5. Using the ItemCreated Event with the DataList
[Visual Basic]
01: <%@ import namespace="System.Data" %>
02: <%@ import namespace="System.Data.SqlClient" %>
03: <script language="vb" runat="server">
04: private sSqlCon as string = "server=localhost;uid=sa;pwd=;database=northwind"
05:
06: public sub Page_Load(sender as Object, e as EventArgs)
07:
08: if not IsPostBack then
09: Bind()
10: end if
11:
12: end sub
13:
14: private sub Bind()
15:
16: dim SqlCon as new SqlConnection(sSqlCon)
17: dim SqlCmd as new StringBuilder()
18: SqlCmd.Append("SELECT ProductName,UnitPrice,")
19: SqlCmd.Append("UnitsInStock,UnitsOnOrder,")
20: SqlCmd.Append("ProductID FROM Products")
21: dim sda as new SqlDataAdapter(SqlCmd.ToString(),SqlCon)
22: dim ds as new DataSet()
23: sda.Fill(ds,"products")
24: DLProducts.DataSource = ds.Tables("Products").DefaultView
25: DLProducts.DataBind()
26:
27: end sub
28:
29: public sub DLProducts_ItemCreated(sender as Object,e as DataListItemEventArgs)
30:
31: if (e.Item.ItemType = ListItemType.Item or e.Item.ItemType = ListItemType
|
To handle the ItemCreated event using the DataList, first you set the OnItemCreated attribute to be equal to the method that will handle the event. In this case, it's DataList_ItemCreated. The only difference between handling the ItemCreated event in the DataGrid and doing so in the DataList is how you tell the control. Figure 10.5 is an illustration of this page.
Figure 10.5. Using the ItemCreated event to change the ForeColor attribute of the item to red if the value of the UnitsInStock field is less than 10.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.