May 21, 2011 at 4:58 am
Dim con_exl As System.Data.OleDb.OleDbConnection
con_exl = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=C:\test.xls;Extended Properties=Excel 8.0;")
Dim testAdapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter()
testAdapter.TableMappings.Add("Table", "test")
con_exl.Open()
Dim testCommand As OleDb.OleDbCommand = New OleDb.OleDbCommand( _
"SELECT * FROM [test$];", con_exl)
testCommand.CommandType = CommandType.Text
test.SelectCommand = testCommand
Dim testDataSet As DataSet = New DataSet("test")
testAdapter.Fill(testDataSet)
DataGrid1.SetDataBinding(testDataSet, "test")
May 21, 2011 at 8:02 am
1. Do you have a question about the code?
a. Does the code when executed fail and return an error?
2. Does your code perform properly and you want to make it available to others?
May 23, 2011 at 4:50 am
The codes perform properly
But I don't have links to the source of codes .
In the architecture this situation is usually called eclectic.
Took something, but something forgotten .Today worked. Tomorrow might not work.
May 25, 2011 at 8:22 am
setiv (5/23/2011)
The codes perform properlyBut I don't have links to the source of codes .
In the architecture this situation is usually called eclectic.
Took something, but something forgotten .Today worked. Tomorrow might not work.
What do you mean you don't have links to the source code(s)?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 28, 2011 at 12:06 am
This is the starting point for not only my possible developments
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply