从excel中读出文字显示到datagrid上-ASP教程,ASP应用

dim mydataset as new dataset

dim myoledbconnection as oledbconnection = new oledbconnection("provider=microsoft.jet.oledb.4.0;" & _

"data source=d:\2.xls;" & _

"extended properties=""excel 8.0;""")

dim myoledbcommand as oledbcommand = new oledbcommand("select * from [sheet1$]", myoledbconnection)

dim mydata as oledbdataadapter = new oledbdataadapter(myoledbcommand)

mydata.fill(mydataset)

datagrid1.datasource = mydataset.tables(0).defaultview

datagrid1.databind()