源码信息

最新源码评论

  • 评论者:szy2k
    szy2k(用户) 发表于:2008-07-29 12:49:00

    开发环境 MSSQL2005&nbsp;&nbsp; VS.NET 2008<br/>在投票时提示:<font color="#ff0000">Vote.aspx&nbsp;&nbsp;</font>[url=]<font color="#ff0000">找不到存储过程 'Pr_UpdateItemVoteCount'。</font>[/url]<br/><br/>查找代码后错误在 Item.cs <br/><br/><table style="width: auto;"><tr><td style="border:none;"><div class="quote"><blockquote>public int UpdateItemVoteCount(int nItemID)<br/> {<br/>&nbsp;&nbsp;///创建链接<br/>&nbsp;&nbsp;SqlConnection myConnection = new SqlConnection(<br/>&nbsp;&nbsp; ConfigurationManager.ConnectionStrings[&quot;SQLCONNECTIONSTRING&quot;].ConnectionString);<br/>&nbsp;&nbsp;///创建Command<br/>&nbsp;&nbsp;SqlCommand myCommand = new SqlCommand(&quot;<font color="red">Pr_UpdateItemVoteCount</font>&quot;,myConnection);<br/>&nbsp;&nbsp;///设置为执行存储过程<br/>&nbsp;&nbsp;myCommand.CommandType = CommandType.StoredProcedure;<br/>&nbsp;&nbsp;///添加存储过程的参数<br/>&nbsp;&nbsp;SqlParameter pItemID = new SqlParameter(&quot;@ItemID&quot;,SqlDbType.Int,4);<br/>&nbsp;&nbsp;pItemID.Value = nItemID;<br/>&nbsp;&nbsp;myCommand.Parameters.Add(pItemID);<br/>&nbsp;&nbsp;///定义返回值<br/>&nbsp;&nbsp;int nResult = -1;<br/>&nbsp;&nbsp;try<br/>&nbsp;&nbsp;{<br/>&nbsp;&nbsp; ///打开链接<br/>&nbsp;&nbsp; myConnection.Open();<br/>&nbsp;&nbsp; ///执行SQL语句<br/>&nbsp;&nbsp; nResult = myCommand.ExecuteNonQuery();<br/>&nbsp;&nbsp;}<br/>&nbsp;&nbsp;catch(SqlException ex)<br/>&nbsp;&nbsp;{<br/>&nbsp;&nbsp; ///抛出异常<br/>&nbsp;&nbsp; throw new Exception(ex.Message,ex);<br/>&nbsp;&nbsp;}<br/>&nbsp;&nbsp;finally<br/>&nbsp;&nbsp;{&nbsp;&nbsp; ///关闭链接<br/>&nbsp;&nbsp; myConnection.Close();<br/>&nbsp;&nbsp;}<br/>&nbsp;&nbsp;///返回nResult<br/>&nbsp;&nbsp;return nResult;<br/> }</blockquote></div></td></tr></table><br/><br/><br/>请问如何解决此问题,,我是初学者,,请帮个忙,,谢谢,,,

    2 个回复
    • 回复者:szy2k
      szy2k(用户)回复于:2008-08-04 13:54:00

      顶一下

    • 回复者:286848153
      286848153(用户[下载于:2013-06-05 21:14])回复于:2013-06-06 14:03:48

      <p>我也是这个问题,,楼主帮忙解决一下吧</p><p><br /></p>