accessÁ¬½Ó×Ö·û´®ÎÊÌâ
¿É²»¿ÉÒÔ°ÑaccessÁ¬½Ó×Ö·û´®Ð´½øÒ»¸öÀàÖУ¬È»ºóÒªÓõÄʱºòµ÷ÓÃ
¾ÍÏñSQLÄÇÑùÑù£º
using System.Data.SqlClient;
public class DBHelper
{
public DBHelper()
{
}
public static SqlConnction Create()
{return new SqlConnection("server=.;uid=sa;pwd=;database=xxx.mdf");}
}
µ÷ÓõÄʱºòÖ±½ÓSqlConnetion conn=DBhelper.Create();
Èç¹ûÊÇACCESSµÄ»°ÔõôҲ£¬ÎÒÏñÕâÑùÊÔ¹ý£¬Ìáʾ¡°ÉÏÏÂÎÄÖв»´æÔÚserver¡±accessÏà¶Ô·¾¶ÓÃServer.MaPpath()
¿ÉÄܵģ¬ÄãÒ²¿ÉÒÔÓö¯ÈíµÄ´úÂëÉú³ÉÆ÷À´ÊµÏÖ¡£×Ô¶¯Éú³É¡£
private string _strConn;
private string strConnection
{
get {
if( _strConn==null )
_strConn ="Provider=Microsoft.Jet.OleDb.4.0; data source=" + Server.MapPath(".")+"\\dbWebIS.mdb";
return _strConn;
}
}
connectionstring.com
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data
Ïà¹ØÎÊ´ð£º
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......