²éѯACCESSÖзûºÏÌõ¼þ¼Ç¼µÄÓï·¨¸ñʽ
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´Å¥Ê±£©¡£
ÎÒµÄÓï¾äÈçÏ£º
string txt2 ="selcet * from Student where SutdentName='"+textBox4.Text+"'";
ÊÇÕâ¾ä³öµÄÓï·¨´íÎó£¬ÎÒ¾õµÃ¡£
ÎÒдµÄ¡°²éÕÒ¡±°´Å¥µÄ´úÂëÈçÏ£¬²»ÖªµÀÊÇ·ñÒ²ÓдíÎó£¬Çë´ó¼ÒÖ¸µã
private void button2_Click(object sender, EventArgs e)
{
if (textBox4.Text == "")
{
MessageBox.Show("ÇëÊäÈëÒª²éÕÒµÄѧÉúµÄÐÕÃû");
return;
}
string txt1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Student1.mdb";
string txt2 ="selcet * from Student where SutdentName='"+textBox4.Text+"'";
OleDbConnection conn = new OleDbConnection(txt1);
conn.Open();
DataTable dt = new DataTable();
OleDbDataAdapter dar=new OleDbDataAdapter(txt2,conn);
dar.Fill(dt);
dataGridView1.DataSource = dt.DefaultView;
}
ÎÊÌâ³ö´íÔÚÄÄÒ»¾ä£¿ÊÇ¡°conn.Open()¡±»¹ÊÇ¡°dar.Fill(dt);¡±?
ACCESSÁ¬½Ó×Ö·û´®ÓÐÎÊÌ⣬ûÓÐÖ¸¶¨Â·¾¶£¬SQLÓï¾äûʲôÎÊÌ⣬²»¹ýÕâÑùÖ±½ÓÆ´SQLÓï¾ä²»ºÃ£¬Ó¦²ÉÓô«µ
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺
ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£
ÀýÈ磺
TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D......
ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A
......