asp.netÔõôÁ¬½Ó access??¿ñÉ¢·Ö
ÎÒÏ£ÍûÓиßÈËÄܰïÎÒ½â¾öÕâ¸öСÎÊÌâ...×îºÃÄܸøÎÒÒ»¸öС°¸Àý¿´¿´..ÎÒµÄÓÊÏäÊÇ wuyeboyingying@163.com..
<appSettings>
<add key="SQLConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/mydata.mdb"/>
</appSettings>
public static readonly string strConn = System.Configuration.ConfigurationManager.AppSettings["SQLConnString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
//using System.Data.OleDb;
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\\studentinfo.mdb");
conn.Open();
string sqlstr = "select * from basic_info";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "basic_info");
&nb
Ïà¹ØÎÊ´ð£º
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 ......
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÎÒÅóÓѵÄÒ»¸öASP.NETÒýÓÃÁËajax¼¼Êõ£¬binĿ¼ÏÂÃæÒ²ÓÐajaxpro.dll£¬ÎªÊ²Ã´·þÎñÆ÷²»ÐèÒª°²×°ajax²å¼þÒ²¿ÉÒÔÔËÐÐÄØ£¬ÕÕÀí˵Ӧ¸ÃÒª°²×°ASPAJAXExtSetup.msi
ÓÐ ajaxpro.dll¾Í¿ÉÒÔÁË
²»Í¬µÄaajx×é¼þ
AjaxPro¾ÍÊÇ¿ò¼ ......