Welcome to Dream.In.Code
Become a VB.NET Expert!

Join 150,058 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 1,732 people online right now. Registration is fast and FREE... Join Now!




error in retriving data from db

 
Reply to this topicStart new topic

error in retriving data from db

a_a_s
6 Mar, 2008 - 05:57 AM
Post #1

D.I.C Head
**

Joined: 20 Feb, 2008
Posts: 67

the cod
CODE

con.Open()

        Dim sql As String = "SELECT * FROM Section"
        Dim da As New OleDbDataAdapter(sql, con)
        Dim ds As New DataSet
        da.Fill(ds, "Section")

the error maseg in the statement da.Fill(ds, "Section")
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Error In Retriving Data From Db
6 Mar, 2008 - 06:24 AM
Post #2

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 9,483



Thanked: 161 times
Dream Kudos: 9075
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
You're getting the IErrorInfo.GetDescription failed with E_FAIL(0x80004005). error because you're SQL query contains a reserved keyword. Change your SQL statement to


vb

Dim sql As String = "SELECT * FROM [Section]"

User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/8/09 10:32PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month