excel导入GridView中,有标题!再将GridView中数据添加到数据库中

[jiang828253]

怎么设置excel导入到GridView中,不读取标题与负标题~~~

Function SelectExcel() As DataSet
Dim filename, name, strConn As String
filename = ViewState("path")
name = ddlExcel.SelectedValue.ToString()
Dim conn As OleDbConnection
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties='Excel 8.0;HDR=no;IMEX=1'"
conn = New OleDbConnection(strConn)
Dim myCommand As OleDbDataAdapter
myCommand = New OleDbDataAdapter("SELECT * FROM [" + name + "]", strConn)

myCommand.Fill(myDataSet)
GridView1.DataSource = myDataSet
GridView1.DataBind()
Return myDataSet
End Function

[Plougher]

Function SelectExcel() As DataSet
Dim filename, name, strConn As String
filename = ViewState( "path ")
name = ddlExcel.SelectedValue.ToString()
Dim conn As OleDbConnection
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filename + ";Extended Properties= 'Excel 8.0;HDR=no;IMEX=1 ' "
conn = New OleDbConnection(strConn)
Dim myCommand As OleDbDataAdapter
myCommand = New OleDbDataAdapter( "SELECT * FROM [ " + name + "$] ", strConn)

myCommand.Fill(myDataSet)
GridView1.DataSource = myDataSet
GridView1.DataBind()
Return myDataSet
End Function

[Plougher]

你把Excel当成的数据库的时候你得往表名后面家一个$（美元符号）才可以识别Excel表的