62,047
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
hanlixing 2003-04-26
- 打赏
- 举报
兄弟，你的插入语句好像不对吧
改成这样看看：例：strcomm="insert into aPP_news(c_title,c_content,c_source)values('" & aaa & "','" & bbb & "','" & ccc & "')"
改成这样看看：例：strcomm="insert into aPP_news(c_title,c_content,c_source)values('" & aaa & "','" & bbb & "','" & ccc & "')"
china91chen 2003-04-26
- 打赏
- 举报
异常详细信息: System.InvalidCastException: 指定的转换无效。
堆栈跟踪:
[InvalidCastException: 指定的转换无效。]
ASP.sa5_aspx.sub_clk(Object sender, EventArgs e) +88
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
代码如下
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.sqlclient" %>
<html>
<script language="vb" runat="server">
Sub dl()
dim strconn="server=svr;database=chen;uid=sa;password=;"
dim strcom="select * from person"
dim conn as new sqlconnection(strconn)
conn.open
dim DA as new sqldataAdapter(strcom,conn)
dim ds as new dataset()
DA.fill(ds,"person")
dg1.datasource=Ds.tables("person")
dg1.databind()
conn.close
End Sub
Sub sub_clk(sender as object,e as eventargs)
dim strconn="server=local;database=chen;uid=sa;password=;"
dim strcom="insert person(name,address,tel) values(& name.text,& address.text,& tel.text)"
dim conn as new sqlconnection(strconn)
dim com as new sqlcommand(strcom,strconn)
conn.open
com.executenonquery()
conn.close
dl()
End Sub
</script>
<body>
<form runat="server">
<asp:textbox id="name" runat="server"/><p>
<asp:textbox id="address" runat="server"/><p>
<asp:textbox id="tel" runat="server"/><p>
<asp:textbox id="mobile" runat="server"/><p>
<asp:button id="submit" text="输入数据库" runat="server" onclick=sub_clk/><p>
<asp:datagrid id="dg1" runat="server" gridline="none"/>
</form>
</body>
</html>
堆栈跟踪:
[InvalidCastException: 指定的转换无效。]
ASP.sa5_aspx.sub_clk(Object sender, EventArgs e) +88
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
代码如下
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.sqlclient" %>
<html>
<script language="vb" runat="server">
Sub dl()
dim strconn="server=svr;database=chen;uid=sa;password=;"
dim strcom="select * from person"
dim conn as new sqlconnection(strconn)
conn.open
dim DA as new sqldataAdapter(strcom,conn)
dim ds as new dataset()
DA.fill(ds,"person")
dg1.datasource=Ds.tables("person")
dg1.databind()
conn.close
End Sub
Sub sub_clk(sender as object,e as eventargs)
dim strconn="server=local;database=chen;uid=sa;password=;"
dim strcom="insert person(name,address,tel) values(& name.text,& address.text,& tel.text)"
dim conn as new sqlconnection(strconn)
dim com as new sqlcommand(strcom,strconn)
conn.open
com.executenonquery()
conn.close
dl()
End Sub
</script>
<body>
<form runat="server">
<asp:textbox id="name" runat="server"/><p>
<asp:textbox id="address" runat="server"/><p>
<asp:textbox id="tel" runat="server"/><p>
<asp:textbox id="mobile" runat="server"/><p>
<asp:button id="submit" text="输入数据库" runat="server" onclick=sub_clk/><p>
<asp:datagrid id="dg1" runat="server" gridline="none"/>
</form>
</body>
</html>
