如何使用 ASP.NET、ADO.NET 和 Visual C# .NET 查询和显示 Excel 数据

最新推荐文章于 2025-05-13 15:25:46 发布

weixin_34112181

最新推荐文章于 2025-05-13 15:25:46 发布

阅读量62

点赞数

本文介绍了一种使用ADO.NET Ole DB Provider从Excel文件读取数据并将其显示在ASP.NET DataGrid控件中的方法。具体步骤包括创建连接字符串、打开数据库连接、执行SQL SELECT命令获取工作表数据、填充DataSet以及绑定数据到DataGrid。

http://support.microsoft.com/kb/306572/zh-cn

Page_Load 事件中：

// Create connection string variable. Modify the "Data Source"
// parameter as appropriate for your environment.
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
	"Data Source=" + Server.MapPath("../ExcelData.xls") + ";" +
	"Extended Properties=Excel 8.0;";

// Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(sConnectionString);

// Open connection with the database.
objConn.Open();

// The code to follow uses a SQL SELECT command to display the data from the worksheet.

// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM myRange1", objConn);

// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;

// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();

// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDataset1, "XLData");

// Bind data to DataGrid control.
DataGrid1.DataSource = objDataset1.Tables[0].DefaultView;
DataGrid1.DataBind();

// Clean up objects.
objConn.Close();