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
Ïà¹ØÎĵµ£º
ÕâÊÇÒ»¸öÓйطÖÒ³µÄʵÀý,½ö¹©²Î¿¼(´úÂëÀ´×ÔÍøÂç)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;
using System.Threading;
using System.Collections;
us ......
ÔÚ ASP ÖУ¬ÓÐÁ½¸öºÜ³£Óõļ¯ºÏ£¬Ò»¸öÊÇ Request.QueryString£¬ÁíÒ»¸öÊÇ Request.Form¡£ÕâÁ½¸ö¼¯ºÏ¿ÉÒÔ»ñÈ¡ HTML ±íµ¥(HTML Forms) Ìá½»µÄÐÅÏ¢¡£
ÓÐ¹Ø HTML ±íµ¥£¬Çë²Î¼û HTML ½Ì³ÌÖÐµÄ HTML±íµ¥ Ò»Õ¡£
Request.QueryString
HTML ±íµ¥ÖÐµÄ method ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇ get£¬ÁíÍâÒ»ÖÖÊÇ post¡£µ± HTML ±íµ¥µÄ metho ......
<%
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µ÷Óô洢¹ý³ÌµÄ·½·¨¡£
---- ¡ ......