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

ÔõÑùÁ¬Ðø¶à´Î¶ÁÈ¡accessÖÐͬһ×ֶεÄÊý¾Ý

ÔõÑù²ÅÄܶÔaccessÊý¾Ý¿â±íÖÐͬһ×ֶεÄÊý¾ÝÁ¬Ðø¶ÁÈ¡Á½´ÎÒÔÉÏ£¬ÀýÈ磺
<td> <%=rs.getObject(1)%> </td> 
<td> <%=rs.getObject(1)%> </td>
ΪʲôÔÚSQL ServerÖоÍûÎÊÌ⣬¶øÔÚaccessÖÐÈ´²»ÐУ¬×ÜÊDZ¨´í£¬´úÂë¶¼ÊÇÍêȫһÑùµÄ¡£
ΪʲôҪÕâô×öÄØ£¿Äã¿ÉÒÔÏȶ¨Òå¸ö±äÁ¿È¡³öÀ´ÏÂÃæÔÙµÈÓÚ°¡¡£
accessÊÇÕâÑù£¬ºÜ¶à벡µÄ£¬ÓÃß·group byºó£¬rs.last().getRow()µÃµ½µÄ×ܼǼÊý²»¶ÔµÄ¡£

ÎÒÖ÷ÒªÏëʵÏÖ¼òµ¥µÄÁ´½ÓÐÞ¸Äɾ³ý¹¦ÄÜ£¬Ö÷Òª´úÂëÈçÏ£º
<%
String   sql;
String   url;
Connection   conn;
Statement   stmt;
ResultSet   rs;
%>
<table   align= "center "   border= "1px ">
<tr>
<td   width= "14% "   align= "center "> ѧºÅ </td>
<td   width= "14% "   align= "center "> ÐÕÃû </td>
<td   width= "14% "   align= "center "> ÄêÁä </td>
<td   width= "14% "   align= "center "> ÐÔ±ð </td>
<td   width= "16% "   align= "center "> Ժϵ </td>
</tr>
<%

try{
url   =   "jdbc:odbc:MyStudents ";
sql   =   "select   *   from   MyStudents "; <


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......

Vb.net Access CrystalReport - .NET¼¼Êõ / VB.NET

µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......

¹ØÓÚVB.NETºÍMS ACCESSµÄÎÊÌâ

ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......

ÇóÈ«¹úÊ¡·ÝACCESSÊý¾Ý¿â,Ҫȫ³Æ

ÈçÌâ,Ê¡·ÝÒªÇóÈ«³Æ
????????

ÕÒ IP¿â

Áô¸öÓÊÏ䏸ÎÒ£¬ÎÒ·¢¸øÄã


²éGB/T2260 2007 ×Ô¼ºÕûÀíÒ»ÏÂ

²»¶®É¶Òâ˼Ү£¡

http://www.popub.net/script/pcasunzip.html

Â¥ÉϸøµÄµØÖ·,¿É²»ÄÜÏÂÔØ°¡.

Òý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ