Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 14th, 2003, 11:46 PM
Authorized User
 
Join Date: Oct 2003
Location: , , Singapore.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Report Database Connection

Hi!
I got many reports to be viewed in the crystal report.
I'm not sure which database connection to be used for the link.
I will be using a lot of view sql.

1) Which of the database connection best fit to many reports.
ADO.Net, OLE DB, ODBD RDO etc..

2) For Ado.NET, will it allow more than 1 table or 1 view in a dataset?
How to update the dataset if I update or add fields in the sqlServer?
I've been noticed that the dataset will not auto-refresh or update if
I add field in the sqlServer.

Please Help.
thanks.


  #2 (permalink)  
Old October 15th, 2003, 01:05 AM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to TEDY Send a message via MSN to TEDY
Default

hey i'm going to do same way probably...

i been thinking about using:

sqlcon
sql data adapter
dataset
datagrid

so i think :

fill a dataset with data from the data source, and upddate the data source with any changes made in the dataset.

this.sqlDataAdapter.Fill(this.ds, "Name of Table");
Meanwhile you can add a DataGrid etc....
using commands like delete,insert,select

So basically reading Data with the DataSet looks like:

- fill the dataset with data
- access tables, rows and columns in the dataset

using System;
using System.Data;
using System.Data.SqlClient;

public static void Main()

SqlConnection thisConnection = new SqlConnection

@"DataSource=(local);Integrated Security=SSPI;" + "Initial Catalog=northwing");

SqlDataAdapter thisAdapter = new SqlDataAdapter;
("SELECT CustomerID, ContactName FROM Customers"; thisConnection);

DataSet thisDataSet = new Dataset();

thisAdapter.Fill(thisDataSet, "Customers");
foreach(DataRow theRow in this DataSet.Tables["Customers"].Rows)
{
  Console.WriteLine(theRow["CustomersID"] + "\t" + theRow["ContactName"]);
}


  #3 (permalink)  
Old October 15th, 2003, 07:50 PM
Authorized User
 
Join Date: Oct 2003
Location: , , Singapore.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Tedy,

Thanks.

I'm using a lot of 'View' from Sql 2000.
1) Can I use multiples 'View' in one dataset (ado.net)?
or Only one view allowed in one dataset?

2) I will have use more than 10 *.rpt for crystal report connected to sql 2000. eg. If I hv 10 *.rpt to be viewed in 10 pages and using ADO.Net; Do I need to have 10 Dataset as well?

Please Assist me, Thanks a lot.

Rgds,



Similar Threads
Thread Thread Starter Forum Replies Last Post
CRYSTAL REPORT 9 Changing Connection Properties aquiintac VB Components 0 November 6th, 2007 05:17 AM
vb connection with crystal report freeska Pro VB 6 2 September 19th, 2007 10:30 PM
Problem in Connection Property of Crystal report 9 polravi Pro VB 6 0 February 8th, 2006 09:59 AM
Crystal Report Connection using C# in ASP .net junaidameen Crystal Reports 1 September 25th, 2005 12:11 PM
crystal report 8.0 connection with oracle 8i perso shah_sameer82 Crystal Reports 1 June 7th, 2004 12:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.