C#连接acess数据库（初级）

最新推荐文章于 2022-06-24 09:19:11 发布

咖啡色的浪漫

最新推荐文章于 2022-06-24 09:19:11 发布

阅读量1.2k

点赞数

分类专栏： c#学习文章标签：数据库 c# button object

本文链接：https://blog.csdn.net/micel108/article/details/1503251

版权

c#学习专栏收录该内容

7 篇文章 0 订阅

订阅专栏

name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-3528650120430763&dt=1183890684015&lmt=1183890684&format=468x60_as&output=html&correlator=1183890684000&url=http%3A%2F%2Fgmai9999.googlepages.com%2Fhome&ad_type=text_image&ui=rc%3A0&cc=100&flash=9&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_java=true" frameborder="0" width="468" scrolling="no" height="60" allowtransparency="allowtransparency">
private void button1_Click(object sender, System.EventArgs e)
  {
   System.Data.OleDb.OleDbConnection dbcon;
   System.Data.OleDb.OleDbCommand dbcmd;
   System.Data.OleDb.OleDbDataReader dbread;
            System.String strpath ;
   strpath=Application.StartupPath;
   strpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +strpath+"//my.mdb";

dbcon=new OleDbConnection(strpath);
dbcon.Open();

   dbcmd = new OleDbCommand("select * from meter ");
   dbcmd.Connection=dbcon;
   dbcmd.CommandText="Select * from meter ";
   dbread=dbcmd.ExecuteReader();

   while(dbread.Read())
   {
     this.listBox1.Items.Add(dbread["Meter_ID"]);
   }
    this.listBox1.SelectionMode=SelectionMode.One;
   this.label1.Text = this.listBox1.Items.Count.ToString();
  }
name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-3528650120430763&dt=1183890684015&lmt=1183890684&format=468x60_as&output=html&correlator=1183890684000&url=http%3A%2F%2Fgmai9999.googlepages.com%2Fhome&ad_type=text_image&ui=rc%3A0&cc=100&flash=9&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_java=true" frameborder="0" width="468" scrolling="no" height="60" allowtransparency="allowtransparency">