Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

²éѯ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Í϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

dwr Illegal access to default constructor´íÎó

dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
  <param name="formBean" value="prisonerForm"/>
  < ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......

£¨ÔÚÏߵȴý£©ListBoxÖÐÏÔʾAccessÖ¸¶¨×ֶεļǼ

±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺
ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£
ÀýÈ磺
TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D......
ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ