<asp:DataList ID="datalist1"
runat="server"
Width="100%"
RepeatColumns="2"
RepeatDirection="Horizontal">
<itemtemplate>
<div align="center">
<table width="322" height="167" bgcolor="#F8F4E4">
<!--DWLayoutTable-->
<tr align="left" valign="middle">
<td height="15" colspan="2">------------------------------------------------</td>
</tr>
<tr>
<td width="138" height="26" valign="top">所在单位:</td>
<td width="167" valign="top"><asp:textbox ID="text1" Text='<%# DataBinder.Eval(Container.DataItem,"dw")%>' runat="server" Width="110" CssClass="edline" Enabled="true" style="border:1px solid black"/>
</td>
</tr>
<tr align="center" valign="bottom">
<td height="25" colspan="2"><asp:button Text="立即更新" runat="server" ID="button2" style="border:1px solid black" OnClick="button2_click"/>
</td>
</tr>
</table>
</div>
</itemtemplate>
</asp:datalist>后台代码用dataset设置数据源与之绑定。
runat="server"
Width="100%"
RepeatColumns="2"
RepeatDirection="Horizontal">
<itemtemplate>
<div align="center">
<table width="322" height="167" bgcolor="#F8F4E4">
<!--DWLayoutTable-->
<tr align="left" valign="middle">
<td height="15" colspan="2">------------------------------------------------</td>
</tr>
<tr>
<td width="138" height="26" valign="top">所在单位:</td>
<td width="167" valign="top"><asp:textbox ID="text1" Text='<%# DataBinder.Eval(Container.DataItem,"dw")%>' runat="server" Width="110" CssClass="edline" Enabled="true" style="border:1px solid black"/>
</td>
</tr>
<tr align="center" valign="bottom">
<td height="25" colspan="2"><asp:button Text="立即更新" runat="server" ID="button2" style="border:1px solid black" OnClick="button2_click"/>
</td>
</tr>
</table>
</div>
</itemtemplate>
</asp:datalist>后台代码用dataset设置数据源与之绑定。
Object reference not set to an instance of an object.
代碼如下: Sub Update_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyCommand As OleDbCommand
Dim UpdateCmd As String = "Update info set fname=@FName,phone=@phone,content=@content,title=@title where id="&id MyCommand = New OleDbCommand(UpdateCmd, MyConnection) MyCommand.parameters.add("@fname",fname.text)
MyCommand.parameters.add("@phone",phone.text)
MyCommand.parameters.add("@content",Content.text)
MyCommand.parameters.add("@title",Title.text) MyCommand.Connection.Open()
MyCommand.ExecuteNonQuery()
MyCommand.Connection.Close()
Response.Redirect ("list.aspx?id="&id)
End Sub
是fname.text這有錯,請問怎樣解決呀.
是不是应该加个New以实例化:Dim DS As New DataSet还有这一行: Dim UpdateCmd As String = "Update info set fname=@FName,phone=@phone,content=@content,title=@title where id="&id
是不是fname=@FName出了问题,改成fname=@fname试试