ACCESSÀïÃæ´´½¨´ø²ÎÊýµÄ´æ´¢¹ý³Ì
ÐèҪעÒâµÄÊÇpage_loadÀïÃæµÄ´´½¨´æ´¢¹ý³ÌÖ»ÄÜÖ´ÐÐÒ»´Î£¬Èç¹ûµÚ¶þ´Î»¹Òª´´½¨Í¬ÃûµÄ»°»áÌáʾ´íÎóÐÅÏ¢“´æ´¢¹ý³ÌÒѾ´æÔÚ¡£”£¬Æäʵ¼Ó¸öÅжϾÍÐÐÁË¡£ÀÁµÃ¼ÓÁË£¬Ö»ÊÇÓÃÀ´ÊÔÑéһϡ£
µ÷ÊÔ»·¾³ ASP.NET 2.0£¨±àÒ빤¾ßVS2008£©£¬´úÂëC#£¬access°æ±¾2003
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection oledb = new OleDbConnection();
oledb.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\asp99cms.mdb;Jet OLEDB:Database Password=";
oledb.Open();
if (oledb.State == ConnectionState.Open)
{
string str = "Create proc pr_test(@uid int) As select * from Download where [ID]=@uid";
OleDbCommand olecom = new OleDbCommand();
olecom.CommandText = str;
olecom.Connection = oledb;
olecom.ExecuteNonQuery();
oledb.Dispose();
}
oledb.Close();
oledb.Dispose();
}
protected void Button2_Click(object sender, EventArgs e)
{
OleDbConnection oledb = new OleDbConnection();
oledb.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\asp99cms.mdb;Jet OLEDB:Database Password=";
oledb.Open();
if (oledb.State == ConnectionState.Open)
{
OleDbCommand olecom = new OleDbCommand("pr_test",oledb);
olecom.CommandType = CommandType.StoredProcedure;
olecom.Parameters.Add(new OleDbParameter("@uid",OleDbType.Integer)).Value=TextBox1.Text;
olecom.Connection = oledb;
OleDbDataReader oledr;
oledr=olecom.ExecuteReader();
oledr.Read();
if (oledr.HasRows)
{
Response.Write("´æ´¢¹ý³ÌÖ´Ðгɹ¦");
}
oledr.Close();
oledr.Dispose();
oledb.Dispose();
}
oledb.Close();
oledb.Dispose();
}
Ïà¹ØÎĵµ£º
ÔÚaccessÖУ¬updateÓï¾ä²»ÄÜÓÐ×Ó²éѯµÄ£¬Èç²»ÔÊÐíÈçÏÂÓï¾ä³öÏÖ£º
UPDATE tblA SET lngID=
(SELECT lngID from tblB WHERE strName='nihao')
ÕâÑù¾ÍÐèÒªÁíÏë°ì·¨½â¾öÎÊÌâ¡£
½â¾ö·½°¸£º
A¡£
¿ÉÒÔÓÃupdateÁíÍâµÄÓï·¨½â¾ö£º
UPDATE Tab1 a,(Select ID,Name from Tab2) b
SET a.Name = ......
DELPHIÖвÙ×÷ACCESSÊý¾Ý¿â(½¨Á¢.mdbÎļþ,ѹËõÊý¾Ý¿â)
ÒÔÏ´úÂëÔÚWIN2K,D6,MDAC2.6ϲâÊÔͨ¹ý,
±àÒëºÃµÄ³ÌÐòÔÚWIN98µÚ¶þ°æÎÞACCESS»·¾³ÏÂÔËÐгɹ¦.
//ÉùÃ÷Á¬½Ó×Ö·û´®
Const
SConnectionString
= 'Provider=M ......
1¡¢VSS¿Í»§¶Ë´ò¿ª¹¤³ÌʱÌáʾ Access to file"\\***\rights.dat" denied
¸ÃÌáʾÊÇָûÓÐÍøÂç·ÃÎʵÄȨÏÞ£¬Óû§ÒªÔÚ¹²ÏíÎļþ¼ÐÓпÉдµÄȨÏ޲ſÉÒÔ¡£ÎÒÃÇÔÚÉèÖù²ÏíÎļþµÄʱºòÓ¦¸ÃÔÊÐíдÈë¡£
2¡¢ÎªVSSÉèÖû·¾³±äÁ¿
ĬÈÏÇé¿öÏÂÎÒÃÇÿ´Î´ò¿ªVSS¿Í»§¶ËÌî³äµÄÓû§Ãû¶¼Êǵ±Ç°ÏµÍ³µÇ½µÄÓû§£¬ÕâÑùʹÓÃÆðÀ´ºÜ²»·½±ã¡£Î ......
ÔÒò£ºIISûÓÐ×¢²á,ÎÒÊÇÔÓÐϵͳµÄIISɾÁË,Ôì³ÉÔËÐÐIISÖеÄÓ¦ÓóÌÐò³öÏÖÕâÖÖ´íÎó!
½â¾ö°ì·¨:
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ±Ç°Óû§£©
2¡¢aspnet_regiis -i £¨×¢²áIIS£©
3¡¢iisreset /noforce £¨ÖØÆôIIS£©
......
----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......