MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@n_id", SqlDbType.int, 10))
MyCommand.SelectCommand.Parameters("@n_id").Value = Request.QueryString("n_id")
MyCommand=new SqlDataAdapter(Selectcmd,MyConnection)
dim Selectcmd as string="select n_id,rq,title,content from news where n_id=@n_id"换一下位置怎么样?
MyCommand.SelectCommand.Parameters("@n_id").Value = Request.QueryString("n_id")
MyCommand=new SqlDataAdapter(Selectcmd,MyConnection)
dim Selectcmd as string="select n_id,rq,title,content from news where n_id=@n_id"换一下位置怎么样?
MyCommand.SelectCommand.Parameters("@n_id").Value = (Request.QueryString("n_id")).ToString();
dim MyCommand as SqlDataAdapter
dim Selectcmd as string="select n_id,rq,title,content from news where n_id=@n_id" MyCommand=new SqlDataAdapter(Selectcmd,MyConnection)'上移到这里 MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@n_id", SqlDbType.int, 10))
MyCommand.SelectCommand.Parameters("@n_id").Value = Request.QueryString("n_id")
ds=new dataset()
MyCommand.fill(ds,"newss")
MyDataList.datasource=ds.tables("newss").defaultview
MyDataList.databind()
--------------------------------------------------------------------------------被准备语句 '(@n_id int)select n_id,rq,title,content from news where n_id=@n_' 需要参数 @n_id,但未提供该参数。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 被准备语句 '(@n_id int)select n_id,rq,title,content from news where n_id=@n_' 需要参数 @n_id,但未提供该参数。源错误:
行 26:
行 27: ds=new dataset()
行 28: MyCommand.fill(ds,"newss")
行 29:
行 30: MyDataList.datasource=ds.tables("newss").defaultview
源文件: E:\Inetpub\wwwroot\mpc\Show_ZuiXinDongTai.aspx 行: 28
http://chs.gotdotnet.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/data/datagrid13.src&file=VB\datagrid13_details.aspx&font=3
<asp:HyperLinkColumn
DataNavigateUrlField="au_id"
DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
Text="获取详细信息"
/>
它这页是有通过上面的超连接传值到你这页,我想你是没有绑上,或者是你直接访问datagrid13_details.aspx 这页而不是通过上页的超连接过来的吧?微软的这页源代码是没有问题的,只不过是被你修改后的源代码有问题而已<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "作者") MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub</script><body style="font: 10.5pt 宋体"> <form runat="server"> <h3><font face="宋体">处理主-从关系</font></h3> <span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/><p> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
DataKeyField="au_id"
> <Columns>
<asp:HyperLinkColumn
DataNavigateUrlField="au_id"
DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
Text="获取详细信息"
/>
</Columns> </ASP:DataGrid> </form></body>
</html>
而且我的n_id字段本来就是int型的