Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp.net ´æ´¢¹ý³Ì£¬ÎÒÒª·µ»Ø¼Ç¼¼¯£¬ºÍ¼Ç¼×ÜÊý

SQL code:

create proc ok
@pagesize int,
@pageindex int,
@pagetable nvarchar(50),
@RecordTotal int output
as
declare @sql nvarchar(500)
declare @StrTotalSQL nvarchar(500)

set @StrTotalSQL='select @RecordTotal=count(*) from t1'
-- '+@RecordTotal+'=

begin
set @sql='select top '+str(@pagesize)+' * from '+@pagetable+' where userid not in(select top '+str(@pagesize*(@pageindex-1))+' userid from '+@pagetable+')'
end

execute(@sql)
execute(@StrTotalSQL)
--ÎÒÒª·µ»Ø¼Ç¼¼¯£¬ºÍ¼Ç¼×ÜÊý¡£ÎÒµ÷Óò»ÁË£¬Õâ¸ö¼Ç¼×ÜÊý£¬ÊDz»ÊÇд´íÁËʲô£¬¶¨»¹ÊÇ£¬ÎÒµ÷ÓÃÓÐÎÊÌ⣿ϣÍûÓÐÈËÖ¸µã¡£



¿´ÉÏÈ¥Ó¦¸Ãû´í£¬ÄãÖ±½ÓÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÕâ¸ö´æ´¢¹ý³ÌÄܵõ½ÕýÈ·µÄ½á¹ûÂð£¿

Äã¾ßÌåÊÇÔõÑùµ÷Óõģ¿

C# code:

public SqlDataReader ok(string pagetable, int pageindex, int pagesize)
{

SqlCommand mycmd = new SqlCommand("ok", conopen());
mycmd.CommandType = CommandType.StoredProcedure;
SqlParameter workParm;
workParm = mycmd.Parameters.Add("@pagetable", SqlDbType.NVarChar, 50);
mycmd.Parameters["@pagetable"].Value = pagetable;

workParm = mycmd.Parameters.Add("@pageindex", SqlDbType.NVarChar, 50);
mycm


Ïà¹ØÎÊ´ð£º

³ö×âASP.NET³ÌÐòÔ±

±¾ÈËÔÚ±±¾©,ÐÕ³Â
ÓÐ2ÄêÒÔÉϹ¤×÷¾­Ñé.
ÓÐÐèÒªµÄÇëÁªÏµ13683175921,´ýÓöÏê̸.
(·Ç³ÏÎðÈÅ!)
Good Luck£¡~ ÓÑÇéUp£¡~

How Much? ~ ÓÑÇéUp£¡~



Óе㱯¾ç°¡


ÓÑÇéUp£¡~

ÈÕ×ÓÄѻ찡

Ö§³ÖÂ¥Ö ......

°ïÃ¦ÍÆ¼öÒ»±¾ASP.NETµÄÊ飬лл£¡

±È½ÏºÃµÄѧϰasp.netµÄÊéÍÆ¼öһϰɣ¬Ð»Ð»~~~
書µÄ話µÈ¸ßÈËÍÆ薦, ÎÒ認為¶àÉÏÉÏwww.asp.net對Äã幫Öúͦ´ó, ÄÇÀïÓкܶà視頻, Èç¹ûÊÇÐÂÊÖµÄ話, 視& ......

asp.netµ¯³ö¿òÎÊÌâ

ÔÚµ¯³ö¿òÖеã»÷Ò»¸ö°´Å¥£¬Ôõôµ÷תµ½ÁíÒ»¸öä¯ÀÀÆ÷£¬²¢ÇÒÔÚ¸Ãä¯ÀÀÆ÷´ò¿ªÁ½¸öÒ³Ãæ
ÄãµÄÒâ˼Ӧ¸ÃÊÇ
response.write("<script>alert('È·ÈÏ'); window.location.href('xxxx.aspx'); </script>"); ......

ASP.NET MVC¼Ü¹¹·¢²¼ÁË - .NET¼¼Êõ / ASP.NET

ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂð£¿
»¹ÔÚѧϰÖÐ

ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆð¹¤³§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Ó­µ½ÎÒ²©¿Í»¥Ïàѧϰ

¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ