Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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.


Reply With Quote
  #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"]);
}


Reply With Quote
  #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,

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:58 AM.


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