1 / 4
文档名称:

ACCESS中使用存储过程.doc

格式:doc   页数:4页
下载后只包含 1 个 DOC 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

分享

预览

ACCESS中使用存储过程.doc

上传人:wc69885 2016/2/27 文件大小:0 KB

下载得到文件列表

ACCESS中使用存储过程.doc

文档介绍

文档介绍:???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