Ó£Ö®»¨

´úÂëÈçÏÂ:

create procedure procNewsSelectNewNews
as
begin
select top 10 n.id,n.title,n.createTime,c.name from news n
inner join category c on n.caId=c.id
order by n.createTime desc
end

´úÂëÈçÏÂ:

public DataTable test(string procName)
{
DataTable dt=new DataTable();
cmd=new SqlCommand(procName,GetConn()); //Êý¾Ý¿âÁ¬½ÓºÍÁ¬½Ó¿ª±Õ£¬¶¼·ÅÔÚÁËGetConn()·½·¨ÖÐ
cmd.CommandType=CommandType.StoredProcedure£» //¶¨ÒåSQLÓï¾äÃüÁîÀàÐÍΪ´æ´¢¹ý³Ì
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))£»//·½·¨½«SQLÓï¾ä·¢Ë͸øSqlConnection²¢Éú²úÒ»¸öSqlDataReaderÀà¶ÔÏ󣬸ÃSqlDataReader¶ÔÏó°üº¬SQLÃüÁî·µ»ØµÄÊý¾Ý
{ dt.Load(sdr); //load²éѯdataread²éѯµÄ½á¹û }
return dt;
}

´úÂëÈçÏÂ:

public DataTable ExecuteQuery(string sqlText,CommandType ct)£» //²»½ö´«ÈëSQLÓï¾ä»¹´«ÈëÒ»¸öÃüÁîÀàÐÍ
{
DataTable dt=new DataTable();
cmd=new SqlCommand(sqlText,GetConn());
cmd.CommandType=ct;
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{ dt.Load(sdr);}
return dt;
}

´úÂëÈçÏÂ:

public DataTable SelectNewNews()
{
return sqlhelper.ExecuteQuery(¡°´æ´¢¹ý³ÌÃû¡±,CommandType.StoredProcedure)
}

´úÂëÈçÏÂ:

public DataTable SelectAll()
{
DataTable dt=new DataTable();
string sql=¡±select * from news¡±;
dt=sqlhelper.ExecuteQuery(sql,CommandType.Text);¡¤
return dt
}