存储过程:
CREATE PROC Pro_GetNewsByTitleAndContentNumb
@newsKey VARCHAR(64),
@numb int out
AS
SELECT NewsTitle,SUBSTRING(NewsContent,1,20)+'......' as NewsContent,CreateTime FROM T_News
WHERE NewsTitle like @newsKey or NewsContent like @newsKey;
SELECT @numb=COUNT(*)FROM T_News
WHERE NewsTitle like @newsKey or NewsContent like @newsKey;
Go
前台代码:
<body>
<form id="form1" runat="server">
<div>标题:<asp:TextBox ID="txtNewsTitle" runat="server" ></asp:TextBox>
<asp:Button ID=