Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
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
 
Old August 24th, 2006, 08:47 AM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem on crystal report - oracle!

Hello freinds!
I'm trying to generate a report from Oracle DB. but
encountered to the Error that is explained in below.
please tell me, what can I do. (what command use
instead of "ExecuteXmlReader()" in my code? )
Thanks.


private void Form1_Load(object sender, EventArgs e)
{
  OracleConnection con = new OracleConnection("Data Source=almaee;Persist Security Info=True;User ID=test;Password=test");

            OracleCommand cmd = con.CreateCommand();

            cmd.CommandText = "SELECT PANCH_BRANCH_CODE, ADDRES1, FAMILY, GCIT_ID, ID FROM GL_TL_CUSTOMERS FOR XML AUTO";

            DataSet dtset = new DataSet();

            con.Open();

            dtset.ReadXml(cmd.[u]ExecuteXmlReader()</u>);

            con.Close();

            CrystalReport1 rpt = new CrystalReport1();

            rpt.SetDataSource(dtset);

            cmd.Dispose();

            if(con.State == ConnectionState.Open)
                con.Dispose();

            dtset.Dispose();
        }


[u]compiler Error is:</u>Error 1 'System.Data.OracleClient.OracleCommand' does not contain a definition for 'ExecuteXmlReader' E:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\printingTest4\printingTest4\Form1.cs 28 31 printingTest4


sohrab_nas





Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle to Crystal Report abhijhegde Crystal Reports 0 May 14th, 2007 09:05 PM
problem with oracle & crystal report with Vb abhijhegde Beginning VB 6 1 May 3rd, 2007 12:03 PM
Display Vietnamese in Crystal Report(DB Oracle) Christian_tm Crystal Reports 0 June 14th, 2006 02:49 AM
Crystal Report using Partition of a Oracle Table [email protected] BOOK: Professional Crystal Reports for VS.NET 0 April 18th, 2005 08:09 PM
export crystal report with oracle db in VB g-mey Pro VB Databases 0 February 8th, 2005 12:28 AM





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