ADO方式还可以导出数据到Excel,导出的时候,象操作数据库一样即可。
Create Table theTalbe (Field1 varchar,Field2 varchar);
public static DataTable ImportExcel(string fileName)
{
string xlsDriver = @ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;";
OleDbConnection cn = new OleDbConnection( string.Format(xlsDriver, fileName) );
cn.Open();
try
{
DataTable schema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"});
string tableName = schema.Rows[0][ "TABLE_NAME"].ToString();
OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + tableName + "]",cn);
DataSet ds = new DataSet();
da.Fill(ds);
da.Dispose();
cn.Dispose();
return ds.Tables[0];
}
catch(Exception ex)
{
MessageBox.Show( "对不起,数据导入出错!//n" + ex.Message,"出错",MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
finally
{
if (cn != null) cn.Dispose();
}
}