Click here to Skip to main content
16,006,845 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: retriving images frm database Pin
Christian Graus28-Aug-07 2:04
protectorChristian Graus28-Aug-07 2:04 
GeneralRe: retriving images frm database Pin
diwa8528-Aug-07 3:04
diwa8528-Aug-07 3:04 
GeneralRe: retriving images frm database Pin
Christian Graus28-Aug-07 10:47
protectorChristian Graus28-Aug-07 10:47 
QuestionMIME type of MS Office 2007 word/xl documents Pin
kisna_madhusudan28-Aug-07 1:43
kisna_madhusudan28-Aug-07 1:43 
Questionproblem with dynamic option list Pin
prachishah28-Aug-07 0:40
prachishah28-Aug-07 0:40 
QuestionHow to access arraylist in javascript Pin
jophinmichael27-Aug-07 22:03
jophinmichael27-Aug-07 22:03 
AnswerRe: How to access arraylist in javascript Pin
Guffa28-Aug-07 6:55
Guffa28-Aug-07 6:55 
QuestionEXCEL FILE - Displaying the content per column Pin
hifiger200427-Aug-07 21:42
hifiger200427-Aug-07 21:42 
Hi Guys,

I am using ASP.Net 2.0 with VB code-behind page. But I have a problem in displaying the data from excel. It says that - "The microsoft Jet database engine could not find 'A1'. Make sure the object exists and that you spell its name and path name correctly."

And as I check my xls file there is a column for "A1".
Did I missed something in the source code?
Please refer to the source code below

I hope you can help me solving this problem. Thanks

Source Code:

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
' Create connection string variable. Modify the "Data Source"
' parameter as appropriate for your environment.
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=D:\sample\test.xls ;" _
& "Extended Properties=Excel 8.0;"

' Create connection object by using the preceding connection string.
Dim objConn As OleDbConnection = New OleDbConnection(sConnectionString)

' Open connection with the database.
objConn.Open()

' The code to follow uses a SQL SELECT command to display the data from the worksheet.
' Create new OleDbCommand to return data from worksheet.
Dim objCmdSelect As OleDbCommand = New OleDbCommand("Select * From A1", objConn)

' Create new OleDbDataAdapter that is used to build a DataSet
' based on the preceding SQL SELECT statement.
Dim objAdapter1 As OleDbDataAdapter = New OleDbDataAdapter()

' Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect

' Create new DataSet to hold information from the worksheet.
Dim objDataset1 As DataSet = New DataSet()

' Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDataset1, "XLData")

Dim dr As DataRow
For Each dr In objDataset1.Tables("XLData").Rows
MsgBox(dr("A1"))
Next

objConn.Close()
End Sub

hifiger2004

QuestionWSE 2.0 and Visual Studio 2005 Pin
Sikk-SikTh27-Aug-07 19:33
Sikk-SikTh27-Aug-07 19:33 
AnswerRe: WSE 2.0 and Visual Studio 2005 Pin
Sikk-SikTh30-Aug-07 10:49
Sikk-SikTh30-Aug-07 10:49 
Questionwebhosting Pin
kalyan_241627-Aug-07 18:10
kalyan_241627-Aug-07 18:10 
AnswerRe: webhosting Pin
Michael Sync28-Aug-07 19:53
Michael Sync28-Aug-07 19:53 
QuestionFree traditional ASP books Please Pin
Mohammed Amine27-Aug-07 14:11
Mohammed Amine27-Aug-07 14:11 
AnswerRe: Free traditional ASP books Please Pin
Fred_Smith27-Aug-07 14:22
Fred_Smith27-Aug-07 14:22 
AnswerRe: Free traditional ASP books Please Pin
scottgp28-Aug-07 5:25
professionalscottgp28-Aug-07 5:25 
GeneralRe: Free traditional ASP books Please Pin
Mohammed Amine28-Aug-07 13:59
Mohammed Amine28-Aug-07 13:59 
GeneralRe: Free traditional ASP books Please Pin
Christian Graus28-Aug-07 20:56
protectorChristian Graus28-Aug-07 20:56 
GeneralRe: Free traditional ASP books Please Pin
Sam Xavier25-Sep-07 3:24
Sam Xavier25-Sep-07 3:24 
QuestionHow to detect if a browser ... Pin
Xiangyang Liu 刘向阳27-Aug-07 7:32
Xiangyang Liu 刘向阳27-Aug-07 7:32 
AnswerRe: How to detect if a browser ... Pin
kuyak200027-Aug-07 19:47
kuyak200027-Aug-07 19:47 
GeneralRe: How to detect if a browser ... Pin
Xiangyang Liu 刘向阳28-Aug-07 5:27
Xiangyang Liu 刘向阳28-Aug-07 5:27 
QuestionWebsite Home Directory Pin
Ali Zater27-Aug-07 4:25
Ali Zater27-Aug-07 4:25 
Questionproblem with receiveing value of link Pin
prachishah26-Aug-07 23:34
prachishah26-Aug-07 23:34 
AnswerRe: problem with receiveing value of link Pin
rihdus27-Aug-07 1:31
rihdus27-Aug-07 1:31 
QuestionNeed a help on PHP code Pin
Kumar Arun26-Aug-07 19:36
Kumar Arun26-Aug-07 19:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.