ÔõÑùÁ¬Ðø¶à´Î¶ÁÈ¡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 "; <
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
ÈçÌâ,Ê¡·ÝÒªÇóÈ«³Æ
????????
ÕÒ IP¿â
Áô¸öÓÊÏ䏸ÎÒ£¬ÎÒ·¢¸øÄã
²éGB/T2260 2007 ×Ô¼ºÕûÀíÒ»ÏÂ
²»¶®É¶Òâ˼Ү£¡
http://www.popub.net/script/pcasunzip.html
Â¥ÉϸøµÄµØÖ·,¿É²»ÄÜÏÂÔØ°¡.
Òý ......