How to create a dynamic dataset with two datatable

Question

0.00/5 (No votes)

See more:

I want to create a dynamic dataset with two data table such that I can use the dataset in the crystal report I want to put the values from access database and put the values into the two data tables in the dataset Right now I am able to use one dataset and one data table in the crystal report

What I have tried:

Private Sub ChallanReports_Load(sender As Object, e As EventArgs) Handles MyBase.Load
If rpt2 = "ChallanBlack" Then
Dim objrpt As New ChallanBlack '' crystal report
Dim query As String = "select * from Challan where ChallID = " & dts2
Dim ad As OleDbDataAdapter = New OleDbDataAdapter(query, conn)
Dim ds As ChallanDataSet = New ChallanDataSet '''dataset
ad.Fill(ds, "Challan") '' datatable
objrpt.SetDataSource(ds)
CrystalReportViewer1.ReportSource = objrpt

ElseIf rpt2 = "BGLChallanBlack" Then
End If
End Sub
End Class

Posted 1-May-19 8:40am

NIRMAL90

Updated 1-May-19 10:58am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2019-05-01T10:59:00

Solution 1

If you have two tables and you want to create a view that contains data from both, create a view in your SQL Server and connect to that

Posted 1-May-19 10:59am

Christian Graus

Comments

NIRMAL90 1-May-19 21:27pm

i want to create the dataset dynamically and in the dataset there is 2 tables. currently, i am using one dataset with one table dynamically data is put in the datatable. but how to put in the two datatable in dataset dynamically

Christian Graus 1-May-19 21:28pm

A dataset is a class that exists to contain more than one table. That's easy to do.

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/dataset-datatable-dataview/adding-a-datatable-to-a-dataset

NIRMAL90 2-May-19 11:03am

The above code i am using to display record dynamically from dataset to datatable to crystal report. Please see the code and help me right now i can display only one table in crystal report i want to display records from 2 datatable from dataset

Christian Graus 2-May-19 17:45pm

Oh, it's a Crystal Reports question. If CR will only show data from one datatable, why not generate one table with all the data you need?

NIRMAL90 4-May-19 22:12pm

RIGHT NOW I HAVE DONE THAT ONLY

Christian Graus 4-May-19 22:13pm

So it's solved then?