62,046
社区成员
发帖
与我相关
我的任务
分享
<%=GetSingle(5,12,10201,"","")%>
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
namespace kt
{
public partial class _Default : System.Web.UI.Page
{
/// <summary>
/// 显示新闻标题函数,(行数,字数,新闻类数,更多链接地址,标题链接地)
/// </summary>
/// <param name="showrow">行数</param>
/// <param name="wordcol">字数</param>
/// <param name="kind">新闻类数</param>
/// <param name="morelink">更多链接地址</param>
/// <param name="titlelink">标题链接地</param>
/// <returns></returns>
public static object GetSingle(int showrow,int wordcol,int kind,string morelink,string titlelink)
{
string titleString = "";
string sql = "select top " + showrow + " left(news_title," + wordcol + ") as title,id from news where news_show=" + kind;
string strconn = ConfigurationManager.ConnectionStrings["conName"].ConnectionString;
using (IDbConnection conn = new SqlConnection(strconn))
{
using (IDbCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
using (IDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
titleString+=(dr["title"] + "<br/>");//显示第一行
}
}
}
}
return titleString;
}
protected void Page_Load(object sender, EventArgs e)
{
}
}
}
public string GetSingle(int showrow,int wordcol,int kind,string morelink,string titlelink){}
//改成这样试试