populating a DataTable in a DataSet

[Wilfried Mestdagh]

Hi,

I have done following: Add new item - Dataset, then add DataTable, and
add a few fields (VS2005) because this seems the only way to let a
Crystalreport recognize a datatable in the project.

Now the problem, should be simple but I cannot find it. How can I
populate the dataTable in code ? I don't need a connection to a
database and so.

 

[Dave Sexton]

Hi Wilfried,

Here's a simplified example:

"How To: Fill a DataSet with Data":
http://msdn2.microsoft.com/en-us/library/ms171920(VS.80).aspx

 

[Dave Sexton]

Hi Wilfried,

I'm sorry, I just realized you wrote "don't" need a connection to a database.

In that case, here's a simple example. Assuming that you have a strong-typed
DataSet named, "PeopleData" that contains a single DataTable named, "People",
which only contains a single column named, "Name" of type System.String, you
could do the following:

PeopleData data = new PeopleData();
data.People.AddPeopleRow("Joe");
data.People.AddPeopleRow("Fred");
data.AcceptChanges();

HTH

 

[Brendon Bezuidenhout]

Heya Wilfried,

Daft question - but re your Crystal Report - Are you attempting to
dynamically alter the design and such of the CrystalReport proper? If so a
heads up of a headache that I had to find out the hard way - You can't with
the API and CrystalReports namespace that is shipped with VS2005...

If not ignore me

Brendon

 

[Wilfried Mestdagh]

Hi Dave,

Thanks I give that a try

 

[Wilfried Mestdagh]

Hy Brendon,

Yes and no, but I just discovered ReportViewer witch seems very much
simpler to work with. Also it understand Object Data Sources, which I
think this is improvement. Now I have to learn these things too

--
rgds, Wilfried [MapPoint MVP]
http://www.mestdagh.biz

Heya Wilfried,

Daft question - but re your Crystal Report - Are you attempting to
dynamically alter the design and such of the CrystalReport proper? If so
a heads up of a headache that I had to find out the hard way - You can't
with the API and CrystalReports namespace that is shipped with VS2005...

If not ignore me

Brendon

 

[Guest]

Here is an alternate way (not using strongly typed):

DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("TEST");
DataRow row ;
for(int i = 0;i<3;i++)
{
row=dt.NewRow();
row["TEST"] ="Howdy " +i.ToString();
dt.Rows.Add(row);
}
ds.Tables.Add(dt);

Done! Cheers,

Peter