C#连接EXCEL数据库
- using System.Data.OleDb; //命名空间
- private void button1_Click(object sender, EventArgs e)
- {
- string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;
- Data Source=student.xls; Extended Properties=Excel 8.0;";
- OleDbConnection conn = new OleDbConnection(strConn)
- string sql = "select * from [student$]"; //注意EXCEL数据库表形式
- OleDbCommand cmd = new OleDbCommand(sql, conn);
- OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
- DataSet ds = new DataSet();
- oda.Fill(ds,"student");
- dataGridView1.DataSource= ds.Tables[0];
- }
============ 欢迎各位老板打赏~ ===========
与本文相关的文章
- · C#连接EXCEL数据库
- · The instance of entity type ‘Customer’ cannot be tracked because another instance with the same key value for {‘Id’} is already being tracked.
- · .NET8实时更新nginx ip地址归属地
- · 解决.NET Blazor子组件不刷新问题
- · .NET8如何在普通类库中引用 Microsoft.AspNetCore
- · .NET8 Mysql SSL error
- · ASP.NET Core MVC的Razor视图渲染中文乱码的问题
- · .NETCORE 依赖注入服务生命周期
- · asp.net zero改mysql
- · .NET5面试汇总
- · .Net连接Mysql数据库的Convert Zero Datetime日期问题
- · vue使用element-ui中的Message 、MessageBox 、Notification
