news.cs

一个出售宠物的网站,比较全面

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace hellopet
{
	/// <summary>
	/// News 的摘要说明。
	/// </summary>
	public class News
	{
		public News()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
	    //显示最新十条新闻
	    public DataSet showTopNews()
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		string strSelNews="select top 10 topic,addtime from news where leibie='新闻在线' order by addtime desc";
		SqlDataAdapter da=new SqlDataAdapter(strSelNews,conn);

		conn.Open();
		DataSet ds=new DataSet();
		da.Fill(ds,"news");
		return ds;
		}
	    //显示单条信息
	    public SqlDataReader Query_details(string topic)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("query_details",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		SqlParameter pTopic =new SqlParameter("@topic",SqlDbType.Char,40);
		pTopic.Value=topic;
		myCommand.Parameters.Add(pTopic);
		conn.Open();
		SqlDataReader dr=myCommand.ExecuteReader();
		return dr;

	    }
	}
}