This is a migrated thread and some comments may be shown as answers.

Reporting Table

0 Answers 56 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
sree devi
Top achievements
Rank 1
sree devi asked on 28 Aug 2009, 03:59 PM
Hi,
I am using Telerik table to displaying data but it doesnt seem to do anything.
becausethe stored proc I use to call the data is working and it displays data but in 16 pages
displaying the results in each line in 16 pages.
My proc returns 16 results.
I am using dataset with report viewer.This is the code

public

 

void Acc_setup_report_S6(string strAccountnumber)

 

{

System.Data.OracleClient.

OracleConnection conn = new System.Data.OracleClient.OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString());

 

System.Data.OracleClient.

OracleCommand cmd = new System.Data.OracleClient.OracleCommand();

 

cmd.Connection = conn;

System.Data.OracleClient.

OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);

 

 

DataSet ds = new DataSet();

 

 

 

try

 

{

cmd.CommandText =

"pkg_csharp_reports.sprocAcc_setup_report_S6";

 

cmd.Parameters.Add(

"account_number_", OracleType.VarChar);

 

cmd.Parameters[

"account_number_"].Direction = ParameterDirection.Input;

 

cmd.Parameters.Add(

"ret_result_", OracleType.Cursor);

 

cmd.Parameters[

"ret_result_"].Direction = ParameterDirection.Output;

 

da.Fill(ds);

 

foreach (DataRow dr in ds.Tables[0].Rows)

 

{

 

// //this.textBox1.Value = dr["description"].ToString();

 

 

this.textBox1.Value = dr["fee"].ToString();

 

 

this.textBox2.Value = dr["payor"].ToString();

 

}

}

 

finally

 

{

cmd.Dispose();

 

if (conn.State == ConnectionState.Open)

 

conn.Close();

conn.Dispose();

}

 

//return ds;

 

}

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
sree devi
Top achievements
Rank 1
Share this question
or