accessÊý¾Ý¿â¶ÁÈ¡Êý¾ÝÎÊÌâ
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
//²é¿´°´Å¥Ê¼þÏìÓ¦º¯Êý
protected void btnView_Click(object sender, EventArgs e)
{
this.LoadLiyYan();
}
private void LoadLiyYan()
{
//´´½¨Êý¾Ý¿âÁ¬½Ó£¬Á¬½Óµ½LiuyYan.mdb AccessÊý¾Ý¿â
OleDbConnection dbcon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "\\App_Data\\LiuYan.mdb;Persist Security Info=True");
//²éѯSQLÃüÁî
string cmdStr = "SELECT [ÁôÑÔÕß]£¬[ÁôÑÔʱ¼ä]£¬[ÁôÑÔ±êÌâ],[ÁôÑÔÄÚÈÝ] from [ÁôÑÔÐÅÏ¢]£»";
//´´½¨SQLÃüÁî
OleDbCommand cmd= new OleDbCommand(cmdStr,dbcon);
dbcon.Open();
//ÒÔDataReader·½Ê½Ö´ÐÐSQL
OleDbDataReader dr=cmd.ExecuteReader();
//Çå¿ÕÁôÑÔÏÔʾÐÅÏ¢
this.lbLiuYan.Text="";
while(dr.Read())
&n
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
Òª×ö¸öÔ¶³ÌͨÐųÌÐò,²Ù×÷accessÊý¾Ý¿â,Õâ¸ö³ÌÐòÐèÒª¶ÁȡһÌõÊý¾Ý,È»ºó½«Æäɾ³ý.ÁíÍâÒ»¸ö³ÌÐòÒ²Òª²Ù×÷ͬһ¸öaccessµÄͬһ¸ö±í,´Ë³ÌÐòÒª½øÐвåÈë²Ù×÷.Á½¸ö³ÌÐò»áͬʱ²Ù×÷Ò»¸ö±í.ÎÒÏëÖªµÀͬʱ²Ù×÷accessµÄ»°,ÄÜÐÐÂð?
......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......