c# 连接ACCESS 数据库 OleDbCommand OleDbDataReader

大家好，又见面了，我是你们的朋友全栈君。 private void button1_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(“Provider = Microsoft.Jet.OLEDB.4.0;Data Source = fruit.mdb”); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = “select * from fruit”; conn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); if (dr.HasRows) { for(int i=0; i<dr.FieldCount; i++) { dt.Columns.Add(dr.GetName(i)); } dt.Rows.Clear(); } while(dr.Read()) { DataRow row = dt.NewRow(); for(int i=0; i<dr.FieldCount;i++) { row[i] = dr[i]; } dt.Rows.Add(row); } cmd.Dispose(); conn.Close(); dataGridView1.DataSource = dt; } } }

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/144348.html原文链接：https://javaforall.cn