关于excel中取出数据保存到dataGrid 的问题!!
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
namespace WindowsApplication1
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button button1;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
private string strConn;
private OleDbConnection myConn;
DataSet myDataSet = new DataSet();
public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=D:\\Documents and Settings\\liufan\\My Documents\\Visual Studio Projects\\Book1.xml;"+
"Extended Properties=Excel 8.0;";
myConn = new OleDbConnection(strConn);
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
**********************************************************************
//此处省略100行关于datagrid和button控件的初始化
**********************************************************************
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void button1_Click(object sender, System.EventArgs e)
{
// 得到dataset
DataSet myDS = this.GetInfo();
DataTable table = myDS.Tables["xxx"];
this.dataGrid1.DataSource = myDS;
dataGrid1.SetDataBinding(myDS,"xxx");
}
/// <summary>
/// 从excel中取到dataset
/// </summary>
/// <returns></returns>
private DataSet GetInfo()
{
try
{
OleDbDataAdapter myComm = new OleDbDataAdapter("SELECT * FROM [ContactList$]", strConn);
myComm.Fill(myDataSet);
}
catch(Exception ex)
{
string err = ex.Message;
}
return this.myDataSet;
}
}
}
*************************************************************************
我在D:\\Documents and Settings\\liufan\\My Documents\\Visual Studio Projects\\
中有个book.xml的excel文件,点击按扭 想把它当作数据库一样的读出来保存到datagrid中,但是没有成功。估计是这一句错的:OleDbDataAdapter myComm = new OleDbDataAdapter("SELECT * FROM [ContactList$]", strConn);
而且好象没有打开连接(myConn.Open())??
我是参照 : http://www.csdn.net/develop/article/15/15544.shtm 作的。
高手请指教。