Çë½Ì¹ØÓÚasp.net×Ô¶¯Éú³É±àºÅÎÊÌâ
ÎÒ×öÁ˸öÁôÑ԰壬Ìí¼Ó¼Ç¼ʱÏëÈóÌÐò×Ô¶¯Éú³ÉÒ»¸ö±àºÅ£¬ÓõÄdatareader£¬Ò²ÊµÏÖÁË¡£²»×ãÖ®´¦Êǵ±Êý¾Ý±íÀïûÓмǼʱ»á³ö´í¡£ÄÄλ´ó¸çÄܳö¸öÖ÷ÒâÔõô½â¾ö³ö´íÎÊÌ⣿·Ç³£¸Ðл
ÎҵĴúÂëÈçÏ£º
//±àºÅ×Ô¶¯ÀÛ¼Ó================
//Á¬½ÓÊý¾Ý¿â
OleDbConnection myconn = Class1.getconn();
myconn.Open();
varneirong = HtmlEncode(varneirong);
//±àºÅ×Ô¶¯ÀÛ¼Ó================
OleDbCommand cmm0 = new OleDbCommand("select bianhao from biao order by bianhao desc", myconn);
OleDbDataReader dr = cmm0.ExecuteReader();
if (dr.Read())
{
int mybianhao = Convert.ToInt16(dr["bianhao"])+1;
string varbianhao = mybianhao.ToString();
OleDbCommand cmm = new OleDbCommand("insert into biao(username,bianhao,neirong) val
Ïà¹ØÎÊ´ð£º
ÐÂÊÖÇó¾È. ÌåÁÂÇóÖªÖ®ÐÄ¡£¡£¡£Ð»Ð»£¡
asp ´úÂëÒ³Ã棺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
......
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 ......
˸øÒ»¸ö°¡£¿
google aspnetpager·ÖÒ³¿Ø¼þ
·ÖÒ³´æ´¢¹ý³Ì
aspnetpager,×Ô´øµÄ¿Ø¼þdatapager
Select TOP Ò³´óС *
from TestTable
Where (ID >
(Select MAX(id)
from (Select TOP Ò³´óС ......
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
this.Literal1.Text = "ÄúÏÖÔÚµ ......
ʹÓÃXmlNodeʱ£¬
ÓÃXmlNode.AppendChild(node);
ÈçÊǸù½áµã»áÉú³É <tag />µÄXML
ÎÒÏëÇ¿ÖÆÉú³É <tag> </tag>
Èç <tag> <t /> <tag>
Éú³É
<tag> &l ......