asp.net ³ÌÐò¶¯Ì¬Ìí¼Ógridview
ǰ̨:
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div id="divshow" runat="server" >
</div>
</form>
</body>
</html>
ºǫ́£º
GridView gvshow=null;
public void setBind()
{
DataTable dt = getDataTable(); //»ñµÃÊý¾ÝÔ´
gvshow = new GridView();
gvshow.Width = Unit.Pixel(800);
gvshow.AutoGenerateColumns = false;
gvshow.RowDataBound += new GridViewRowEventHandler(gvshow_RowDataBind);
gvshow.RowDeleting +=new GridViewDeleteEventHandler(gvshow_RowDeleting);
gvshow.DataSource = dt;
for (int i = 0; i < dt.Columns.Count; i++)
{
BoundField bc = new BoundField();
bc.DataField = dt.Columns[i].ColumnName.ToString();
for (int i = 0; i < dt.Columns.Count; i++)
{
BoundField bc = new BoundField();
bc.DataField = dt.Columns[i].ColumnName.ToString();
&
Ïà¹ØÎĵµ£º
ǰÑÔ£ºµ±Ò»¸öHttpÇëÇó·¢Ë͸øÒ»¸öaspxÒ³ÃæÊ±,·þÎñÆ÷½øÐÐÁËÄÄЩ²Ù×÷£¿ÓÖÈçºÎÀ´½âÎöÕâ¸öÇëÇó£¿ASP.NETÔÚ½ÓÊÕÇëÇóºóÊÇÔõôÔËÐеģ¬ÈçÔõô±àÒëÒÔ¼°ÔõôÑùÓÃÍйܵĴúÂëÀ´ÔËÐеģ¿.....Àí½âÕâЩÎÊÌ⣬ʹÎÒÃÇ¿ÉÒÔ¸ü¼ÓºÃµÄ¿ª·¢ASP.NET¡£
¡¡¡¡1.µ±ÎÒÃÇÔÚä¯ÀÀÆ÷ÖÐÇëÇóÒ»¸öASP.NETÍøÕ¾µÄij¸öÒ³ÃæµÄʱºò£¬È磬ÎÒÃÇÔÚä¯ÀÀÆ÷ÖÐÊäÈë" ......
SQL
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--°¢»áéªsosuo8.com¸ù¾ÝÍøÂçÉϵĴúÂë½øÐÐÁËÐ޸쬰æÈ¨¹éÔ×÷ÕßËùÓÐ2009-4-5
--°¢»áéª×öÁËÒ»´ÎÉý¼¶£¬2009-9-27
--ÐÞ¸ÄÊä³ö×ܼǼÊý
ALTER PROCEDURE [dbo].[pagination]
@tblName nvarchar(1000), -- ±íÃû
......
Ò».Literal Web ·þÎñÆ÷¿Ø¼þ¸ÅÊö£¨ÕªÓÚMSDN£©
¿ÉÒÔʹÓà Literal Web ·þÎñÆ÷¿Ø¼þ×÷ÎªÒ³ÃæÉÏÆäËûÄÚÈݵÄÈÝÆ÷¡£Literal ×î³£ÓÃÓÚÏòÒ³ÃæÖж¯Ì¬Ìí¼ÓÄÚÈÝ¡£
Literal ¿Ø¼þ±íʾÓÃÓÚÏòÒ³ÃæÌí¼ÓÄÚÈݵöÑ¡ÏîÖ®Ò»¡£¶ÔÓÚ¾²Ì¬ÄÚÈÝ£¬ÎÞÐèʹÓÃÈÝÆ÷£¬¿ÉÒÔ½«±ê¼Ç×÷Ϊ HTML
Ö±½ÓÌí¼Óµ½Ò³ÃæÖС£µ«ÊÇ£¬Èç¹ûÒª¶¯Ì¬Ìí¼ÓÄÚÈÝ£¬Ôò±ØÐ뽫ÄÚÈÝÌí¼ ......
Data Source=sqlservername;Initial Catalog=dbname;User ID=userid;Password=userpwd
Data Source=(local)\\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;User ID=ÕʺÅ;Password=ÕʺÅÃÜÂë
Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\ ......
ÓÃDataBinder.eval °ó¶¨Êý¾Ý²»±Ø¹ØÐÄÊý¾ÝÀ´Ô´(Dataread»òdataset)Ò²²»±Ø¹ØÐÄÊý¾ÝµÄÀàÐÍ,eval»á°ÑÕâ¸öÊý¾Ý¶ÔÏóת»»ÎªÒ»¸ö×Ö·û´®¡£Êǵײã°ó¶¨×öÁ˺ܶ๤×÷£¬Ê¹ÓÃÁË·´ÉäÐÔÄÜ¡£ÕýÒòΪʹÓ÷½±ãÁË£¬µ«È´Ó°ÏìÁËÊý¾ÝÐÔÄÜ¡£µ±Óëdataset°ó¶¨Ê±£¬DataItemÆäʵÊÇÒ»¸öDataRowView£¨Èç¹û°ó¶¨µÄÊÇÒ»¸öÊý¾Ý¶ÁÈ¡Æ÷£¨dataread£©Ëü¾ÍÊÇÒ»¸öIdat ......