Hi.
I get an exception, and can't figure it out.
Can someone please help me?
BC30456: DataItem is not a member of System.Web.UI.Control.
Line 91: <ASP:TEMPLATECOLUMN itemstyle-wrap="False" headertext="Spille tid" datafield="Spilletid">
Line 92: <ITEMTEMPLATE>
Line 93: <ASP:LABEL id=Spilletid runat="server" text='<%# DataBinder.Eval(Container.DataItem, "Spilletid", "{0:c}") %>'>
Line 94: </ASP:LABEL>
Line 95: </ITEMTEMPLATE>
*****************************************
Code (I'm using OleDB, and a private database):
<%@ import Namespace="System.Data.SQLClient" %>
<%@ import Namespace="System.Data.OleDB" %>
<%@ import Namespace="System.Data" %>
<HTML>
<HEAD>
<TITLE>updateGrid</TITLE>
<META content="Internet Explorer 6.0" name="vs_targetSchema">
<SCRIPT language="
vb" runat="server">
' Dim objConnection As SqlConnection
Dim strConnection AS String = "Provider=MSDAORA.1;Password=abc;User ID=abc;Data Source=ABCSOURCE"
Dim objConnection as New OleDbConnection(strConnection)
Sub Page_Load(Sender as Object, E As EventArgs)
If Not (IsPostBack)
BindGrid()
End If
End Sub
Sub Page_Unload(Sender as Object, E as EventArgs)
objConnection = Nothing
End Sub
Sub BindGrid()
Dim objDataSet as DataSet
Dim objDataAdapter as OleDBDataAdapter
objDataAdapter = New OleDBDataAdapter("Select KampID, SpillerID, Spilletid from Boers", objConnection)
objDataSet = New DataSet()
objDataAdapter.Fill(objDataSet, "Boers")
grdBoers.DataSource = objDataSet
grdBoers.DataBind()
objDataAdapter = Nothing
objDataSet = Nothing
End Sub
Sub EditGridData(Sender as Object, E as DataGridCommandEventArgs)
grdBoers.EditItemIndex = CInt(E.Item.ItemIndex)
BindGrid()
End Sub
Sub CancelGridData(Sender as Object, E as DataGridCommandEventArgs)
grdBoers.EditItemIndex = -1
BindGrid()
End Sub
Sub UpdateGridData(Sender as Object, E as DataGridCommandEventArgs)
Dim objCommand as OleDBCommand
Dim objTextBox as TextBox
Dim strSQL as String = "UPDATE Boers SET Spilletid = @Spilletid WHERE KampID = @KampID AND SpillerID = @SpillerID"
objCommand = New Oledbcommand(strSQL, objConnection)
objCommand.Parameters.Add(New OleDbParameter("@KampID", OleDBType.Integer, 10))
objCommand.Parameters.Add(New OleDbParameter("@SpillerID", OleDBType.Integer, 10))
objCommand.Parameters.Add(New OleDbParameter("@Spilletid", OleDbType.Integer, 2))
objCommand.Parameters("@KampID").Value = grdBoers.DataKeys(CInt(E.Item.ItemIndex))
objCommand.Parameters("@SpillerID").Value = grdBoers.DataKeys(CInt(E.Item.ItemIndex))
objTextBox = E.Item.FindControl("edit_spilletid")
objCommand.Parameters("@Spilletid").Value = objTextBox.Text
objCommand.Connection.Open()
objCommand.ExecuteNonQuery()
grdBoers.EditItemIndex = -1
objCommand.Connection.Close()
BindGrid()
objCommand = Nothing
objTextBox = Nothing
End Sub
</SCRIPT>
</HEAD>
<BODY ms_positioning="FlowLayout">
<FORM>
<ASP:DATAGRID id="grdBoers" runat="server" headerstyle-forecolor="White" headerstyle-font-bold="true" headerstyle-backcolor="Maroon" gridlines="None" font-size="8pt" font-names="Verdana" datakeyfield="kampID" cellpadding="3" backcolor="White" autogeneratecolumns="false" alternatingitemstyle-backcolor="whitesmoke" onupdatecommand="UpdateGridData" oncancelcommand="CancelGridData" oneditcommand="EditGridData"></ASP:DATAGRID>
<COLUMNS>
<ASP:EDITCOMMANDCOLUMN itemstyle-wrap="False" updatetext="Update Row" canceltext="Cancel Edit" edittext="Edit Row" />
<ASP:BOUNDCOLUMN visible="False" datafield="kampID" />
<ASP:BOUNDCOLUMN visible="False" datafield="SpillerID" />
<ASP:TEMPLATECOLUMN itemstyle-wrap="False" headertext="Spille tid" datafield="Spilletid">
<ITEMTEMPLATE>
<ASP:LABEL id=Spilletid runat="server" text='<%# DataBinder.Eval(Container.DataItem, "Spilletid", "{0:c}") %>'>
</ASP:LABEL>
</ITEMTEMPLATE>
<EDITITEMTEMPLATE>
<ASP:TEXTBOX id=edit_spilletid runat="server" font-size="8pt" text='<%# DataBinder.Eval(Container.DataItem, "Spilletid", "{0:c}") %>' width="100" font-name="Verdana">
</ASP:TEXTBOX>
</EDITITEMTEMPLATE>
</ASP:TEMPLATECOLUMN>
<ASP:BOUNDCOLUMN itemstyle-wrap="False" headertext="Nr." datafield="Nummer" />
</COLUMNS></FORM>
</BODY>
</HTML>
Another Chapter 17 problem (DataGrid Update)
