¹ØÓÚÊý¾Ý¿âдÈëÇóÖú!
(1)´úÂë
<%string pn,bq,pp,cname,ctel,fax,add,person,tel,email;
pn=Request.Form["textBox2"];
bq=Request.Form["textBox3"];
pp=Request.Form["textBox4"];
cname=Request.Form["textBox5"];
ctel=Request.Form["textBox6"];
fax=Request.Form["textBox7"];
add=Request.Form["textBox8"];
person=Request.Form["textBox9"];
tel=Request.Form["textBox10"];
email=Request.Form["textBox11"];
Set cn=Server.CreateObject("adodb.connection");
strDbPathAndName=Server.MapPath("@zefa.mdb");
strCon="DRIVER={Microsoft Access Driver(*.mdb)};DBQ="&strDbPathAndName;
cn.connectionString = strCon;
cn.Open;
[color=#FF0000 cn.Execute "insert into tb_hubM(name,query,price,cusname,telphone,cusfax,cadd,cperson,mbtel,mail)values(@pn,@bq,@pp,@cname,@ctel,@fax,@add,@person,@tel,@email)";][/color]
Response.Write("ÄãÒѾ³É¹¦°Ñ²úÆ·´æÈëÁË Êý¾Ý¿â!");
cn.Close;
cn= null;%>
ÓÐÎÊÌâµÄ´úÂëÒѾ¼ÓÈëÉ«²Ê£¬Ìáʾ£º*.aspx(199,17): error CS1002: Ó¦ÊäÈë ;
(2)ÎҵIJÙ×÷ϵͳÊÇwindows server 2003,framwork2.0 ,iis6.0,Êý¾Ý·ÃÎÊ×é¼þMDAC2.82Óë±¾²Ù×÷ϵͳ¼æÈÝ£¬MDAC×é¼þÖе
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......