C#ÖÐÁ¬½Ó¼°²éѯAccess³öÏÖµÄÎÊÌâ
´óÏÀÃÇ£º
ÕâÊÇÎÒÁ¬½ÓÊý¾Ý¿âµÄ´úÂë
string strPath = Application.StartupPath + "\\Database.accdb";
string ConStr = "provider=Microsoft.jet.oledb.4.0;Data source=" + strPath;
OleDbConnection Olecon = new OleDbConnection(ConStr);
Olecon.Open();
string sql = "Select * from ѧÉúÐÅÏ¢ where ѧºÅ= '" + textBox1.Text.Trim() + "' ";
OleDbDataAdapter da = new OleDbDataAdapter(sql, Olecon);
DataSet ds = new DataSet();
da.Fill(ds, "ѧÉúÐÅÏ¢");
this.dataGridView1.DataSource = ds.Tables[0];
±¨´í£º
{"ÕÒ²»µ½Îļþ 'E:\\Êý¾Ý¿â»ù±¾²Ù×÷\\Êý¾Ý¿â»ù±¾²Ù×÷\\bin\\Debug\\Database.accdb'¡£"}
ʲôÔÒòÄØ¡¡
C# code:
@'E:\Êý¾Ý¿â»ù±¾²Ù×÷\Êý¾Ý¿â»ù±¾²Ù×÷\bin\Debug\Database.accdb'
??
ÄDz»ÊÇ˵ÁËÂð ÕÒ²»µ½Îļþ ÄãÄǸö·¾¶ÏÂÓÐÕâ¸öÎļþÂð£¿
C# code
Code highlighting produced by
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÎÒÏë°Ñ´¿Õæip¿âµ¼³öµ½sqlserver£¬ÎÒÓÃϱߵĽéÉÜ·½·¨£¬£¨ËüÖ÷ÒªÊǵ¥¸öIP²éѯµÄ£©
http://www.cnblogs.com/njnudt/archive/2007/04/08/704524.html
¸ÄÁËÒ»ÏÂÄܹ»µÃµ½ËùÓеĹú¼ÒºÍµØÇøÐÅÏ¢£¬µ«ÊDz»Äܵõ½ipµØÖ·µ ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......