Click here to Skip to main content
15,916,941 members

Comments by jus coding (Top 10 by date)

jus coding 19-Dec-11 1:53am View    
bro i want to display all the stored values of table in the listbox with the column name . other then listbox is there any other way to display the entire details of the table
jus coding 17-Dec-11 10:39am View    
ts getting connected but the error wat i am getting is " External table is not in the expected for

jus look at my code




Dim oledbCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\new2.xlsx;Extended Properties=""Excel 8.0;HDR=Yes;Format=xls;IMEX=1;""")


Dim oledbcommand As New OleDbCommand("select A from [{0}]")
oledbcommand.Connection = oledbCon

con.Close()
con.Open()
Dim da As New OleDbDataAdapter(oledbcommand)

Dim ds As New DataSet
da.Fill(ds)
Dim sa As String = ""
jus coding 17-Dec-11 10:36am View    
its getting connected but the error wat i am getting is " External table is not in the expected for

jus look at my code




Dim oledbCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\new2.xlsx;Extended Properties=""Excel 8.0;HDR=Yes;Format=xls;IMEX=1;""")


Dim oledbcommand As New OleDbCommand("select A from [{0}]")
oledbcommand.Connection = oledbCon

con.Close()
con.Open()
Dim da As New OleDbDataAdapter(oledbcommand)

Dim ds As New DataSet
da.Fill(ds)
Dim sa As String = ""
jus coding 12-Dec-11 3:08am View    
i dint get u buddy
jus coding 11-Dec-11 0:30am View    
so can u js tell me how can i over come with this error.