C#ʵÏÖÏóASPÖеÄÊý¾ÝÌí¼Ó
ÎÒÏëÓÃC#ʵÏÖÏóASPÖеÄ
rs.addnew
rs( "a ") = "aaa "
rs( "b ") = 123
rs.update
ÕâÑù·½·¨Ìí¼ÓÊý¾Ý£¬ÎÊһϣ¬ÒªÔõô×ö°¡£¿
¾ßÌå·½·¨ÈçÏÂ
string dbPath = "../App_data/WebSeven.mdb ";
string db = Server.MapPath(dbPath);
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + db;
string strSQL = "SELECT [Svn_title],Svn_Content from [Svn_Product] ";
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "List ");
//¼Ç¼µÄ¸üÐÂ
// DataRow dr = ds.Tables[ "List "].Rows[1];
//
// dr.BeginEdit();
// dr[ "CustomerID "] = "******** ";
// dr[ "Address "] = "------ ";
&nbs
Ïà¹ØÎĵµ£º
ÏÂÃæÊÇcommond:
MySQLCommand cmd;
cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
ÏÂÃæÊÇinsert:
string Value = "Value";
int SettingID = 1;
new MySQLInsertCommand(conn,
new object[,] {{"SettingID",SettingID},{"S ......
<%
if Request.QueryString("pageNo")="" then
PageNo=1
elseif IsNumeric(Request.QueryString("pageNo"))=false then
PageNo=1
else
PageNo=clng(Request.QueryString("pageNo"))
end if
´ò¿ªÊý¾Ý±í..²»Ð´Á˹þ.
set rs=server.CreateObject("adodb.recordset")
sql="............"
rs.open sql, ......
1 Ä¿µÄ
2 ·¶Î§
3 ×¢Ê͹淶
3.1 ¸ÅÊö
3.2 ×Ô½¨´úÂëÎļþ×¢ÊÍ
3.3 Ä£¿é£¨ÀࣩעÊÍ
3.4 ÀàÊôÐÔ×¢ÊÍ
3.5 ·½·¨×¢ÊÍ
3.6 ´úÂë¼ä×¢ÊÍ
4   ......
ASPµ÷Óô洢¹ý³ÌµÄ·½·¨£º
---- ¡¡¡¡µ÷Óô洢¹ý³ÌµÄ·½·¨ÐèҪʹÓÃADOµÄCommand¶ÔÏó¡£Command¶ÔÏóÊǶÔÒ»¸öÊý¾ÝÔ´ÔËÐÐÌض¨ÃüÁîµÄ¶¨Ò壨ÀýÈ磬һ¸öSQL²éѯ»òÒ»¸öSQL´æ´¢¹ý³Ì£©¡£ÏÂÃæÒÔMS SQL SERVER6.5Ϊºǫ́Êý¾Ý¿â£¬½éÉÜASPµ÷Óô洢¹ý³ÌµÄ·½·¨¡£
---- ¡ ......
asp³£ÓõÄÕýÔò±í´ïʽʵÏÖ×Ö·û´®µÄÌæ»»,Ö÷Òª°üÀ¨È¥³ýhtml±êÇ©£¬È¥³ýclass±êÇ©ºÍÈ¥³ýscript±êÇ©µÈ
È¥³ýhtml±êÇ©ÕýÔò<\/*[^<>]*>
Function LoseHtml(ContentStr)
Dim ClsTempLoseStr,RegEx
ClsTempLoseStr = Cstr(ContentStr)
Set RegEx = New RegExp
RegEx.Pattern = "<\/*[^<>]*>"
......