18-5-2012 15:46:14
Moiij người giúp mình với....
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[usp_hienvd_get_song_bysinger]
-- Add the parameters for the stored procedure here
@id_casy INT,
@id_baihat INT,
@PageIndex INT,
@PageSize INT
AS
BEGIN
WITH DsAlbum AS (
SELECT ROW_NUMBER() OVER (ORDER BY tb_casy.id_casy DESC) AS RowIndex,tb_baihat.id_baihat as idbh,
tb_casy.ten_casy as cs,tb_baihat.ten_baihat as bh
from tb_casy,tb_baihat
where tb_casy.id_casy=tb_baihat.id_casy and tb_baihat.id_baihat=@id_baihat
) , GetTotalRowCount AS (
SELECT MAX(RowIndex) AS TotalRowCount
FROM DsAlbum
)
SELECT cs,bh, TotalRowCount
FROM DsAlbum, GetTotalRowCount
WHERE (RowIndex BETWEEN (@PageIndex - 1) * @PageSize + 1 AND @PageIndex*@PageSize)
END
-----------------------------------------------------------------
code cần phân trang:
public string listsonghot()
{
string strSong = "";

DataTable tblData = tl.GetAllTopByTypeMusic(6,5,5);
if (tblData.Rows.Count > 0)
{
foreach (DataRow dr in tblData.Rows)
{
string ma_nhaccho = "";
if (String.IsNullOrEmpty(dr["MaNhac"].ToString()))
{
ma_nhaccho = "dang cap nhat";
}
else
ma_nhaccho = dr["MaNhac"].ToString();
strSong += @"
<div class='list-items'>
<div class='back_list'> <a href='#'>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tbody><tr>
<td width='35' align='left'><img src='images/play.png' alt='play' height='28' width='28'></td>
<td><span class='title'> " + dr["TenBaiHat"] + @" </span> <span class='text'> " + dr["TenCasy"] + @" </span></td>
<td class='maso' valign='middle'>" + ma_nhaccho + @"</td>
</tr>
</tbody></table>
</a> </div>
</div>";

}
}
---------------------------------------
Minh đang cần phân trang bằng code chứ ko bằng user control. Mình dốt mấy cái này...hic