查询名 :AddRow
内容 :PARAMETERS para1 Long, para2 Long, para3 Long, para4 Text ( 255 ), para5 Text ( 255 ), para6 Long;
INSERT INTO CATEGORY ( pkid, parentid, ctype, caption, sdl, root )
VALUES (para1, para2, para3, para4, para5, para6);谢谢
内容 :PARAMETERS para1 Long, para2 Long, para3 Long, para4 Text ( 255 ), para5 Text ( 255 ), para6 Long;
INSERT INTO CATEGORY ( pkid, parentid, ctype, caption, sdl, root )
VALUES (para1, para2, para3, para4, para5, para6);谢谢
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + CacheFile +";"); cnnCache = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + CacheFile);
cnnCache.Open();
string t1SQL = "create table CATEGORY (pkid integer not null primary key default 0, parentid integer default 0, ctype integer default 0, caption varchar(50) default \"\", sdl memo default \"\", root integer default 0)";
string t2SQL = @"create table TABLEINFO (PKID integer identity(1,1) primary key, DATASOURCE varchar(50), TABLENAME varchar(50), TABLECAPTION varchar(50), FIELDNAME varchar(50), FIELDCAPTION varchar(50), FIELDTYPE varchar(50), FIELDLENGTH varchar(50))";
OleDbCommand cmd = new OleDbCommand(t1SQL,cnnCache);
cmd.ExecuteNonQuery();但是和设计时存在的差别就是生成的这个没有AddRow这个追加查询