²éѯ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Óï¾ä²»ºÃ£¬Ó¦²ÉÓô«µ
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......