文档介绍:???jetsql?ddl????????????Access???DataDefinitionLanguage(DDL)????????????????????DAO????????????DDL?CreateTable?????Table1????????????????????10??????CreateTABLETable1(IdCOUNTERCONSTRAINTPrimaryKeyPRIMARYKEY,MyTextTEXT(10))????????????Table2???id???????MyText???CreateTABLETable2(IdLONG,MyTextTEXT)???????Table1?Table2???????AlterTABLETable2ADDCONSTRAINTRelation1FOREIGNKEY([Id])REFERENCESTable1([Id])??????????AlterTABLETable2DropCONSTRAINTRelation1??Table1??????DropTABLETable1??:1.??Users?createtableUsers(UidcounterconstraintprimaryKeyprimarykey,Unamevarchar(20)notnull,Upasswordvarchar(20)notnull,Udatedatetime)2.????3.????????SELECT*FROMUsersWHEREUname=p_unameandUpassword=p_upassword;???ACCESS????????p_upassword??ACCESS?????????,??????????,???????.C#.cs??//???????????(?????????????)if(().Length>0&&().Length>0){stringconnStr="Provider=;DataSource="+()+"\\App_Data\\";using(OleDbConnectionconn=newOleDbConnection(connStr)){//创建命令对象stringsqlInsert="Procedure_InsertUser";mandcmd=mand(sqlInsert,conn);//创建并添加参数OleDbParameterparName=newOleDbParameter("***@name",);=();OleDbParameterparPassword=newOleDbParameter("***@password",);=tx