c#.netÓëAccess
¸÷λÅóÓÑ£¬´ó¼ÒºÃ£º
ÏÖÔÚÎÒÓÐÒ»¸öc#.netÓëAccessµÄÎÊÌ⣬Çë´ó¼Ò°ïæ½â¾ö£¡
ÏÖÔÚÎÒÔÚFORM±íµ¥ÖмÓÈëÁËÒ»¸öDATAGRIDVIEW£¬ÃüÃûΪdgv1 £¬ÏÖÔÚÏ뽫AccessÖеÄÊý¾Ýµ÷Èëµ½±íµ¥ÖУ¬ÔõÑùʵÏÖ¡£
ÀýÈ磺ÏÖÔÚÓÐÈçϵÄcy.mdb,ÆäÖеÄÒ»¸ö±íÃûΪcyn,Êý¾ÝÈçÏ£º
ID NAME AGE
01 AA 26
02 BB 25
03 CC 25
select id,name from cyn where id < 3;
ÏÖÔÚÏ뽫Õâ¸ö±íÖзûºÏÌõ¼þµÄÐÅÏ¢ÏÔʾÔÚdgv1ÖУ¬²»ÖªµÀÈçºÎʵÏÖ£¬ÊÇ·ñ¿ÉÒÔÌõÓÃdataTable,Çë´ó¼Ò°ïÖú½â¾ö
C# code:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/db.mdb"));
DataSet dt = new DataSet();
conn.Open();
OleDbDataAdapter ShowAdapter = new OleDbDataAdapter("select id,name from cyn where id < 3", conn);
ShowAdapter.Fill(dt);
conn.Close();
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
½«GridView1»»³Édgv1
´ò¿ªdatagridviewÊôÐÔ±í °Ñ Êý¾Ý°ó¶¨µ½datagridview¶¨ÒåµÄÁÐÖÐ ÆäËûµÄ¾ÍÊÇÂ¥ÉϵÄÁË
ÓÃsqldatasource°É£¬ºÜ¼òµ¥µÄ£¬
°ÑdatagridviewµÄdatasourceÉèÖóÉsqldatasource¼´¿É
Ïà¹ØÎÊ´ð£º
Public Shared Function GetCachedObject(Of TObject)(ByVal cacheItemArgs As CacheItemArgs, ByVal cacheItemExpired As CacheItemExpiredCallback) As TObject
Ret ......
ÇëÎÊ£¬ÎÒ°²×°Ê±Ó¦¸ÃÑ¡ÄÄЩ×é¼þ£¿
Õâ¸öûÑо¿£¬ÎÒÒÔǰÊÇÖ±½ÓÔÚÓïÑÔÑ¡ÏîÄÇÀïÈ¡Ïûµô²»ÓõÄÓïÑÔ¡£¡£
°²×°µÄʱºòÑ¡Ôñ×Ô¶¨Òå×é¼þ,²»Òª¹´Ñ¡VB C#¾Í¿ÉÒÔÁ˰¡
right
°²×°Ê±Ñ¡Ôñ×Ô¶¨Ò壬½«VB£¬C#µÄÑ¡ÖÐÈ¥³ý
Áô¸öÓ ......
VB´úÂ룺
Loop Until k = 3 Or UBound(datavalue) > 11
»úÆ÷ÈËת¹ýÀ´µÄC#´úÂ룺
while (!(k == 3 | Information.UBound(datavalue) > 11));
ÎÊÌâÊÇ£ºµ÷ÊÔµÄʱºò³öÏÖ¡°¡°UBound¡± ......
ÎÒÈç¹ûÏÈÒª¶Ô±íÖÐXH×Ö¶Î×öÒ»ÏÂÅжÏ,È»ºóдһ¸öÎÂܰµÄ¶Ô»°¿òÌáʾÓû§XH×Ö¶ÎֵΪ0£¬ÄÇ×Ö¶ÎXH¸ÃÔõôȡ³öÀ´ÄØ? ´ó¼Ò°ïæ¿´¿´£¡ ллÁË£¬Ô´´úÂëÈçÏ£¬Êý¾Ý¿âÒÑÁ¬½Ó
C# code:
OleDbConnection conn = new OleDbConn ......