Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ACCESSµÄ´æ´¢¹ý³Ì´´½¨ÓëÖ´Ðд´½¨


ACCESSµÄ´æ´¢¹ý³Ì´´½¨ÓëÖ´ÐÐ
´´½¨£º
ÔÚAccess×ÔÉíµÄ°ïÖúÖп´µ½ÁËCreate ProcedureÓï¾ä¡£
²âÊÔÁËÀϰëÌ죬ÖÕÓÚ·¢ÏÖÁ˾÷ÇÏ£º
±ØÐëʹÓÃOleDbÁ¬½Ó²ÅÄÜʹÓÃCreate ProcedureÓï¾ä¡£
ODBCÁ¬½Ó²»Ö§³Ö¸ÃÓï¾ä£¬ÌáʾCreate TableÓï·¨´íÎó¡£
´´½¨ÁË´æ´¢¹ý³Ìºó£¬Ê¹ÓÃOffice Access¹¤¾ß´ò¿ªÊý¾Ý¿â£¬ÔÚ“¶ÔÏó - ²éѯ”ÖÐÄܹ»¿´µ½Äã´´½¨µÄ´æ´¢¹ý³Ì¡£
´´½¨´æ´¢¹ý³ÌµÄÓï·¨£º
CODE
Create Procedure YourProc
(
@param1 varchar(254),
@param2 int
)
As
(
select * from Table1 where ID>@param2 and username=@param1
)
²éѯÊý¾ÝʱֻÐèҪʹÓãº
Rs.Open "YourProc ²ÎÊý1,²ÎÊý2,²ÎÊý3", Conn
        »òÕß
        Conn.Execute("exec YourProc ²ÎÊý1,²ÎÊý2,²ÎÊý3")
µÚ¶þ¸öÀý×Ó:
Ö±½ÓÔÚ¿âÀï´´½¨£¬²Î¿¼£º
//**************************************************************
// Stored Procedure ListBySubject_Sample
// CREATE procedure ListBySubject_Sample
// (
// @SubjectID Integer
// )
// AS
// SELECT top 5 BookID, BookTitle, Author, Price, Retail
// from Products
// where SubjectID = @SubjectID
// RETURN
//
// GO
//**************************************************************
SqlDataReader GetSpecials_Procedure(SqlConnection currentConnection)
{
SqlDataReader myDataReader;
Object my_DBNull;
try {
my_DBNull = Convert.DBNull;
SqlDataReader myReader;
int subjectidin = 21;
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = currentConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.CommandText = "LISTBYSUBJECT_SAMPLE";
myCommand.Parameters.Add(new SqlParameter("@SubjectID",
SqlDbType.Int, 4, ParameterDirection.Input,     
ÔÚAccess×ÔÉíµÄ°ïÖúÖп´µ½ÁËCreate ProcedureÓï¾ä¡£
²âÊÔÁËÀϰëÌ죬ÖÕÓÚ·¢ÏÖÁ˾÷ÇÏ£º
±ØÐëʹÓÃOleDbÁ¬½Ó²ÅÄÜʹÓÃCreate ProcedureÓï¾ä¡£
ODBCÁ¬½Ó²»Ö§³Ö¸ÃÓï¾ä£¬ÌáʾCreate TableÓï·¨´íÎó¡£
´´½¨ÁË´æ´¢¹ý³Ìºó£¬Ê¹ÓÃOffice Access¹¤¾ß´ò¿ªÊý¾Ý¿â£¬ÔÚ“¶ÔÏó - ²éѯ”ÖÐÄܹ»¿´µ½Äã´´½¨µÄ´æ´¢¹ý³Ì¡£
´´½¨´æ´¢¹ý³ÌµÄÓï·¨£º
CODE


Ïà¹ØÎĵµ£º

ÈçºÎ½« Access Êý¾Ý¿âת»»µ½ SQL Server

http://support.microsoft.com/default.aspx/kb/237980/zh-cn
½« Access Êý¾Ý¿âת»»Îª SQL Server µÄ×î¼ò±ã·½·¨ÊÇʹÓÃÉýǨÏòµ¼¡£ÉýǨÏòµ¼£º
±£ÁôÊý¾Ý¿â½á¹¹£¬°üÀ¨Êý¾Ý¡¢Ë÷ÒýºÍĬÈÏÉèÖá£
×Ô¶¯½« Access ÓÐЧÐÔ¹æÔòºÍĬÈÏÉèÖÃת»»ÎªÊʵ±µÄ SQL Server µÈЧÄÚÈÝ¡£
ÔÚÉýǨºó±£³Ö±í¹ØÏµºÍ²ÎÕÕÍêÕûÐÔ¡£
ÒªÔÚ Access 2000 ......

ÈçºÎÁ¬½ÓaccessÊý¾Ý¿â²»ÓÃODBC

ÓÐÈýÖÖ°ì·¨    
  µÚÒ»ÖÖÊÇÓÃaccessµÄJDBCÇý¶¯³ÌÐò£¬µ½http://industry.java.sun.com/products/jdbc/driversÕâ¸öÍøÕ¾ÉϲéÕÒ²¢ÏÂÔÚaccessµÄjdbcÇý¶¯³ÌÐò¡£    
  µÚ¶þ¸ö°ì·¨ÊÇÄãÓÃÏÂÃæµÄ´úÂëÊÔÊÔ    
  con   =   DriverManager.getConnection("jdbc:odbc:Dri ......

MS AccessÓï·¨´íÎóÐÅÏ¢

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 ......

AccessÊý¾Ý¿â°²È«ÉèÖü¼ÇÉ

²¿·ÖÂÛ̳ÐÂÊÖÃÇû¾¯Ìè×Ô¼ºÂÛ̳Êý¾Ý¿â´æÔÚµÄΣÏÕ£¬ËùÒÔ»¹ÊÇ ¾ö¶¨ÒÔDvbbs7.0ΪÀý£¬½éÉÜÒ»ÏÂÈçºÎ±£»¤ºÃÄãµÄAccessÊý¾Ý¿â ¡£Ïл°ÐÝ˵£¬ÇëÍùÏ¿´£º
1¡¢¸øÄãµÄAccessÊý¾Ý¿â¼ÓÉÏÃÜÂë±£»¤£¨ÆäʵAccessÊý¾Ý¿â µÄÃÜÂë±£»¤·Ç³£´àÈõ£¬ÕâÀֻÊǸøËû¶à¼ÓÉÏÒ»°ÑËø¶øÒÑ£©¡£
a.´ò¿ªMicroSoft AccessÈí¼þ£¬ÊÇÓöÀÕ¼·½Ê½´ò¿ªÄãµÄDVÂÛ Ì³Êý¾ ......

C# ´´½¨AccessÊý¾Ý¿â±í

using System;
using System.IO;
using System.Windows.Forms;
using Access = Microsoft.Office.Interop.Access;
// Ìí¼ÓÒýÓÃ->.NET-> dao£¬Microsoft.Office.Interop.Access
namespace WinFormAccess
{
    public partial class FormAccess : Form
    {
  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ