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
|