c#²Ù×÷access*×ªÔØ
public static class AccessHelper
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®
//WebForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//WinForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
//public static readonly string conn_str = System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString + ";Persist Security Info=True";
// ÓÃÓÚ»º´æ²ÎÊýµÄHASH±í
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
/// <summary>
/// ¸ø¶¨Á¬½ÓµÄÊý¾Ý¿âÓüÙÉè²ÎÊýÖ´ÐÐÒ»¸ösqlÃüÁ²»·µ»ØÊý¾Ý¼¯£©
/// </summary>
/// <param name="connectionString">Ò»¸öÓÐЧµÄÁ¬½Ó×Ö·û´®</param>
/// <param name="commandText">´æ´¢¹ý³ÌÃû³Æ»òÕßsqlÃüÁîÓï¾ä</param>
/// <param name="commandParameters">Ö´ÐÐÃüÁîËùÓòÎÊýµÄ¼¯ºÏ</param>
/// <returns>Ö´ÐÐÃüÁîËùÓ°ÏìµÄÐÐÊý</returns>
public static int ExecuteNonQuery(string connectionString, string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
Ïà¹ØÎĵµ£º
http://support.microsoft.com/default.aspx/kb/237980/zh-cn
½« Access Êý¾Ý¿âת»»Îª SQL Server µÄ×î¼ò±ã·½·¨ÊÇʹÓÃÉýǨÏòµ¼¡£ÉýǨÏòµ¼£º
±£ÁôÊý¾Ý¿â½á¹¹£¬°üÀ¨Êý¾Ý¡¢Ë÷ÒýºÍĬÈÏÉèÖá£
×Ô¶¯½« Access ÓÐЧÐÔ¹æÔòºÍĬÈÏÉèÖÃת»»ÎªÊʵ±µÄ SQL Server µÈЧÄÚÈÝ¡£
ÔÚÉýǨºó±£³Ö±í¹ØÏµºÍ²ÎÕÕÍêÕûÐÔ¡£
ÒªÔÚ Access 2000 ......
Microsoft JET Database Engine error '80004005'
Selected collating sequence not supported by the operating system.
ÊÇÒòΪ¹úÍâµÄÖ÷»ú²»Ö§³ÖMDBÎļþĬÈϵĺºÓïÆ´ÒôÅÅÐò·½Ê½
Ö»Òª°ÑÅÅÐò¸ÄΪ³£¹æ,ÈçÏÂͼ:
È»ºóÒÀ´Îµã»÷ ¹¤¾ß -> Êý¾Ý¿â³£Óù¤¾ß -> ѹËõºÍÐÞ¸´Êý¾Ý¿â
Ó¦¸Ã¾Í¿ÉÒÔÕý³£Ê¹ÓÃÁË.
ÉÏÎÄÀ´Ô´ÓÚ KinJ ......
1.Response.Redirect("http://www.jb51.net",false);
Ä¿±êÒ³ÃæºÍÔÒ³Ãæ¿ÉÒÔÔÚ2¸ö·þÎñÆ÷ÉÏ£¬¿ÉÊäÈëÍøÖ·»òÏà¶Ô·¾¶¡£ºóÃæµÄboolֵΪÊÇ·ñÍ£Ö¹Ö´Ðе±Ç°Ò³¡£
Ìø×ªÏòеÄÒ³Ãæ£¬Ô´°¿Ú±»´úÌæ¡£"
ä¯ÀÀÆ÷ÖеÄURLΪз¾¶¡£
:Response.Redirect·½·¨µ¼ÖÂä¯ÀÀÆ÷Á´½Óµ½Ò»¸öÖ¸¶¨µÄURL¡£µ±Response.Redirect()·½·¨± ......
MS AccessÓï·¨´íÎóÐÅÏ¢
This short article deals with the following common MS Access-related error messages:
Syntax error (missing operator) in query expression 'field='some_partial_string'
Syntax error in INSERT INTO statement
Syntax error in UPDATE statement
Syntax error in from clause
Sy ......
Microsoft Jet OLE DB 4.0
Standard security:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
With database password:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;
Workgroup (system database):
Prov ......