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;
}