Solved

How to do Reporting from vb.net

Posted on 2009-05-15
2
223 Views
Last Modified: 2013-11-26
Hi Experts

I am new to reporting and would please like to know how to do a report from VB.net. I tried to use the Reporting Wizard but that requires a dataset/datasource. But I don't have any of those in my project, I connect to my database through code(see code). Can anyone please give me some useful tips, or links to help me out a bit. Any help would be greatly appreciated.

Thanx in advance
Dim con1 As New OleDb.OleDbConnection

            Dim ds1 As New DataSet
 

            Dim da1 As New OleDb.OleDbDataAdapter

            Dim sql1 As String

            Dim bm As New BindingSource
 

            con1.ConnectionString = "Provider=PervasiveOLEDB;Data Source=" & cpath
 

            con1.Open()

            sql1 = "SELECT row FROM table"

            da1 = New OleDb.OleDbDataAdapter(sql1, con1)

            da1.Fill(ds1, "Document")

            bm.DataSource = ds1.Tables("Document")
 

            con1.Close()

Open in new window

0
Comment
Question by:Benvor
2 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
0
 
LVL 15

Accepted Solution

by:
JackOfPH earned 500 total points
Comment Utility
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now