ASP.NETÊý¾Ý²åÈëÓë¸üУ¡
dsQuyMst.Tables["QuyMst"].Rows[0]["SHDOCO"] = "1111";//Õâ¾ä±¨´í£¨Î´½«¶ÔÏóÒýÓÃÉèÖõ½¶ÔÏóµÄʵÀý¡££©
ÕâÖªµÀÊÇʲôÔÒò£¿
¸ßÈËÖ¸µã~~~
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Generic;
public partial class P81001A : System.Web.UI.Page
{
DataSet dsQuyMst;
// SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
LoadData();
}
//Menu1_MenuItemClick(object,e);
//DropDownList1_SelectedIndexChanged(object,e);
}
private void LoadData()
{
DataSet ds = new DataSet();//
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnectionStr();
con.Open();
string strsql = "select SHTYPENO,SHTYPENAME from f81101";
SqlCommand sqlcmd = new SqlCommand(strsql, con);
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
֮ǰÓöµ½Ò»¸öÎÊÌâ¡£
ÓÚÊÇ×öÁËÒÔÏÂʵÑ飺
Ò³Ãæ¼ÓÔØºó£¬Ìá½»Ò»¸öAjaxÇëÇó(ÔݳÆÎªajax1)£¬ÇëÇóµÄÏß³ÌÔÚ·þÎñÆ÷Éϱ»Ë¯Ãß10ÃëÖÓ¡£
µã»÷Ò³ÃæÉÏÒ»¸öbutton£¬´¥·¢ÁíÒ»¸öAjaxÇëÇó(ajax2)¡£
µ±Ã»ÓÐʹÓÃsession£¬ÔÚ·þÎñÆ÷δ´ ......
ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£
лл
´úÂëÈçÏ£º
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
u ......
ÎÒÊÇÓÃAspNetPagerÀàÍê³ÉµÄ ¿ÉÊÇÏëʵÏÖ°´Ê±¼ä˳ÐòÅÅÁÐ.
ÎÒÊÇÓÃlimit×öµÄ²éѯID×ÜÊý¸øAspNetPager
È»ºóÈÃËûÉú³ÉÒ³Êý.
select * from bbs limit 0,10 GROUP BY Mate
ÕâôÏÂÈ¥µÄ¿ÉÊÇ,ÎÒ²»Äܽâ¾ö°´Ê±¼äÅÅÐò,ÐÂÌù²»ÔÚ ......