new to datasets

[Aussie Rules]

Hi,

I have always just developed direct against SQL databases, so using a
dataset is a new concept to me.

I have to use a dataset now, as I can't point the crystal report designer to
a sqlexpress database where the database is attached in the vb application.


I used the add datasource wizard in my vb project, and I have now got a
datasetname.XSD in my projects solution. I am am to use this as a datasource
in the crystal designer

I have included all my sqlexpress table, views and stored procedures, as my
report do actually pull data from them all.


What I don't understand properly, is that it would seem that the dataset is
just a place holder or schema of the database, as when I run my reports
there is no data displayed.


How do I get the dataset to hold all the data from my database so that my
reports work?


Thanks

 

[Guest]

How do I get the dataset to hold all the data from my database so that
my reports work?

A dataset should only contain a small subset of data. If you hold all the
records in the database, you'll gobble up all your RAM.

 

[Aussie Rules]

So if i have numerous table that make up the data that my report needs I can
understand only populating with the data required.

In my old code ways way, i would do the following

Dim command1 As New SqlCommand("select sheet, sheetname from
dbo.feasibility where project_id = " & intProject, dbConnection)
Dim ds As New DataSet
Dim da As New SqlDataAdapter(command1)
da.Fill(ds, "WorkSheets")

This I understand.

But how do I populate this XSD dataset in my solution ???

It has multiple table, view etc...

 

[Terry]

I have to use a dataset now, as I can't point the crystal report designer to
a sqlexpress database where the database is attached in the vb application.

Why? I fon't understand this statement and seems to the heart of the
problem. Maybe you can explain a little further.

 

[Cor Ligthert[MVP]]

Hi,

You don't need a dataset for Crystal report, just open the object browser in
that and point the data to a stored SQL ("select") procedure.

Cor